pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCan't connect from any system account other than postgres
3+ messages / 2 participants
[nested] [flat]
* Can't connect from any system account other than postgres
@ 2008-06-23 22:58 James Colannino <james@eracks.com>
2008-06-23 23:23 ` Re: Can't connect from any system account other than postgres Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: James Colannino @ 2008-06-23 22:58 UTC (permalink / raw)
To: pgsql-admin
Hey everyone. I hope you'll forgive this most likely stupid question,
but I'm having trouble connecting to a postgresql database when on any
system account other than postgres.
I understand that the way my PostgreSQL installation is setup, the
account postgres functions as a trusted account that will allow me to
run psql without a password. However, after I've setup an initial
database, user and password (the database is set to belong to this
user), when I try to run the command psql -d database -U username -W,
after entering the password, I'm told that authentication failed.
I also tried logging into the system as postgres, and then setting the
password for the database user postgres. However, I have the same
problem when I try to connect as this user from any other system account.
I'm guessing I missed something in my server configuration, but I can't
for the life of me figure it out. Thanks in advance for any help anyone
can provide!
James
--
eRacks Open Source Systems
http://www.eracks.com/
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Can't connect from any system account other than postgres
2008-06-23 22:58 Can't connect from any system account other than postgres James Colannino <james@eracks.com>
@ 2008-06-23 23:23 ` Scott Marlowe <scott.marlowe@gmail.com>
2008-06-23 23:35 ` Re: Can't connect from any system account other than postgres James Colannino <james@eracks.com>
0 siblings, 1 reply; 3+ messages in thread
From: Scott Marlowe @ 2008-06-23 23:23 UTC (permalink / raw)
To: James Colannino <james@eracks.com>; +Cc: pgsql-admin
On Mon, Jun 23, 2008 at 4:58 PM, James Colannino <james@eracks.com> wrote:
> Hey everyone. I hope you'll forgive this most likely stupid question, but
> I'm having trouble connecting to a postgresql database when on any system
> account other than postgres.
>
> I understand that the way my PostgreSQL installation is setup, the account
> postgres functions as a trusted account that will allow me to run psql
> without a password. However, after I've setup an initial database, user and
> password (the database is set to belong to this user), when I try to run the
> command psql -d database -U username -W, after entering the password, I'm
> told that authentication failed.
Let me guess, it says something about ident authentication failed, right?
Take a look here:
http://www.postgresql.org/docs/8.3/interactive/client-authentication.html
This section has been moved for future versions of the docs, but it's
still in a kind of "too later to save you" position for now.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Can't connect from any system account other than postgres
2008-06-23 22:58 Can't connect from any system account other than postgres James Colannino <james@eracks.com>
2008-06-23 23:23 ` Re: Can't connect from any system account other than postgres Scott Marlowe <scott.marlowe@gmail.com>
@ 2008-06-23 23:35 ` James Colannino <james@eracks.com>
0 siblings, 0 replies; 3+ messages in thread
From: James Colannino @ 2008-06-23 23:35 UTC (permalink / raw)
To: pgsql-admin
Scott Marlowe wrote:
> Let me guess, it says something about ident authentication failed, right?
Yep, sure does.
> http://www.postgresql.org/docs/8.3/interactive/client-authentication.html
>
> This section has been moved for future versions of the docs, but it's
> still in a kind of "too later to save you" position for now.
That was very helpful. Thanks!
James
--
eRacks Open Source Systems
http://www.eracks.com/
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2008-06-23 23:35 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-06-23 22:58 Can't connect from any system account other than postgres James Colannino <james@eracks.com>
2008-06-23 23:23 ` Scott Marlowe <scott.marlowe@gmail.com>
2008-06-23 23:35 ` James Colannino <james@eracks.com>
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