On Fri, 2004-08-20 at 16:46, Oleg wrote:
>>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
>>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
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 Oosterhout||Date: 2004-08-23 13:29:08|
|Subject: Re: Greatest/Least functions?|
|Previous:||From: Christopher Browne||Date: 2004-08-23 13:19:33|
|Subject: Re: postgres replication only some datas|