Re: 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(at)svana(dot)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

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

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(at)svana(dot)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, Martijn van Oosterhout <kleptog(at)svana(dot)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(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)
>
> iD8DBQFFQdXOIB7bNG8LQkwRAripAJ9OVbCQxoJZv7MbC0J6kpx36cyq8QCfdXzR
> CygEQSlRzRTwk2KoZ9z5ZkE=
> =4ZZc
> -----END PGP SIGNATURE-----
>
>
>

On 10/27/06, Purusothaman A <purusothaman(dot)a(at)gmail(dot)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(at)svana(dot)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(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)
>>
>> iD8DBQFFQdXOIB7bNG8LQkwRAripAJ9OVbCQxoJZv7MbC0J6kpx36cyq8QCfdXzR
>> CygEQSlRzRTwk2KoZ9z5ZkE=
>> =4ZZc
>> -----END PGP SIGNATURE-----
>>
>>
>>
>

--

Shane Ambler
pgSQL(at)007Marketing(dot)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

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