Re: [GENERAL] Data migration from version 7.2.1 to 8.1.5

2007-02-08 Thread Arindam
On 2/8/07, Tom Lane <[EMAIL PROTECTED]> wrote: Arindam <[EMAIL PROTECTED]> writes: > On 2/8/07, Tom Lane <[EMAIL PROTECTED]> wrote: >> Now you *should* be using the newer pg_dump to dump from the old >> database --- that's considered good practice. But you need an >> up-to-date pg_restore to rea

Re: [GENERAL] Data migration from version 7.2.1 to 8.1.5

2007-02-08 Thread Tom Lane
Arindam <[EMAIL PROTECTED]> writes: > On 2/8/07, Tom Lane <[EMAIL PROTECTED]> wrote: >> Now you *should* be using the newer pg_dump to dump from the old >> database --- that's considered good practice. But you need an >> up-to-date pg_restore to read its output. > Well this time I got it dumped u

Re: [GENERAL] Data migration from version 7.2.1 to 8.1.5

2007-02-08 Thread Arindam
On 2/8/07, Tom Lane <[EMAIL PROTECTED]> wrote: Arindam <[EMAIL PROTECTED]> writes: > I tried dumping data in tar format using the pg_dump utility (with > version 7.2.1) and restoring it using pg_restore utility (with version > 8.1.5). But on running this command: > pg_restore -d mydb -C -u > I

Re: [GENERAL] Data migration from version 7.2.1 to 8.1.5

2007-02-08 Thread Tom Lane
Arindam <[EMAIL PROTECTED]> writes: > I tried dumping data in tar format using the pg_dump utility (with > version 7.2.1) and restoring it using pg_restore utility (with version > 8.1.5). But on running this command: > pg_restore -d mydb -C -u > I get the following error: > pg_restore: [archiver]

[GENERAL] Data migration from version 7.2.1 to 8.1.5

2007-02-08 Thread Arindam
Hi, I am trying to write a script which will migrate all the data from a particular database on version 7.2.1 and restore the same data along with the full schema on an 8.1.5 database. The database itself will be created and does not need to be created. I tried dumping data in tar format using t