Finally, I am able to create a user. Now when I try to connect to the server through DBWebAdmin (in Parallels Plesk Panel); I get the following : Error: FATAL: Ident authentication failed for user "postgres"
(earlier, with this link I could reach the login screen for PgAdmin ) Do I need to remove the following from pg_hba.conf now? local all postgres ident sameuser On Tue, Mar 2, 2010 at 2:44 PM, Iñigo Martinez Lasala <[email protected]> wrote: > In order to lauch createuser you don't need to modify listen_address since > you can use unix sockets. But anyway it's a requirement if you are goint to > access remotely. > > Add this line in first place to your pg_hba.conf > local all postgres ident sameuser > > > Reload postgresql and launch createuser as postgres user. > > > -----Original Message----- > From: Major Services <[email protected]> > To: [email protected] > Subject: [ADMIN] password authentication failed for user postgres > Date: Tue, 2 Mar 2010 14:13:10 +0530 > > Hi, > > 1. I have added listen_addresses = '*' ; in postgresql.conf > > 2. And have made the following changes to pg_hba.conf > > local DATABASE USER METHOD > local samegroup all password > host DATABASE USER CIDR-ADDRESS METHOD [OPTION] > host all all 0.0.0.0/0 md5 > hostssl all all 0.0.0.0/0 md5 > > 3. Have restarted the server > > 4. I can login to the server as user postgres. > > But while trying to createuser I get the following message : > 'createuser: could not connect to database postgres: FATAL : > password authentication failed for user "postgres" > > This is on Redhat running Plesk also. > > I am new to Linux as well as PostgreSQL. Help would be much appreciated. > > Thanks > Viv > > > -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
