Thread: Logging in with postgres remotely
Error connecting to the server: FATAL: password authentication failed for user "postgres"
Any pointers? Thanks!
grant all privileges on database clients to user pgAdmin
I am certain I know that users password yet I cannot connect with it from my workstation. Do you think the pgpass file will help in this instance?
From: Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
To: Newbie Poster <newbie.poster@yahoo.com>
Sent: Friday, March 27, 2009 4:14:05 PM
Subject: Re: [ADMIN] Logging in with postgres remotely
Newbie Poster wrote:
> Error connecting to the server: FATAL: password authentication failed
> for user "postgres"
Sounds like a hunt for the pgpass file is recommended:
http://www.postgresql.org/docs/8.3/interactive/libpq-pgpass.html
Peter
----- "Newbie Poster" <newbie.poster@yahoo.com> escreveu:
>
> grant all privileges on database clients to user pgAdmin
>
> I am certain I know that users password yet I cannot connect with it from my workstation. Do you think the pgpass file will help in this instance?
Have you checked your pg_hba.conf file in your PostgreSQL server (if you have access to it)?
Maybe it's not allowed to connect remotely as a regular user but postgres.
Best regards
Flavio
# IPv4 local connections:
host all all 127.0.0.1/32 md5
host all all 10.0.0.0/8 md5
Is anything else required to access the database from a different machine running pgAdmin3?
From: Flavio Henrique Araque Gurgel <flavio@4linux.com.br>
To: Newbie Poster <newbie.poster@yahoo.com>
Cc: pgsql-admin@postgresql.org
Sent: Saturday, March 28, 2009 10:58:37 PM
Subject: Re: Logging in with postgres remotely
----- "Newbie Poster" <newbie.poster@yahoo.com> escreveu:
>
> grant all privileges on database clients to user pgAdmin
>
> I am certain I know that users password yet I cannot connect with it from my workstation. Do you think the pgpass file will help in this instance?
Have you checked your pg_hba.conf file in your PostgreSQL server (if you have access to it)?
Maybe it's not allowed to connect remotely as a regular user but postgres.
Best regards
Flavio
Hi,
Let me see if I understand your situation.
a) you have a postgresql running on a host --let's for
the sake of concreteness, call this machine apple.
b) you want to connect via pgAdmin3 which runs on
a workstation, call this workstation orange.
c) when you supply a password to pgAdmin3, the postgresql
on machine apple rejects you.
If any of this is wrong, let me know.
d) on machine apple, do you have .pgpass file? If so,
is the permission on this file correct?
e) to pgAdmin3, what password are you giving? Apple's
or Orange's?
Regards,
Tena Sakai
tsakai@gallo.ucsf.edu
-----Original Message-----
From: pgsql-admin-owner@postgresql.org on behalf of Newbie Poster
Sent: Mon 3/30/2009 4:05 PM
To: PGSQL Admin
Subject: Re: [ADMIN] Logging in with postgres remotely
I am fairly sure my pg_hba file is correct. Here is what I have under IP4 connections:
# IPv4 local connections:
host all all 127.0.0.1/32 md5
host all all 10.0.0.0/8 md5
Is anything else required to access the database from a different machine running pgAdmin3?
________________________________
From: Flavio Henrique Araque Gurgel <flavio@4linux.com.br>
To: Newbie Poster <newbie.poster@yahoo.com>
Cc: pgsql-admin@postgresql.org
Sent: Saturday, March 28, 2009 10:58:37 PM
Subject: Re: Logging in with postgres remotely
Hi Newbie
----- "Newbie Poster" <newbie.poster@yahoo.com> escreveu:
Thanks for the response. I was able to get postgres user to connect to the remote database by using the 'alter user' command from within psql. However, I am unable to connect to the same server with a different user. I created a generic user called pgAdmin and used the command:
>
> grant all privileges on database clients to user pgAdmin
>
> I am certain I know that users password yet I cannot connect with it from my workstation. Do you think the pgpass file will help in this instance?
Have you checked your pg_hba.conf file in your PostgreSQL server (if you have access to it)?
Maybe it's not allowed to connect remotely as a regular user but postgres.
Best regards
Flavio