Skip site navigation (1) Skip section navigation (2)

Re: Restarting with pg_ctl, users, and passwords.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Matthew Pettis" <matthew(dot)pettis(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Restarting with pg_ctl, users, and passwords.
Date: 2008-08-20 13:05:48
Message-ID: 27469.1219237548@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-novice
"Matthew Pettis" <matthew(dot)pettis(at)gmail(dot)com> writes:
> I've created a database and can log into it and do stuff with the
> tables using psql.  However, I have a CGI app that wants to call the
> database (all on the same machine), but gets a 'FATAL: Ident
> authentication failed for user "postgres"' error.  now, while logged
> onto my Linux user account 'postgres', I can psql into my database
> without having to provide a password.

If you want to switch to using password authentication, you'll need to
modify your postmaster's pg_hba.conf configuration file, which is
evidently currently set up for ident authentication.  Read the "Client
Authentication" chapter of the manual ...

			regards, tom lane

In response to

pgsql-novice by date

Next:From: Craig RingerDate: 2008-08-20 13:18:58
Subject: Re: Fwd: Restarting with pg_ctl, users, and passwords.
Previous:From: johnfDate: 2008-08-20 06:45:21
Subject: Re: Restarting with pg_ctl, users, and passwords.

pgsql-general by date

Next:From: Tino WildenhainDate: 2008-08-20 13:10:38
Subject: Re: SELECT query experts, anyone?
Previous:From: Alvaro HerreraDate: 2008-08-20 13:03:03
Subject: Re: 8.3.3 win32 crashing

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group