About the restore from V1.09 to V6.3.2
От
inlin
Тема
About the restore from V1.09 to V6.3.2
Дата
Msg-id
Pine.GSO.3.96.990630020328.19207A-100000@cissol4
Список
Hi everybody:
I got a question: I use "psql -e databasename < db.out" method
to migrate postgres from V1.09 to V6.X ,but it couldn't work. Now the
question is "Does "restore" really work?" or "Is it possible to restore"
between these two verson?...
For the answer of former,I'll give it more tries(and please show
me,if possible..); for the latter, I think I have to make my mind to
give up the old database ( and maybe modify the old client codes)...:(
The major error message is (displayed on the monitor):
"query buffer max length of 20000 exceeded query line ignored "
And I've tried to direct it into a temp file:
"psql -e databasename < db.out >temp"
After editing temp,I found that the contents are just repeat segments
of:(not totally the same with those displayed on the monitor)
==
\? -- help
\a -- toggle field-alignment (currently on)
\C [] -- set html3 caption (currently '')
\connect -- connect to new database (currently 'catdb')
\copy table {from | to}
\d [В списке pgsql-general по дате отправления