From: | Bob Pawley <rjpawley(at)shaw(dot)ca> |
---|---|
To: | Adrian Klaver <aklaver(at)comcast(dot)net>, pgsql-general(at)postgresql(dot)org |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Subject: | Re: pg_restore |
Date: | 2007-10-29 16:50:25 |
Message-ID: | 002901c81a4b$cf3203d0$6401a8c0@owner |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)comcast(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Cc: "Bob Pawley" <rjpawley(at)shaw(dot)ca>; "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)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(at)comcast(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | David Fetter | 2007-10-29 16:51:29 | Re: Problems with PostgreSQL DBI-Link / DBD-ODBC |
Previous Message | Jeff Davis | 2007-10-29 16:50:15 | Re: [HACKERS] WAL archiving idle database |