Обсуждение: Logging in with postgres remotely

Поиск
Список
Период
Сортировка

Logging in with postgres remotely

От
Newbie Poster
Дата:
I am trying to connect to a postgres database ona remote server using pgAdmin III, and the user postgres.  According to some instructions I found in the mailing list archives, I reset the password of the postgres user, which is required before one can use that username to connect to a remote database. I am still getting the same error, however, which is:

 Error connecting to the server: FATAL:  password authentication failed for user "postgres"

Any pointers?  Thanks!

Re: Logging in with postgres remotely

От
Newbie Poster
Дата:
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?

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

Re: Logging in with postgres remotely

От
Flavio Henrique Araque Gurgel
Дата:
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

Re: Logging in with postgres remotely

От
Newbie Poster
Дата:
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

p {margin:0;}
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

Re: Logging in with postgres remotely

От
"Tena Sakai"
Дата:

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