Re: [ADMIN] password authentication failed for user postgres

2010-03-04 Thread Major Services
min" or "up2date install > phppgadmin" > Or webmin if you want to admin all server without having to use command > line. http://www.webmin.com/ > > > > > -Original Message- > From: Major Services > To: Iñigo Martinez Lasala > Cc: pgsql-admin@

Re: [ADMIN] password authentication failed for user postgres

2010-03-04 Thread Iñigo Martinez Lasala
admin all server without having to use command line. http://www.webmin.com/ -Original Message- From: Major Services To: Iñigo Martinez Lasala Cc: [email protected] Subject: Re: [ADMIN] password authentication failed for user postgres Date: Wed, 3 Mar 2010 23:40:39 +0530 When

Re: [ADMIN] password authentication failed for user postgres

2010-03-03 Thread Major Services
sword" since you will > have to enter password for any local operation in your server, but anyway, > it's your decision. > > -Original Message- > From: Major Services > To: Iñigo Martinez Lasala > Cc: [email protected] > Subject: Re: [ADMIN] pass

Re: [ADMIN] password authentication failed for user postgres

2010-03-03 Thread Iñigo Martinez Lasala
[email protected] Subject: Re: [ADMIN] password authentication failed for user postgres Date: Wed, 3 Mar 2010 22:41:47 +0530 Thanks. I already have created a user. And can connect to the server through the PgAdmin on my local system. My query now is : Now when I try to connect to the

Re: [ADMIN] password authentication failed for user postgres

2010-03-03 Thread Major Services
reate 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 > To: Iñigo Martinez Lasala

Re: [ADMIN] password authentication failed for user postgres

2010-03-03 Thread Iñigo Martinez Lasala
this user and some extra options. Response YES to all. Now you can connect remotely with this dbadmin user. -Original Message- From: Major Services To: Iñigo Martinez Lasala Cc: [email protected] Subject: Re: [ADMIN] password authentication failed for user postgres Date: Wed,

Re: [ADMIN] password authentication failed for user postgres

2010-03-03 Thread Major Services
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 remo

Re: [ADMIN] password authentication failed for user postgres

2010-03-02 Thread Major Services
st lines of this file ? > > > > > > > > > > > > -Original Message- > > > *From*: Major Services major%20services%20%[email protected] > %3e> > > > > > > > *To*: I?igo Martinez Lasala 3d%3fiso-8859-1%3fq%3fi%3df1igo%3f%

Re: [ADMIN] password authentication failed for user postgres

2010-03-02 Thread Kenneth Marshall
2, 2010 at 4:32 PM, I?igo Martinez Lasala < > > [email protected]> wrote: > > > > Try with these parameters in pg_hba.conf. Perhaps your postgres-redhat > > compilation does not have ident enabled... > > > > local all postgres trust > > > >

Re: [ADMIN] password authentication failed for user postgres

2010-03-02 Thread Major Services
t; [email protected]> wrote: > Ah... ok. > In /var/lib/pgsql you will find a file called pgstartup.log > Could you post here last lines of this file ? > > > > -Original Message- > *From*: Major Services > > > > *To*: Iñigo Martinez Lasala &

Re: [ADMIN] password authentication failed for user postgres

2010-03-02 Thread Iñigo Martinez Lasala
Ah... ok. In /var/lib/pgsql you will find a file called pgstartup.log Could you post here last lines of this file ? -Original Message- From: Major Services To: Iñigo Martinez Lasala Cc: [email protected] Subject: Re: [ADMIN] password authentication failed for user postgres

Re: [ADMIN] password authentication failed for user postgres

2010-03-02 Thread Major Services
oes not have ident enabled... > > local all postgres trust > > > > -Original Message- > *From*: Major Services > > > > *To*: Iñigo Martinez Lasala > > > > *Subject*: Re: [ADMIN] password authentication failed for user postgres > *Date*: T

Re: [ADMIN] password authentication failed for user postgres

2010-03-02 Thread Iñigo Martinez Lasala
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 pos