Christoph Becker wrote:
> OS ist Windows XP Prof, PgSQL version is rc5 via windowsinstaller
> When trying to restore a db, psql does not ask for the password but
> responds imediately with an erromessage as in the following example:
> F:\doka\bak>psql -U postgres template1 < pg_dump_all_2005-01-11.txt
> psql: FATAL: password authentication failed for user "postgres"
> However, in the following situation the password can still be entered as
> expected :
> F:\doka\bak>psql -U postgres template1
> Welcome to psql 8.0.0rc5, the PostgreSQL interactive terminal.
try -f instead of < like...
psql -U postgres template1 -f pg_dump_all_2005-01-11.txt
btw, personal 'trick', to avoid having to specify template1, I generally
`createdb postgres` right after installing and doing the initdb. this way the
postgres DBA account has his own personal playpen for testing SQL and stuff.
In response to
pgsql-bugs by date
|Next:||From: Steve Nicolai||Date: 2005-01-13 00:29:45|
|Subject: BUG #1394: LIKE doesn't seem to use an index|
|Previous:||From: Fahad||Date: 2005-01-12 23:08:55|
|Subject: BUG #1393: Adding 'LIMIT 1' to the query halts forever if no data present|
pgsql-hackers-win32 by date
|Next:||From: Tom Lane||Date: 2005-01-13 02:46:29|
|Subject: Re: psql: no chance to enter password in certain situations |
|Previous:||From: Christoph Becker||Date: 2005-01-12 23:02:37|
|Subject: psql: no chance to enter password in certain situations|