I have a serious problem: on Wednesday, April 2 OpenSUSE 12.1 is updated, and the package was to update the PostGIS-a version 1.5.3 to 2.0.0. After this operation, Postgres does not display records. In pgAdmin count the records, but seeing them in a table view, and by SELECT is a problem. I can not do dump: pg_dump-h 127.0.0.1-p 5432-U postgres-Fc-b-v-f "/ home / admin / olddb.backup" Tomice
I get the message: pg_dump: SQL command failed pg_dump: Communication error with server :: ERROR: can not access the file "$ libdir/postgis-1.5 ': No such file or directory pg_dump: Your command: COPY public.armatura (gid, type, sub_typ, description, wys_g, wys_d, operator, the_geom) TO stdout; pg_dump: *** stopped because of an error
In view of the tables in PgAdminie my tables, I have a good number of records, but when you call the data is still the same.
I noticed that almost all functions have the following address: "$ libdir/postgis-1.5" that during the upgrade-u has been replaced by / PostGIS-2.0. I could perhaps remove the column geometry, but at the base of my ...
I attach screenshots of pgAdmin. Command did not help, sql for good-sounded names: postgis_upgrade_2.0.sql etc. .. Suddenly all the repositories of RPMs flown for PostGIS 1.5.3, and I can not go back to the old version ... At stake is 1 working day to 15 people. If anyone has any idea - I'll be bound.
I have no idea to solve this problem.
2 Answers 2
Revert your software to 1.5, then follow the HARD UPGRADE instructions in the manual, doing the dump step, then the software upgrade, then the restore steps. http://postgis.net/docs/manual-1.5/ch02.html#hard_upgrade
-
1Hi, its really great that in a few hours my problem was resolved. After revert the PostGIS to 1.5, I had all my data back. Your answer was really helpful. Thank you a lot.tomsik– tomsik2012年04月06日 06:14:27 +00:00Commented Apr 6, 2012 at 6:14
-
1The link moved to postgis.refractions.net/documentation/manual-2.0/…alfonx– alfonx2012年04月15日 19:33:36 +00:00Commented Apr 15, 2012 at 19:33
I am a maintainer at Application:Geo. I will restore postgis 1.5.3 binaries in the next few hours.
If you are in a hurry check http://download.opensuse.org/repositories/home:/tzotsos:/postgis/openSUSE_12.1/ where the old binary is posted now.
Thanks for the report, Angelos
-
All done ! Thank You for help, the repository was changed, I was revert the PostGIS to 1.5.3 and all my databases back! I didn't expect that quick and professional response. I describe this case in the Polish forum QGIS. Thanks a lot Angelos.tomsik– tomsik2012年04月06日 06:05:38 +00:00Commented Apr 6, 2012 at 6:05
-
after the 15 reputations :-) only ...tomsik– tomsik2012年04月06日 09:37:42 +00:00Commented Apr 6, 2012 at 9:37