Daniel Bush wrote:
>Hi Adam,
>I remember having trouble going from postgres 7.2 to postgres 7.3 when i
>upgraded distros.
>I was using redhat at the time.
>I think, I uninstalled the new version (7.3) - which was failing to
>start because of the older format databases I was using - and
>reinstalled the old version (7.2).
>Running as 7.2, I then dumped the databases I had been using:
> pg_dump -U user_name database_name >dump_file
>I must have taken a backup of the raw files too as insurance and then
>deleted them and installed 7.3 as a completely clean install.
>Then after the new postmaster was up and running, I reinstalled the
>databases with something like
> psql -U user_name database_name <dump_file
>(You have to create the database first using 'createdb' at the shell or
>CREATE DATABASE as the sql prompt.)
>
>I don't know if that's the way it's meant to be done but I got there in
>the end.
>
>Cheers,
>Daniel.
>
>On Sat, 2005-05-21 at 19:29, Adam Bogacki wrote:
>
>
>>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]
>>
>>
>>
>
>
>
>
>
Thanks Daniel, I was thinking of deleting them then apt removing and
reinstalling everything but wondered of there was a better ('correct')
way of doing it. If it worked for you .. we'll see.
Adam
[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
