Skip site navigation (1) Skip section navigation (2)

Re: problem with postgresql-dump while upgrading to 7.4

From: Oleg <evdakov(at)iwk(dot)uka(dot)de>
To: olly(at)lfix(dot)co(dot)uk
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: problem with postgresql-dump while upgrading to 7.4
Date: 2004-08-23 13:23:12
Message-ID: 4129EFC0.9040909@iwk.uka.de (view raw or flat)
Thread:
Lists: pgsql-general
On Fri, 2004-08-20 at 16:46, Oleg wrote:

>>Dear All,
>>I have upgraded Postgresql from 7.3 to 7.4.
>>Starting pg brings error:
>>The database is in an older format that cannot be read by version 7.4 of 
>>PostgreSQL
>>
>>dpkg-upgrade postgresql fails
>>I tried postgresql-dump. While dumping it brings the following error:
>>FATAL: unsupported frontend protocol
>>However the dump file is generated.
>>Does this error means that dump file can not be used or it can be ignored?
>>    
>>
>
>You seem to be using Debian.  The whole process of upgrading between
>major versions is fraught with problems, and 7.3 -> 7.4 is not well
>tested, since 7.3 has never been part of Debian stable.
>
>In /var/lib/postgres (or wherever else you may have directed that the
>database be kept) there should be directories data, dumpall* and
>preserve and (I think) a file called db.out.
>
>.../preserve should contain the 7.3 database; .../data should contain
>the new database, but apparnetly doesn't; db.out ought to be the dump as
>a text file.  Take a look at the dump file, if it is there.  Does it
>look complete?
>  
>
Thank you very much for your ahswer.
I have created db.out using
postgresql-dump -t db.out -dcivlp $PGDATA/../data.save
However postgresql-dump quit with message initdb: failed
I run initdb manualy and it worked ok


In response to

pgsql-general by date

Next:From: Martijn van OosterhoutDate: 2004-08-23 13:29:08
Subject: Re: Greatest/Least functions?
Previous:From: Christopher BrowneDate: 2004-08-23 13:19:33
Subject: Re: postgres replication only some datas

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group