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
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?
pgsql-admin by date
|Next:||From: Greg Mennie||Date: 2004-02-16 13:29:03|
|Subject: Re: hanging for 30sec when checkpointing|
|Previous:||From: tsurkin||Date: 2004-02-16 09:22:20|
|Subject: Re: SSH connection timing out|