7

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.

PolyGeo
65.5k29 gold badges115 silver badges349 bronze badges
asked Apr 5, 2012 at 20:31
0

2 Answers 2

6

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

answered Apr 5, 2012 at 20:57
2
  • 1
    Hi, 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. Commented Apr 6, 2012 at 6:14
  • 1
    The link moved to postgis.refractions.net/documentation/manual-2.0/… Commented Apr 15, 2012 at 19:33
4

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

answered Apr 5, 2012 at 22:36
2
  • 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. Commented Apr 6, 2012 at 6:05
  • after the 15 reputations :-) only ... Commented Apr 6, 2012 at 9:37

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.