[GENERAL] what is the default username password for PostgreSQL, which was installed with FC5.

2006-10-27 Thread Purusothaman A
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.:)Purusothaman A

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

2006-10-27 Thread Martijn van Oosterhout
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

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

2006-10-27 Thread A. Kretschmer
am Fri, dem 27.10.2006, um 14:45:57 +0530 mailte Purusothaman A folgendes: 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. The postgres-User isn't a login-user. Become root (su ), and then 'su -

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

2006-10-27 Thread Purusothaman A
Thanks for your immediate reply.I created new role db1 and database db1.but I cannot login using psql -Udb1 -ddb1 -hlocalhostresultsFatal Error : Ident authentication failed for user db1. Waiting for your valuable suggestion.Thanks in advance.:)Purusothaman AOn 10/27/06, Martijn van Oosterhout

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

2006-10-27 Thread A. Kretschmer
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

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

2006-10-27 Thread Martijn van Oosterhout
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

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

2006-10-27 Thread Purusothaman A
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 AOn 10/27/06, Martijn van Oosterhout kleptog@svana.org

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

2006-10-27 Thread chris smith
On 10/27/06, Purusothaman A [EMAIL PROTECTED] 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.

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

2006-10-27 Thread Purusothaman A
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