Re: Restore

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?

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com