postgresql-dump .. catch 22 ?
От | Adam Bogacki |
---|---|
Тема | postgresql-dump .. catch 22 ? |
Дата | |
Msg-id | 428F082F.6090005@paradise.net.nz обсуждение исходный текст |
Ответы |
Re: postgresql-dump .. catch 22 ?
|
Список | pgsql-novice |
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 apt-install 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 >> postgres@Tux:~$ 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 >> postgres@Tux:~$ nohup postmaster >logfile 2>&1 </dev/null & >> [1] 9291 >> postgres@Tux:~$ 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 >> postgres@Tux:~$ ps ax | grep postmaster >> 9428 pts/4 S+ 0:00 grep postmaster >> postgres@Tux:~$ 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, afb@paradise.net.nz
В списке pgsql-novice по дате отправления: