Dear Andrew,
Thanks a LOT!!
It is working:
[D:\]psql -U postgres sosWelcome to psql 8.0.0beta2, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g or terminate with semicolon to execut
try
host all all 127.0.0.1/32 trust
restart the server, then try to connect.
Sudhakar Kurumella wrote:
Is there any alternative for me ?...Any suggestinons would be highly
appreciated.
thanks,
kuru
*/Andrew Dunstan <[EMAIL PROTECTED]>/* wrote:
The "local" line has no effect on Windows - it
Is there any alternative for me ?...Any suggestinons would be highly appreciated.
thanks,
kuruAndrew Dunstan <[EMAIL PROTECTED]> wrote:
The "local" line has no effect on Windows - it only has relevance for Unix domain socket connections, which Windows does not support.The line that affects local
On Tue, 21 Sep 2004, Sudhakar Kurumella wrote:
> Dear Laszlo,
>
> Indeed that is tough, It is highly appreciated if you could explain a bit in detail.
> I tried with option "password no need" in my server, and also tried remove md5 from
> pg_hba.conf :
>
> # TYPE DATABASEUSERCIDR-
The "local" line has no effect on Windows - it only has relevance for
Unix domain socket connections, which Windows does not support.
The line that affects local connections on Windows is "host all all
127.0.0.1/32 ..."
(We really need to make that crystal clear in the pg_hba.conf ...)
cheers
a
That doesn't answer the question of why he isn't even asked for a password.
cheers
andrew
Laszlo Hornyak wrote:
You could enable local connections with no password, then connect with
your postgres user, change pwd, and then re-enable security.
use pg_ctl reload for reloading security settings.
Not
Dear Laszlo,
Indeed that is tough, It is highly appreciated if you could explain a bit in detail. I tried with option "password no need" in my server, and also tried remove md5 from pg_hba.conf :
# TYPE DATABASE USER CIDR-ADDRESS METHOD
local all postgres
You could enable local connections with no password, then connect with
your postgres user, change pwd, and then re-enable security.
use pg_ctl reload for reloading security settings.
Not nice, but quick :)
On Tue, 21 Sep 2004, Sudhakar Kurumella wrote:
> I am trying to connect to database call
I am trying to connect to database called "sos", i tried as you said:
[D:\]psql -U postgres template1psql: FATAL: Password authentication failed for user "postgres"
[D:\]psql -U postgres -W template1psql: FATAL: Password authentication failed for user "postgres"
[D:\]
I got the above error ag
Which database are you trying to connect to?
try:
psql -U postgres template1
or
psql -U postgres -W template1
and see what happens
cheers
andrew
Sudhakar Kurumella wrote:
I tried that, the error is the same but with user "postgres"
[D:\Postgresql\8.0-beta2-dev3\bin]psql -U postgres
psql: FATAL:
I tried that, the error is the same but with user "postgres"
[D:\Postgresql\8.0-beta2-dev3\bin]psql -U postgrespsql: FATAL: Password authentication failed for user "postgres"
It is not taking my password if i give option with "-W" as well.
[D:\Postgresql\8.0-beta2-dev3\bin]psql -U postgres -
Use psql -U postgres
Dave
On Tue, 2004-09-21 at 07:38, Sudhakar Kurumella wrote:
> Hi,
>
> I am using postgresql windows based "8.0-beta2-dev3". I have provided
> default user and password while installing. When i am trying to
> connecto to psql through dos command prompt, i am getting following
12 matches
Mail list logo
