Re: pg_restore
От | Bob Pawley |
---|---|
Тема | Re: pg_restore |
Дата | |
Msg-id | 002901c81a4b$cf3203d0$6401a8c0@owner обсуждение исходный текст |
Ответ на | pg_restore (Bob Pawley <rjpawley@shaw.ca>) |
Ответы |
Re: pg_restore
|
Список | 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@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
В списке pgsql-general по дате отправления: