Re: Restore

On Fri, Dec 24, 2010 at 3:38 PM, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)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?