But is it correct that to be able to create a backup, tables creating these errors must be dropped from the DB before a proper backup can be done? I could not continue my backup process before these tables were dropped.
Thank you for your help Sandro. Andreas 2011/8/17 Sandro Santilli <s...@keybit.net> > On Wed, Aug 17, 2011 at 04:03:43PM +0200, Andreas Forø Tollefsen wrote: > > Great. Thank you Sandro. > > > > That worked. I managed to install the 6874 SVN and are now able to query > the > > geometry columns as well. > > > > I then tried to backup the database, but got an error on two of my tables > > regarding the function postgis_typmod_out. > > Both of the tables in question have been read from a CSV file into a > table > > in the database. I dropped these tables and now i can backup the > database. > > The complete error: "ERROR: could not find the function > "postgis_typmod_out" > > in file "/usr/lib/postgresql/8.4/lib/postgis-2.0.so" > > Don't worry about those, must be new functions defined in newer postgis > that weren't available in older one. > > > By the way. Can i actually have two databases built from two different > SVN > > revisions at the same time? Is that possible at all? > > Not easily. > You'd have to install libraries in two different directories and reference > the correct one from each postgis.sql file. > > --strk; > > () Free GIS & Flash consultant/developer > /\ http://strk.keybit.net/services.html > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users