Search Postgresql Archives

Re: Restore

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.klaver@xxxxxxxxx

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux