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

Re: Upgrading 7.2.4 to 7.4.1

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: Jarmo Järvenpää <Jarmo(dot)Jarvenpaa(at)softers(dot)net>,pgsql-admin(at)postgresql(dot)org
Subject: Re: Upgrading 7.2.4 to 7.4.1
Date: 2004-02-22 02:09:39
Message-ID: 200402212109.39694.xzilla@users.sourceforge.net (view raw or flat)
Thread:
Lists: pgsql-admin
You might get better results using 7.4's pg_dump against the 7.2 database... 
worth a try anyway.

Robert Treat

On Monday 16 February 2004 07:59, Jarmo Järvenpää wrote:
> Dear all,
>
> I've got an old 7.2.4 DB which I hoped to upgrade to 7.4.1.
> The old syntax used for creating tables had lines like
> ..
> id integer DEFAULT '',
>
> which translates to this error:
>
> pg_restore: [archiver (db)] could not execute query: ERROR:  invalid
> input syntax for integer: ""
>
> I found out that integer with '' as default is not acceptable after 7.3.
>   Also, some complaints were given with the data, particulary numerous
> "\N" lines when restoring (this can be worked out by using -d switch
> when dumping).
>
> Also, schemas are not going to be created (some 7.3 documents gave this
> up).
>
> Thus, must I update every DB creation script by hand and try to restore
> only the data?
>
>
> Regards,
> Jarmo
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend

-- 
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

In response to

pgsql-admin by date

Next:From: Robert TreatDate: 2004-02-22 02:22:28
Subject: Re: Panic involving a LC_COLLATE issue
Previous:From: scottDate: 2004-02-21 00:10:59
Subject: Re: WAL logs and segment files

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