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@svana.org> 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@svana.org> 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@007Marketing.com
Get Sheeky @ http://Sheeky.Biz