Re: Restore
| От | bricklen |
|---|---|
| Тема | Re: Restore |
| Дата | |
| Msg-id | AANLkTinTmTaL0zK6QB1k-sAUFyX9rGmhKZgvK-9O_jcP@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Restore (Adrian Klaver <adrian.klaver@gmail.com>) |
| Ответы |
Re: Restore
|
| Список | pgsql-general |
On Fri, Dec 24, 2010 at 3:38 PM, Adrian Klaver <adrian.klaver@gmail.com> wrote: > On Friday 24 December 2010 3:28:38 pm Bob Pawley wrote: >> 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 >> > > A little bit of testing on my part showed that your form of connecting should > work also i.e.psql –U postgres PDW < PDW_June_10.sql. > A couple of questions. > Can you connect to a database using psql and -U postgres? > Does the postgres user have a password? > If you can connect to a database with psql what does \l show? What I am looking > for is whether PDW has its case preserved or not? How about the pg_hba.conf setting? Is it set to something like md5?
В списке pgsql-general по дате отправления: