Bug#441794: postgresql-8.2-postgis: upgrade to 1.3.1 make old database unusable
Package: postgresql-8.2-postgis Version: 1.3.1-1 Severity: important Hi, the uprade to postgis 1.3.1 makes the old databases unusable, because the database are not upgradet to the new liblwgeom.so. The /usr/share/postgresql-8.2-postgis/lwpostgis_upgrade.sql script does not work: ERROR: could not access file /usr/lib/postgresql/8.2/lib/liblwgeom.so.1.2: No such file or directory -- System Information: Debian Release: lenny/sid APT prefers unstable APT policy: (860, 'unstable'), (850, 'testing'), (800, 'stable') Architecture: amd64 (x86_64) Kernel: Linux 2.6.22.1 (SMP w/2 CPU cores) Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968) Shell: /bin/sh linked to /bin/dash Versions of packages postgresql-8.2-postgis depends on: ii libc6 2.6.1-2GNU C Library: Shared libraries ii libgeos-c12.2.3-3Geometry engine for Geographic Inf ii postgis 1.3.1-1geographic objects support for Pos ii postgresql-8.28.2.4-3object-relational SQL database, ve ii proj 4.5.0-2Cartographic projection filter and postgresql-8.2-postgis recommends no packages. -- no debconf information -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Bug#441797: postgresql-8.2-postgis: upgrade to 1.3.1 make old databases unusable
Package: postgresql-8.2-postgis Version: 1.3.1-1 Severity: important Hi, the uprade to postgis 1.3.1 makes the old databases unusable, because the databases are not upgradet to the new liblwgeom.so The /usr/share/postgresql-8.2-postgis/lwpostgis_upgrade.sql script does not work: psql:/usr/share/postgresql-8.2-postgis/lwpostgis_upgrade.sql:38: ERROR: could not access file /usr/lib/postgresql/8.2/lib/liblwgeom.so.1.2: No such file or directory ingo -- System Information: Debian Release: lenny/sid APT prefers unstable APT policy: (860, 'unstable'), (850, 'testing'), (800, 'stable') Architecture: amd64 (x86_64) Kernel: Linux 2.6.22.1 (SMP w/2 CPU cores) Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968) Shell: /bin/sh linked to /bin/dash Versions of packages postgresql-8.2-postgis depends on: ii libc6 2.6.1-2GNU C Library: Shared libraries ii libgeos-c12.2.3-3Geometry engine for Geographic Inf ii postgis 1.3.1-1geographic objects support for Pos ii postgresql-8.28.2.4-3object-relational SQL database, ve ii proj 4.5.0-2Cartographic projection filter and postgresql-8.2-postgis recommends no packages. -- no debconf information -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Bug#441797: postgresql-8.2-postgis: upgrade to 1.3.1 make old database unusable
a quick solution is to manualy copy the liblwgeom.so.1.2 from the lenny-package to /usr/lib/postgresql/8.2/lib/liblwgeom.so.1.2 then run /usr/share/postgresql-8.2-postgis/lwpostgis_upgrade.sql for every old postgis-database. After this you can delete liblwgeom.so.1.2 -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Bug#307888: postgresql: upgrade to 7.4.7-6 does not succeed
The postinstall script will return with errors and the upgrade will fail if a database is not accessible. Some possible reasons are: - datallowconn=false - data directory not available Quick-Fix: make the database accessible before upgrade to 7.4.7-6 eg: psql -c update pg_database SET datallowconn=true WHERE datname='databasename' template1 Greetings Ingo Klinkmann -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]