Re: Restore
От | Bob Pawley |
---|---|
Тема | Re: Restore |
Дата | |
Msg-id | F25DAC287DB745679D48FA61838D9B6D@BobPC обсуждение исходный текст |
Ответ на | Re: Restore (Adrian Klaver <adrian.klaver@gmail.com>) |
Ответы |
Re: Restore
|
Список | pgsql-general |
Thanks Adrian but psql –U postgres -d PDW -f PDW_June_10.sql asks - "Password for user postgres:" When I type the password the cursor doesn't respond and on enter I get password failed. Bob -----Original Message----- From: Adrian Klaver Sent: Friday, December 24, 2010 2:59 PM To: pgsql-general@postgresql.org Cc: Bob Pawley Subject: Re: [GENERAL] Restore On Friday 24 December 2010 12:36:32 pm Bob Pawley wrote: > Hi > > I am attempting to restore a database using - > > psql PDW < PDW_June_10.sql > > psql –U postgres PDW < PDW_June_10.sql psql –U postgres -d PDW -f PDW_June_10.sql > > The response asks me for a password. > > I use the same password with which I connect to the server but it is not > accepted. > > Without the –U postgres identifier it asks me for the password of my > computer - which doesn’t exist. Without a specified -U it psql will use your system user name. See here for all the gory details: http://www.postgresql.org/docs/9.0/interactive/app-psql.html > > How can I get around this?? > > Bob -- Adrian Klaver adrian.klaver@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
В списке pgsql-general по дате отправления: