postgresql-dump .. catch 22 ?

From: Adam Bogacki <afb(at)paradise(dot)net(dot)nz>
To: pgsql-novice(at)postgresql(dot)org
Subject: postgresql-dump .. catch 22 ?
Date: 2005-05-21 10:06:39
Message-ID: 428F082F.6090005@paradise.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)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(at)Tux:~$ nohup postmaster >logfile 2>&1 </dev/null &
>> [1] 9291
>> postgres(at)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(at)Tux:~$ ps ax | grep postmaster
>> 9428 pts/4 S+ 0:00 grep postmaster
>> postgres(at)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(at)paradise(dot)net(dot)nz

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message D.C. 2005-05-21 12:08:32 REFERENCES to foreign tables
Previous Message Timo Roessner 2005-05-20 20:34:21 datatype conversion on postgresql 7.4.1