Обсуждение: probs with 7.3 -> 7.4 on debian
Hi all Debian has upgraded me to 7.4 ofpostgres, but when it tries to start postgres I get an error mentioning that the data is in 7.3 format and needs to be upgraded to 7.4 format before postmaster will start. "dpkg-reconfigure postgresql" attempts to do just this for me, but fails during upgrade. so I follow the instructions in README.Debian.migration like so: odin:~# su -s /bin/bash - postgres postgres@odin:~$ postgresql-dump -t db.out -dcivlp $PGDATA/../data.save Stopping and restarting the postmaster /var/lib/postgres/dumpall/7.3/postmaster -D /var/lib/postgres/data -p 5431 -o -d0 /var/lib/postgres/dumpall/7.3/postmaster: error while loading shared libraries: libcom_err.so.1: cannot open shared object file: No such file or directory Failed to start the postmaster postgres@odin:~$ Is any one able to point me the right way from here? Thanks Glenn
On Wed, 2004-01-14 at 14:47, glenn wrote: > Hi all > Debian has upgraded me to 7.4 ofpostgres, but when it tries to start > postgres I get an error mentioning that the data is in 7.3 format and > needs to be upgraded to 7.4 format before postmaster will start. > > > "dpkg-reconfigure postgresql" attempts to do just this for me, but fails > during upgrade. > > so I follow the instructions in README.Debian.migration like so: > > odin:~# su -s /bin/bash - postgres > postgres@odin:~$ postgresql-dump -t db.out -dcivlp $PGDATA/../data.save > Stopping and restarting the postmaster > /var/lib/postgres/dumpall/7.3/postmaster -D /var/lib/postgres/data -p > 5431 -o -d0 > /var/lib/postgres/dumpall/7.3/postmaster: error while loading shared > libraries: libcom_err.so.1: cannot open shared object file: No such file > or directory > Failed to start the postmaster > postgres@odin:~$ > > Is any one able to point me the right way from here? Yes, this is a known problem. Look at http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=225812 and http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=225635 Solution: If you have an up to date dump, move $PGDATA aside, initdb and load your dump. Otherwise: rm -rf /var/lib/postgres/dumpall/7.3/ reinstall 7.3.4-9 from testing for the packages postgresql, postgresql-client and libpq3; use dpkg --force-downgrade --force-depends --force-conflicts to do it - it's only for a few minutes. Make a dump now reinstall 7.4.1 - this time the upgrade should work, and if not, you can do a manual upgrade with your just-taken dump as shown above . -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight, UK http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "If we confess our sins, he is faithful and just to forgive us our sins, and to cleanse us from all unrighteousness." I John 1:9 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
outstanding - thanks, this is a big relief :-)
FYI - automatic upgrade still failed, but at least I could use the
db.out I made after downgrade.
Now if only I could connect through TCP.
local connect such as:
glenn@odin$:psql mydb
works fine
tcp connect such as
glenn@odin$:psql -h odin mydb
psql: could not connect to server: Connection refused
Is the server running on host "odin" and accepting
TCP/IP connections on port 5432?
fails - tried IP addresses, and localhost etc.
ahh - check /etc/postgresql/postgresql.conf!
tcpip_socket = true
oh :-(
I read in list archives that this reveals much:
netstat -nlp|grep 5432
unix 2 [ ACC ] STREAM LISTENING 2235850
13581/postmaster /var/run/postgresql/.s.PGSQL.5432
But I think this is a good outcome? i.e. server _is_ served and
listening on port 5432?
pg_hba.conf is essentially the same as the way it was in 7.3 pre
upgrade, but with the IP6 changes now included.
Can anyone tell me what I'm missing?
Thanks
Glenn
On Wed, 2004-01-14 at 14:47, glenn wrote: > Hi all > Debian has upgraded me to 7.4 ofpostgres, but when it tries to start > postgres I get an error mentioning that the data is in 7.3 format and > needs to be upgraded to 7.4 format before postmaster will start. > > > "dpkg-reconfigure postgresql" attempts to do just this for me, but fails > during upgrade. > > so I follow the instructions in README.Debian.migration like so: > > odin:~# su -s /bin/bash - postgres > postgres@odin:~$ postgresql-dump -t db.out -dcivlp $PGDATA/../data.save > Stopping and restarting the postmaster > /var/lib/postgres/dumpall/7.3/postmaster -D /var/lib/postgres/data -p > 5431 -o -d0 > /var/lib/postgres/dumpall/7.3/postmaster: error while loading shared > libraries: libcom_err.so.1: cannot open shared object file: No such file > or directory > Failed to start the postmaster > postgres@odin:~$ > > Is any one able to point me the right way from here? Yes, this is a known problem. Look at http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=225812 and http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=225635 Solution: If you have an up to date dump, move $PGDATA aside, initdb and load your dump. Otherwise: rm -rf /var/lib/postgres/dumpall/7.3/ reinstall 7.3.4-9 from testing for the packages postgresql, postgresql-client and libpq3; use dpkg --force-downgrade --force-depends --force-conflicts to do it - it's only for a few minutes. Make a dump now reinstall 7.4.1 - this time the upgrade should work, and if not, you can do a manual upgrade with your just-taken dump as shown above . -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight, UK http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "If we confess our sins, he is faithful and just to forgive us our sins, and to cleanse us from all unrighteousness." I John 1:9 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match