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