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

Hi all,

Now I changed postgresql database administrator login password and then
modified pg_hba.conf file with authentication mathod to md5 for all (roles +
database).

Now can use the folowing syntax from any login.

psql -Uusername -h192.168.2.2 -dusername(database name).

Hence I solved my problem.

Thanks for u all and your replies.

:)
Purusothaman A

On 10/27/06, Purusothaman A <purusothaman(dot)a(at)gmail(dot)com> 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.
>
> :)
> 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-----
> >
> >
> >
>