Re: pg_restore

Following the examples in the docs I've come to this.

I am attempting to restore the existing sql dump using
psql -d PDW -f aurel.sql

I am then asked for a password.

I try every password that the computer knows with no success.

Funny thing the password cursor doesn't move when inputting the password.

I keep getting authentication failure.

When I attempt to do a new pg_dump with -Fc I also get a request for
password with identical results.

Bob



----- Original Message -----
From: "Adrian Klaver" <aklaver@comcast.net>
To: <pgsql-general@postgresql.org>
Cc: "Bob Pawley" <rjpawley@shaw.ca>; "Tom Lane" <tgl@sss.pgh.pa.us>
Sent: Sunday, October 28, 2007 3:58 PM
Subject: Re: [GENERAL] pg_restore


> On Sunday 28 October 2007 3:40 pm, Bob Pawley wrote:
>> This is the dump command
>>
>> pg_dump -h localhost -d  Aurel -U postgres
>>
>> Could you suggest a dump command that will match the restore command -
>>
>> pg_restore  -h localhost -d PDW -U postgres  aurel.sql
>>
>>
>> Thanks
>>
>> Bob
>>
> It depends on what you want to do. But to use pg_restore you will need to
> use
> one of either -Fc or Ft after the pg_dump command. My concern is that you
> are
> connecting to a different database name in the dump and restore commands.
> This may be what you want, but then again it may not.I would suggest
> reading
> the information at the URL below before proceeding further.
> http://www.postgresql.org/docs/8.2/interactive/app-pgdump.html
>
> --
> Adrian Klaver
> aklaver@comcast.net