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]