Обсуждение: what is the default username password for PostgreSQL, which was installed with FC5.

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

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

(Debian, but i'm sure with FC5 the same)


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47215,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

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

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


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47215,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

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@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

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, Purusothaman A <purusothaman.a@gmail.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.

Set up your pg_hba.conf file to what you need.

I have a small article about this on my site:

http://www.designmagick.com/article/4/

The postgres documentation is here:
http://www.postgresql.org/docs/current/static/client-authentication.html
--
Postgresql & php tutorials
http://www.designmagick.com/

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

In your data directory you will find a file called pg_hba.conf - the
entries in there determine who can log in from what machine with what
sort of authentication.

There are plenty of notes explaining it in the file itself or you can
find explanations in the docs -
http://www.postgresql.org/docs/8.1/static/client-authentication.html

you will probably want to add something like -

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
host    all         all         192.168.2.0/24        md5

and maybe -
host    all         all         127.0.0.1/32          md5


> :)
> Purusothaman A
>
> On 10/27/06, Martijn van Oosterhout <kleptog@svana.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@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)
>>
>> iD8DBQFFQdXOIB7bNG8LQkwRAripAJ9OVbCQxoJZv7MbC0J6kpx36cyq8QCfdXzR
>> CygEQSlRzRTwk2KoZ9z5ZkE=
>> =4ZZc
>> -----END PGP SIGNATURE-----
>>
>>
>>
>


--

Shane Ambler
pgSQL@007Marketing.com

Get Sheeky @ http://Sheeky.Biz

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