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

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".

Waiting for your valuable suggestion.
Thanks in advance.

:)
Purusothaman A

On 10/27/06, Martijn van Oosterhout <kleptog(at)svana(dot)org> wrote:
>
> On Fri, Oct 27, 2006 at 02:45:57PM +0530, Purusothaman A wrote:
> > Hi all,
> >
> > I am using a Fedora Core 5 system.
> > I want to know what is the default username password for PostgreSQL,
> which
> > was installed with FC5.
>
> I'm not sure if there is one. However, usually you su to the postgres
> user which will let you in without a password. There you use
> "createuser" to make a user for yourself.
>
> Note, it really depends how the distributor has set the system up.
> Allowing the "postgres" user password-less access is common because it
> allows cronjobs as user "postgres" (backups for example) to run without
> any extra configuration.
>
> 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)
>
> iD8DBQFFQc9XIB7bNG8LQkwRAmi4AJ9usA+SNKCymGmbfQB7uVs/ntJtCQCfRsMW
> PnSDLDpq2jiM294we2TXh34=
> =85WE
> -----END PGP SIGNATURE-----
>
>
>