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

Re: problem with postgresql-dump while upgrading to 7.4

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: Oleg <ut3j(at)rz(dot)uni-karlsruhe(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: problem with postgresql-dump while upgrading to 7.4
Date: 2004-08-20 20:10:15
Message-ID: 1093032615.6979.9.camel@linda (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?

-- 
Oliver Elphick                                          olly(at)lfix(dot)co(dot)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 


In response to

pgsql-general by date

Next:From: Joe LesterDate: 2004-08-20 20:27:07
Subject: Re: Postgres filling up hard drive with swap files
Previous:From: Tom LaneDate: 2004-08-20 20:08:14
Subject: Re: Postgres filling up hard drive with swap files

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