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
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
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
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]
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