[NOVICE] postgresql-dump .. catch 22 ?

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

[NOVICE] postgresql-dump .. catch 22 ?

Adam Bogacki
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,
[hidden email]





---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org
Reply | Threaded
Open this post in threaded view
|

Re: [NOVICE] postgresql-dump .. catch 22 ?

Tom Lane-2
Adam Bogacki <[hidden email]> writes:
> 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

Looks like you need to downgrade your SSL installation as well ...
alternatively, get the 7.2 SRPM and rebuild it locally so it uses
whatever libraries you currently have installed.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster