From: Wei Weng <wweng@kencast.com>
To: nicolas renie <nicolas.renie@wanadoo.fr>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: problem to connect
Date: Wed, 09 Apr 2003 12:40:36 -0400
Message-ID: <3E944D04.9000301@kencast.com> (raw)
In-Reply-To: <000801c2fe0e$63ee8b10$670c0c50@nicolas>
References: <000801c2fe0e$63ee8b10$670c0c50@nicolas>
The default behavior for postgres uses IDENT. So you need to log on as
user nicolas to be able to use postgres user nicolas. You can look at
/var/lib/pgsql/data/pg_hba.conf for configuration detail.
Wei
nicolas renie wrote:
> Hye
>
> I use linux mandrack 9.0 and postgres 7.2
> I can't connect to postgresql (even in local) if I use a postgres user.
> I don't know what to do.
> I've started the daemon (root# etc/rc.d/init.d/postgresql start)
> logged under postgres I made a user (createuser nico) and a
> database(createdb test)
> But I can't access to this database if I am logged under an other user.
> (su Eddy or anathor linux user)
>
> When I try: psql test -h localhost -U nicolas I have the message :
> IDENT authentification failed for user nicolas.
> I can see the same message when I try to connect whith pgaccess.
>
> If I try to start pgaccess with: "pgaccess test", the main PgAccess
> window
> comes up, (empty) but there is an error message box in front of it.
> The message is:
>
> "Error trying to connect to database "test" on host localhost.
> is the postmaster running (with -i) at
> 'localhost' and accepting connections on TCP/IP port '5432'?"
>
> Therefore I stopped postgresql etc/rc.d/init.d/postgresql stop
> I started it logged under postgres with options ($ postmaster -h
> localhost -i )
>
> I logged under another linux user
> I tried : psql test -h localhost -U nicolas and received the message
>
> No pga_hba.conf entry for host localhost, user nicolas, database test
>
> I tryed to change the pg_dba.conf (trust) file but another message
> appears.
>
> I would like to know what to do especially to use pgaccess
>
>
> Please, help me !
> regards
>
> Nicolas RENIE
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: wweng@kencast.com, nicolas.renie@wanadoo.fr
Subject: Re: problem to connect
In-Reply-To: <3E944D04.9000301@kencast.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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