467,904 Members | 1,636 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,904 developers. It's quick & easy.

problem with postgresql-dump while upgrading to 7.4 format

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?
Thanks a lot
Oleg
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #1
  • viewed: 1587
Share:
2 Replies
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?

--
Oliver Elphick ol**@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
========================================
"But I would not have you to be ignorant, brethren,
concerning them which are asleep, that ye sorrow not,
even as others which have no hope. For if we believe
that Jesus died and rose again, even so them also
which sleep in Jesus will God bring with him."
I Thessalonians 4:13,14
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 23 '05 #2
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
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Aleksey | last post: by
1 post views Thread by Jeffrey Pogodzinski | last post: by
5 posts views Thread by Rens Admiraal | last post: by
1 post views Thread by Reynir r Hbner | last post: by
15 posts views Thread by Egyd Csaba | last post: by
2 posts views Thread by Tony O'Bryan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.