Hmm .. I seem to have reached a catch-22. I had 7.2 installed, apt-upgraded to 7.8.4 I tried to apt-remove and then reinstall postgres, which may have just removed parts of 7.2 When I try to run 'postgresql-dump', it fails telling me it cannot start the postmaster.
> Tux:~# su -s /bin/bash - postgres > [EMAIL PROTECTED]:~$ postgresql-dump -t db.out -dcivlp $PGDATA/../data.save > Stopping and restarting the postmaster > /var/lib/postgres/dumpall/7.2/postmaster -D /var/lib/postgres/data -p > 5431 -o - d0 > /var/lib/postgres/dumpall/7.2/postmaster: error while loading shared > libraries: libssl.so.0.9.6: cannot open shared object file: No such > file or directory > Failed to start the postmaster > [EMAIL PROTECTED]:~$ nohup postmaster >logfile 2>&1 </dev/null & > [1] 9291 > [EMAIL PROTECTED]:~$ postgresql-dump -t db.out -dcivlp $PGDATA/../data.save > Stopping and restarting the postmaster > /var/lib/postgres/dumpall/7.2/postmaster -D /var/lib/postgres/data -p > 5431 -o - d0 > /var/lib/postgres/dumpall/7.2/postmaster: error while loading shared > libraries: libssl.so.0.9.6: cannot open shared object file: No such > file or directory > Failed to start the postmaster > [1]+ Exit 1 nohup postmaster >logfile 2>&1 </dev/null > [EMAIL PROTECTED]:~$ ps ax | grep postmaster > 9428 pts/4 S+ 0:00 grep postmaster > [EMAIL PROTECTED]:~$ ps -ef | grep postmaster > postgres 9430 9135 0 20:09 pts/4 00:00:00 grep postmaster But when I try to start the postmaster > Tux:~# /etc/init.d/postgresql restart > Stopping PostgreSQL database server: postmasterpg_ctl: could not find > /var/lib/p ostgres/data/postmaster.pid > Is postmaster running? > . > Starting PostgreSQL database server: postmaster(FAILED) > ERROR: The database is in an older format that cannot be read by > version 7.4 of PostgreSQL. > > Run postgresql-dump to dump the old database and to reload > it in the new format. > *** READ /usr/share/doc/postgresql/README.Debian.migration.gz FIRST! *** > > The version 7.4 postmaster cannot be started until > this is done. .. it tells me to run postgresql-dump. I confess to being a postgres newbie, but there has to be a way around. Adam Bogacki, [EMAIL PROTECTED] -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
