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@svana.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@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)
iD8DBQFFQc9XIB7bNG8LQkwRAmi4AJ9usA+SNKCymGmbfQB7uVs/ntJtCQCfRsMW
PnSDLDpq2jiM294we2TXh34=
=85WE
-----END PGP SIGNATURE-----