Re: problem with postgresql-dump while upgrading to 7.4
От | Oleg |
---|---|
Тема | Re: problem with postgresql-dump while upgrading to 7.4 |
Дата | |
Msg-id | 4129EFC0.9040909@iwk.uka.de обсуждение исходный текст |
Ответ на | problem with postgresql-dump while upgrading to 7.4 format (Oleg <ut3j@rz.uni-karlsruhe.de>) |
Список | 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
В списке pgsql-general по дате отправления: