Search Postgresql Archives

Re: Restore

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

 



On Friday 24 December 2010 12:36:32 pm Bob Pawley wrote:
> Hi
>
> I am attempting to restore a database using -
>
> psql PDW < PDW_June_10.sql
>
> psql âU postgres PDW < PDW_June_10.sql

psql âU postgres -d PDW  -f PDW_June_10.sql

>
> The response asks me for a password.
>
> I use the same password with which I connect to the server but it is not
> accepted.
>
> Without the âU postgres identifier it asks me for the password of my
> computer - which doesnât exist.

Without a specified -U it psql will use your system user name.
See here for all the gory details:
http://www.postgresql.org/docs/9.0/interactive/app-psql.html

>
> How can I get around this??
>
> Bob



-- 
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