Re: what is the default username password for PostgreSQL, which was installed with FC5.

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.

:)
Purusothaman A

On 10/27/06, Martijn van Oosterhout <kleptog(at)svana(dot)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(at)svana(dot)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-----
>
>
>