Re: PostgreSQL 7.4.7-6sarge3 to bpo postgresql-8.1
The results are not good...
On Thu, 21 Sep 2006, Micha Lenk wrote:
Please Louis,
1. read the instructions on
http://www.backports.org/dokuwiki/doku.php?id=instructions
Done.
sources.list includes:
deb http://www.backports.org/debian sarge-backports main contrib non-free
preferences contains:
Package: postgresql-8.1
Pin: release a=sarge-backports
Pin-Priority: 999
caritas:~# aptitude -t sarge-backports install postgresql-8.1
Reading package lists... Done
Building dependency tree... Done
Reading extended state information
Initializing package states... Done
Reading task descriptions... Done
No candidate version found for postgresql-8.1
W: Couldn't stat source package list http://www.backports.org
sarge-backports/main Packages
(/var/lib/apt/lists/www.backports.org_debian_dists_sarge-backports_main_binary-i386_Packages)
- stat (2 No such file or directory)
W: Couldn't stat source package list http://www.backports.org
sarge-backports/contrib Packages
(/var/lib/apt/lists/www.backports.org_debian_dists_sarge-backports_contrib_binary-i386_Packages)
- stat (2 No such file or directory)
W: Couldn't stat source package list http://www.backports.org
sarge-backports/non-free Packages
(/var/lib/apt/lists/www.backports.org_debian_dists_sarge-backports_non-free_binary-i386_Packages)
- stat (2 No such file or directory)
W: Couldn't stat source package list http://www.backports.org
sarge-backports/main Packages
(/var/lib/apt/lists/www.backports.org_debian_dists_sarge-backports_main_binary-i386_Packages)
- stat (2 No such file or directory)
W: Couldn't stat source package list http://www.backports.org
sarge-backports/contrib Packages
(/var/lib/apt/lists/www.backports.org_debian_dists_sarge-backports_contrib_binary-i386_Packages)
- stat (2 No such file or directory)
W: Couldn't stat source package list http://www.backports.org
sarge-backports/non-free Packages
(/var/lib/apt/lists/www.backports.org_debian_dists_sarge-backports_non-free_binary-i386_Packages)
- stat (2 No such file or directory)
W: You may want to update the package lists to correct these missing files
No packages will be installed, upgraded, or removed.
0 packages upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
Need to get 0B of archives. After unpacking 0B will be used.
Writing extended state information... Done
Reading package lists... Done
Building dependency tree... Done
Reading extended state information
Initializing package states... Done
Reading task descriptions... Done
W: Couldn't stat source package list http://www.backports.org
sarge-backports/main Packages
(/var/lib/apt/lists/www.backports.org_debian_dists_sarge-backports_main_binary-i386_Packages)
- stat (2 No such file or directory)
W: Couldn't stat source package list http://www.backports.org
sarge-backports/contrib Packages
(/var/lib/apt/lists/www.backports.org_debian_dists_sarge-backports_contrib_binary-i386_Packages)
- stat (2 No such file or directory)
W: Couldn't stat source package list http://www.backports.org
sarge-backports/non-free Packages
(/var/lib/apt/lists/www.backports.org_debian_dists_sarge-backports_non-free_binary-i386_Packages)
- stat (2 No such file or directory)
W: You may want to update the package lists to correct these missing files
then I did
apt-get update
caritas:~# aptitude -t sarge-backports install postgresql-8.1
Reading package lists... Done
Building dependency tree... Done
Reading extended state information
Initializing package states... Done
Reading task descriptions... Done
The following packages are unused and will be REMOVED:
libdbd-pg-perl libdbi-perl libnet-daemon-perl libpg-perl libplrpc-perl
The following NEW packages will be automatically installed:
libpq4 postgresql-client-8.1 postgresql-client-common postgresql-common
The following packages will be automatically REMOVED:
postgresql postgresql-client postgresql-contrib
The following packages have been kept back:
alsa-base alsa-utils apt apt-doc apt-utils auctex bash bash-builtins
bash-doc bind9-host bogofilter ca-certificates cdrdao chkrootkit
comerr-dev cupsys cupsys-bsd cupsys-client cupsys-driver-gimpprint
debhelper debiandoc-sgml debiandoc-sgml-doc devscripts discover1
discover1-data dmidecode dnsutils dvd+rw-tools e2fslibs e2fsprogs
ethereal ethereal-common exim4 exim4-base exim4-config
.
.
.
xlibs-static-dev xnest xserver-common xserver-xfree86 xterm xutils xvfb
The following NEW packages will be installed:
libpq4 postgresql-8.1 postgresql-client-8.1 postgresql-client-common
postgresql-common
The following packages will be REMOVED:
postgresql postgresql-client postgresql-contrib
The following packages will be upgraded:
lsb-base ssl-cert
2 packages upgraded, 5 newly installed, 8 to remove and 217 not upgraded.
Need to get 6121kB of archives. After unpacking 3013kB will be used.
Do you want to continue? [Y/n/?]
Writing extended state information... Done
Get:1 http://www.backports.org sarge-backports/main lsb-base 3.1-9bpo1
[13.9kB]
Get:2 http://www.backports.org sarge-backports/main libpq4 8.1.4-6~bpo.1
[260kB]
Get:3 http://www.backports.org sarge-backports/main
postgresql-client-common 59~bpo.1 [36.9kB]
Get:4 http://www.backports.org sarge-backports/main postgresql-client-8.1
8.1.4-6~bpo.1 [1390kB]
Get:5 http://www.backports.org sarge-backports/main ssl-cert 1.0.12bpo1
[9532B]
Get:6 http://www.backports.org sarge-backports/main postgresql-common
59~bpo.1 [92.9kB]
Get:7 http://www.backports.org sarge-backports/main postgresql-8.1
8.1.4-6~bpo.1 [4318kB]
Fetched 6121kB in 59s (102kB/s)
Reading package fields... Done
Reading package status... Done
Retrieving bug reports... Done
critical bugs of postgresql-8.1 ( -> 8.1.4-6~bpo.1) <done>
#347271 - postgresql-8.1: Version 8.1.2 Released
grave bugs of ssl-cert (1.0-11 -> 1.0.12bpo1) <done>
#365925 - ssl-cert: post-installation script exits with error 1
Summary:
postgresql-8.1(1 bug), ssl-cert(1 bug)
Are you sure you want to install/upgrade the above packages? [Y/n/?/...]
Reading changelogs...
Preconfiguring packages ...
(Reading database ... 138216 files and directories currently installed.)
Removing postgresql-contrib ...
autovacuum stopped
Removing libdbd-pg-perl ...
Removing libdbi-perl ...
Removing libplrpc-perl ...
Removing libnet-daemon-perl ...
Removing libpg-perl ...
Removing postgresql ...
Stopping PostgreSQL database server: postmaster.
Removing postgresql-client ...
(Reading database ... 137581 files and directories currently installed.)
Preparing to replace lsb-base 2.0-7 (using .../lsb-base_3.1-9bpo1_all.deb)
...
Unpacking replacement lsb-base ...
Selecting previously deselected package libpq4.
Unpacking libpq4 (from .../libpq4_8.1.4-6~bpo.1_i386.deb) ...
Selecting previously deselected package postgresql-client-common.
Unpacking postgresql-client-common (from
.../postgresql-client-common_59~bpo.1_all.deb) ...
Selecting previously deselected package postgresql-client-8.1.
Unpacking postgresql-client-8.1 (from
.../postgresql-client-8.1_8.1.4-6~bpo.1_i386.deb) ...
Preparing to replace ssl-cert 1.0-11 (using
.../ssl-cert_1.0.12bpo1_all.deb) ...
Unpacking replacement ssl-cert ...
Selecting previously deselected package postgresql-common.
Unpacking postgresql-common (from .../postgresql-common_59~bpo.1_all.deb)
...
**** ERROR ****
Package "postgresql" must either be purged or upgraded to 7.5.x for a
clean transition.
***************
dpkg: error processing
/var/cache/apt/archives/postgresql-common_59~bpo.1_all.deb (--unpack):
subprocess pre-installation script returned error exit status 1
Unpacking postgresql-8.1 (from .../postgresql-8.1_8.1.4-6~bpo.1_i386.deb)
...
Errors were encountered while processing:
/var/cache/apt/archives/postgresql-common_59~bpo.1_all.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)
Ack! Something bad happened while installing packages. Trying to
recover:
Setting up libpq4 (8.1.4-6~bpo.1) ...
Setting up lsb-base (3.1-9bpo1) ...
Setting up ssl-cert (1.0.12bpo1) ...
Setting up postgresql-client-common (59~bpo.1) ...
Setting up postgresql-client-8.1 (8.1.4-6~bpo.1) ...
dpkg: dependency problems prevent configuration of postgresql-8.1:
postgresql-8.1 depends on postgresql-common (>= 39); however:
Package postgresql-common is not installed.
dpkg: error processing postgresql-8.1 (--configure):
dependency problems - leaving unconfigured
Errors were encountered while processing:
postgresql-8.1
Reading package lists... Done
Building dependency tree... Done
Reading extended state information
Initializing package states... Done
Reading task descriptions... Done
######################################################################
...At this point my production databases are unreachable...
######################################################################
caritas:~# aptitude -t sarge-backports install postgresql
Reading package lists... Done
Building dependency tree... Done
Reading extended state information
Initializing package states... Done
Reading task descriptions... Done
The following packages are unused and will be REMOVED:
libpq4
The following NEW packages will be automatically installed:
postgresql-client
The following packages will be automatically REMOVED:
postgresql-8.1 postgresql-client-8.1 postgresql-client-common
The following packages have been kept back:
.
.
.
The following NEW packages will be installed:
postgresql postgresql-client
The following packages will be REMOVED:
postgresql-8.1 postgresql-client-8.1 postgresql-client-common
0 packages upgraded, 2 newly installed, 4 to remove and 217 not upgraded.
Need to get 4339kB of archives. After unpacking 6975kB will be freed.
Do you want to continue? [Y/n/?]
The following NEW packages will be installed:
postgresql postgresql-client
The following packages will be REMOVED:
postgresql-8.1 postgresql-client-8.1 postgresql-client-common
0 packages upgraded, 2 newly installed, 4 to remove and 217 not upgraded.
Need to get 4339kB of archives. After unpacking 6975kB will be freed.
Do you want to continue? [Y/n/?]
Writing extended state information... Done
Get:1 http://http.us.debian.org stable/main postgresql-client
7.4.7-6sarge3 [540kB]
Get:2 http://http.us.debian.org stable/main postgresql 7.4.7-6sarge3
[3799kB]
Fetched 4339kB in 21s (201kB/s)
Reading package fields... Done
Reading package status... Done
Retrieving bug reports... Done
grave bugs of postgresql-client (7.4.7-6sarge3 -> 7.4.7-6sarge3) <done>
#362419 - mydns-pgsql: package cannot be installed
Summary:
postgresql-client(1 bug)
Are you sure you want to install/upgrade the above packages? [Y/n/?/...]
Y
Preconfiguring packages ...
(Reading database ... 138556 files and directories currently installed.)
Removing postgresql-8.1 ...
Removing postgresql-client-8.1 ...
Removing libpq4 ...
Removing postgresql-client-common ...
Selecting previously deselected package postgresql-client.
(Reading database ... 137585 files and directories currently installed.)
Unpacking postgresql-client (from
.../postgresql-client_7.4.7-6sarge3_i386.deb) ...
Selecting previously deselected package postgresql.
Unpacking postgresql (from .../postgresql_7.4.7-6sarge3_i386.deb) ...
Setting up postgresql-client (7.4.7-6sarge3) ...
Setting up postgresql (7.4.7-6sarge3) ...
Reading package lists... Done
Building dependency tree... Done
Reading extended state information
Initializing package states... Done
Reading task descriptions... Done
####################################################################
my databases are back, but then, I am also where I started
####################################################################
Also, pg_dump and pg_dumpall from 7.4.7 are not reading into
an 8.1 database.
Whether for backports or for debian testing, this is a showstopper.
2. do not reply on threads of different topic.
lbmlist@hethcote.com schrieb:
Is this possible with an existing 7.4.x database?
Selecting previously deselected package postgresql-8.1.
dpkg: regarding .../postgresql-8.1_8.1.4-6~bpo.1_i386.deb containing
postgresql-8.1:
postgresql-8.1 conflicts with postgresql (<< 7.5)
postgresql (version 7.4.7-6sarge3) is installed.
dpkg: error processing
/home/lbmoore/downloads/postgresql-8.1_8.1.4-6~bpo.1_i386.deb (--install):
conflicting packages - not installing postgresql-8.1
It sort of looks like the pg_dump from postgresql (<< 7.5) might not be
readable in 8.1
No, this conclusion non-sense.
If you've edited your /etc/apt/preferences as described on www.backports.org
instructions you can easily install what you want with this command:
aptitude -t sarge-backports install postgresql-8.1
HTH
Micha
Needing help,
Louis
Reply to: