Import data from postgres 7.0 to 7.3.4

From: "luke" <ktaki(at)buziaczek(dot)pl>
To: pgsql-admin(at)postgresql(dot)org
Subject: Import data from postgres 7.0 to 7.3.4
Date: 2003-08-14 14:12:18
Message-ID: bhg5c3$7qu$2@sklad.atcom.net.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

I used postgresql 7.0. I install new instalation 7.3.4.
Could you tell me how I can import my base from 7.0 to 7.3.4?

I used in base 7.0 pg_dumpall -o > base.sql and try import to 7.3.4 (psql -U
postgres -f base.sql template1).
Of course I read a lot of errors;

In Relase Notes from Administrator's Guide book is:

.1.2. Migration to version 7.3

A dump/restore using pg_dump is required for those wishing to migrate data
from any previous release. If your application examines the system catalogs,
additional changes will be required due to the introduction of schemas in
7.3; for more information, see:
http://www.ca.postgresql.org/docs/momjian/upgrade_tips_7.3.
This link doesn't work.

Thanks

Luke

Browse pgsql-admin by date

  From Date Subject
Next Message Priya G 2003-08-14 17:01:45 forcce a table in memory
Previous Message Tom Lane 2003-08-14 11:38:55 Re: Transactions, tuples, and VACUUM