pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Postgresql Login problem
4+ messages / 4 participants
[nested] [flat]

* Postgresql Login problem
@ 2007-08-03 06:54  Dr. Lal Bopearachchi <lal@apiit.lk>
  0 siblings, 2 replies; 4+ messages in thread

From: Dr. Lal Bopearachchi @ 2007-08-03 06:54 UTC (permalink / raw)
  To: pgsql-admin

I am trying to use PostgreSQL ver. 8.1.4 that comes with Red Hat
Enterprise Linux 5.

I cannot log into the postgres server as postgres, it gives the error
message "password authentication failed for user "postgres".

 

Is there a default password?

 

How can I start working with postgres?

 

Regards.

 

Lal Bopearatchy

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Postgresql Login problem
@ 2007-08-08 13:57  Julio Leyva <jcleyva@hotmail.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Julio Leyva @ 2007-08-08 13:57 UTC (permalink / raw)
  To: Dr. Lal Bopearachchi <lal@apiit.lk>; pgsql-admin

Check your pg_hba.conf file if the method is password, then create a pasword for postgres userpsql yourdbalter user postgres  set password = 'pasword'if you don't want to do that, change pg_hba.conf file and modify the method to trustthen /etc/init.t/./postgresql reloadHope this will helpSubject: [ADMIN] Postgresql Login problemDate: Fri, 3 Aug 2007 12:54:10 +0600From: lal@apiit.lkTo: pgsql-admin@postgresql.org














I am trying to use PostgreSQL ver. 8.1.4 that comes with Red
Hat Enterprise Linux 5.

I cannot log into the postgres server as postgres, it gives
the error message “password authentication failed for user “postgres”.

 

Is there a default password?

 

How can I start working with postgres?

 

Regards.

 

Lal Bopearatchy






=

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Postgresql Login problem
@ 2007-08-08 14:06  Ashish Karalkar <ashish.karalkar@info-spectrum.com>
  parent: Dr. Lal Bopearachchi <lal@apiit.lk>
  1 sibling, 0 replies; 4+ messages in thread

From: Ashish Karalkar @ 2007-08-08 14:06 UTC (permalink / raw)
  To: Dr. Lal Bopearachchi <lal@apiit.lk>; +Cc: pgsql-admin

Have you supplied password to initdb command?
if not there are two ways

1) In pg_hba.conf file set athuntication method =trust instead of  password. (if you want to keep trust method for all time)

2) Do the above step then login into postgres database and the issue command 

alter role postgres password 'your password goes here'

then again open pg_hba.con and set authuntication method to password.


rember these changes requires server restart or relaod.
with regards
ashish...



----- Original Message ----- 
  From: Dr. Lal Bopearachchi 
  To: pgsql-admin@postgresql.org 
  Sent: Friday, August 03, 2007 12:24 PM
  Subject: [ADMIN] Postgresql Login problem


  I am trying to use PostgreSQL ver. 8.1.4 that comes with Red Hat Enterprise Linux 5.

  I cannot log into the postgres server as postgres, it gives the error message "password authentication failed for user "postgres".

   

  Is there a default password?

   

  How can I start working with postgres?

   

  Regards.

   

  Lal Bopearatchy

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Postgresql Login problem
@ 2007-08-08 14:55  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Dr. Lal Bopearachchi <lal@apiit.lk>
  1 sibling, 0 replies; 4+ messages in thread

From: Tom Lane @ 2007-08-08 14:55 UTC (permalink / raw)
  To: Dr. Lal Bopearachchi <lal@apiit.lk>; +Cc: pgsql-admin

"Dr. Lal Bopearachchi" <lal@apiit.lk> writes:
> I am trying to use PostgreSQL ver. 8.1.4 that comes with Red Hat
> Enterprise Linux 5.
> I cannot log into the postgres server as postgres, it gives the error
> message "password authentication failed for user "postgres".
> Is there a default password?

No.  The default Red Hat configuration doesn't use passwords --- it is
set up for "ident" authorization, instead.  Have you changed any
configuration files?  What are the exact commands you are trying?

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2007-08-08 14:55 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-08-03 06:54 Postgresql Login problem Dr. Lal Bopearachchi <lal@apiit.lk>
2007-08-08 14:06 ` Ashish Karalkar <ashish.karalkar@info-spectrum.com>
2007-08-08 14:55 ` Tom Lane <tgl@sss.pgh.pa.us>
2007-08-08 13:57 Re: Postgresql Login problem Julio Leyva <jcleyva@hotmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox