Re: Restore

On Friday 24 December 2010 4:03:52 pm Bob Pawley wrote:
> I have tried this a number of times -
> psql –U postgres PDW < PDW_June_10.sql. (with and without spaces between U
> & postgres and/or < and PDW_June)
>
> Sometimes I am asked for a postgres password, once I was asked for the PDW
> password (this makes sense and which I did enter).
>
> When I entered the password it either said password failed or it simply
> went back to the root command.
>
> No database information was sent.
>
> pg_hba.conf sets method as md5
>
> I don't know what is meant by your reference to \1.
>
> Bob
>

Lets go back to the beginning.
Basic info:
Pg version
OS
How do you normally connect to the database?
Have you set up passwords for Postgres users?
Remember Postgres users are not the same as system users. So when it asking for
a password it is for the Postgres users password not the system users password
of the same name.

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