Purusothaman A wrote:
Thanks for all of your valuable replies.
Please tell me, what should i do to login with syntax
psql -Uusername -h192.168.2.2 -dusername(database name).
Because I should be able to login from any login and also from any system.
In your data directory you will find a file called pg_hba.conf - the
entries in there determine who can log in from what machine with what
sort of authentication.
There are plenty of notes explaining it in the file itself or you can
find explanations in the docs -
http://www.postgresql.org/docs/8.1/static/client-authentication.html
you will probably want to add something like -
# TYPE DATABASE USER CIDR-ADDRESS METHOD
host all all 192.168.2.0/24 md5
and maybe -
host all all 127.0.0.1/32 md5
:)
Purusothaman A
On 10/27/06, Martijn van Oosterhout <kleptog@xxxxxxxxx> wrote:
On Fri, Oct 27, 2006 at 11:43:26AM +0200, A. Kretschmer wrote:
> am Fri, dem 27.10.2006, um 15:01:09 +0530 mailte Purusothaman A
folgendes:
> > Thanks for your immediate reply.
> >
> > I created new role "db1" and database "db1".
> >
> > but I cannot login using
> > psql -Udb1 -ddb1 -hlocalhost
> > results
> > Fatal Error : Ident authentication failed for user "db1".
>
> You arn't the user called 'db1'?
>
> Either 'su - db1' and then psql, or change the settings in your
> pg_hba.conf for this database and localhost to 'trust'.
Right. As pointed out, the default authentication method "ident" means
that the database user and the system user are linked, so system user
"db1" can login as database user "db1" without a password.
"trust" means anyone can login an anyone, which may or may not be what
you want.
You can define ident maps, where you state that system user "x" can
login without password as database user "y". Check the documentation.
Have a nice day,
--
Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to
litigate.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
iD8DBQFFQdXOIB7bNG8LQkwRAripAJ9OVbCQxoJZv7MbC0J6kpx36cyq8QCfdXzR
CygEQSlRzRTwk2KoZ9z5ZkE=
=4ZZc
-----END PGP SIGNATURE-----
--
Shane Ambler
pgSQL@xxxxxxxxxxxxxxxx
Get Sheeky @ http://Sheeky.Biz
