pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedLogging in with postgres remotely
5+ messages / 3 participants
[nested] [flat]
* Logging in with postgres remotely
@ 2009-03-27 22:44 Newbie Poster <newbie.poster@yahoo.com>
2009-03-27 23:33 ` Re: Logging in with postgres remotely Newbie Poster <newbie.poster@yahoo.com>
0 siblings, 1 reply; 5+ messages in thread
From: Newbie Poster @ 2009-03-27 22:44 UTC (permalink / raw)
To: pgsql-admin
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!
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Logging in with postgres remotely
2009-03-27 22:44 Logging in with postgres remotely Newbie Poster <newbie.poster@yahoo.com>
@ 2009-03-27 23:33 ` Newbie Poster <newbie.poster@yahoo.com>
2009-03-29 05:58 ` Re: Logging in with postgres remotely Flavio Henrique Araque Gurgel <flavio@4linux.com.br>
0 siblings, 1 reply; 5+ messages in thread
From: Newbie Poster @ 2009-03-27 23:33 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Logging in with postgres remotely
2009-03-27 22:44 Logging in with postgres remotely Newbie Poster <newbie.poster@yahoo.com>
2009-03-27 23:33 ` Re: Logging in with postgres remotely Newbie Poster <newbie.poster@yahoo.com>
@ 2009-03-29 05:58 ` Flavio Henrique Araque Gurgel <flavio@4linux.com.br>
2009-03-30 23:05 ` Re: Logging in with postgres remotely Newbie Poster <newbie.poster@yahoo.com>
0 siblings, 1 reply; 5+ messages in thread
From: Flavio Henrique Araque Gurgel @ 2009-03-29 05:58 UTC (permalink / raw)
To: Newbie Poster <newbie.poster@yahoo.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Logging in with postgres remotely
2009-03-27 22:44 Logging in with postgres remotely Newbie Poster <newbie.poster@yahoo.com>
2009-03-27 23:33 ` Re: Logging in with postgres remotely Newbie Poster <newbie.poster@yahoo.com>
2009-03-29 05:58 ` Re: Logging in with postgres remotely Flavio Henrique Araque Gurgel <flavio@4linux.com.br>
@ 2009-03-30 23:05 ` Newbie Poster <newbie.poster@yahoo.com>
2009-03-31 00:43 ` Re: Logging in with postgres remotely Tena Sakai <tsakai@gallo.ucsf.edu>
0 siblings, 1 reply; 5+ messages in thread
From: Newbie Poster @ 2009-03-30 23:05 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Logging in with postgres remotely
2009-03-27 22:44 Logging in with postgres remotely Newbie Poster <newbie.poster@yahoo.com>
2009-03-27 23:33 ` Re: Logging in with postgres remotely Newbie Poster <newbie.poster@yahoo.com>
2009-03-29 05:58 ` Re: Logging in with postgres remotely Flavio Henrique Araque Gurgel <flavio@4linux.com.br>
2009-03-30 23:05 ` Re: Logging in with postgres remotely Newbie Poster <newbie.poster@yahoo.com>
@ 2009-03-31 00:43 ` Tena Sakai <tsakai@gallo.ucsf.edu>
0 siblings, 0 replies; 5+ messages in thread
From: Tena Sakai @ 2009-03-31 00:43 UTC (permalink / raw)
To: Newbie Poster <newbie.poster@yahoo.com>; pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2009-03-31 00:43 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-03-27 22:44 Logging in with postgres remotely Newbie Poster <newbie.poster@yahoo.com>
2009-03-27 23:33 ` Newbie Poster <newbie.poster@yahoo.com>
2009-03-29 05:58 ` Flavio Henrique Araque Gurgel <flavio@4linux.com.br>
2009-03-30 23:05 ` Newbie Poster <newbie.poster@yahoo.com>
2009-03-31 00:43 ` Tena Sakai <tsakai@gallo.ucsf.edu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox