Great. You managed to start server. :-)
You are using user postgres and you shoudn't use it.I suggest you to create your own dbadmin...
In your linux box, as root user:
su - postgres
createuser -s dbadmin -P
You will create a new user called dbadmin. It will ask you for a password for this user and some extra options. Response YES to all.
Now you can connect remotely with this dbadmin user.
-----Original Message-----
From: Major Services <
services.major@gmail.com>
To: Iñigo Martinez Lasala <
imartinez@vectorsf.com>
Cc:
pgsql-admin@postgresql.orgSubject: Re: [ADMIN] password authentication failed for user postgres
Date: Wed, 3 Mar 2010 20:07:23 +0530
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
<imartinez@vectorsf.com> 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 <services.major@gmail.com>
> To: pgsql-admin@postgresql.org
> 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]
>
> 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
>
>
>
