Need default password for the user "sa"

Hello

PostgreSQL doesn't know username "sa". Same role is "postgres" in PostgreSQL.

What is your operation system?

regards
Pavel Stehule

p.s. it isn't bug, so mail to mailing list general -
http://www.postgresql.org/mailpref/pgsql-general

2008/8/25 Janardhanachari, Jagadeesha <Jagadeesha.Janardhanachari@fmr.com>:

What is the password for postgres ?

_______________________________________
Jagu
Fidelity Business Services India.
Mobile: 9900540134
Direct : 40334528
Voip : 8-658-1596

Any comments or statements made in this email are not necessarily those
of Fidelity Business Services India Pvt. Ltd. or any of the Fidelity
Investments group companies. The information transmitted is intended
only for the person or entity to which it is addressed and may contain
confidential and/or privileged material. If you have received this in
error, please contact the sender and delete the material from any
computer. All e-mails sent from or to Fidelity Business Services India
Pvt. Ltd. may be subject to our monitoring procedures

-----Original Message-----
From: Pavel Stehule [mailto:pavel.stehule@gmail.com]
Sent: Monday, August 25, 2008 7:47 PM
To: Janardhanachari, Jagadeesha
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] Need default password for the user "sa"

Hello

PostgreSQL doesn't know username "sa". Same role is "postgres" in
PostgreSQL.

What is your operation system?

regards
Pavel Stehule

p.s. it isn't bug, so mail to mailing list general -
http://www.postgresql.org/mailpref/pgsql-general

2008/8/25 Janardhanachari, Jagadeesha
<Jagadeesha.Janardhanachari@fmr.com>:

HI,

I have installed "Postgresql" but don't know the login password for
"sa".
please help me.

_______________________________________
Jagu
Fidelity Business Services India.
Mobile: 9900540134
Direct : 40334528
Voip : 8-658-1596

Any comments or statements made in this email are not necessarily

those

2008/8/25 Janardhanachari, Jagadeesha <Jagadeesha.Janardhanachari@fmr.com>:

What is the password for postgres ?

You filled it on win platforms, on unix platform this password isn't
filled. Try to login as system user postgres, then open local connect
to postgresql and then you can change password.

Pavel

In response to "Janardhanachari, Jagadeesha" <Jagadeesha.Janardhanachari@fmr.com>:

What is the password for postgres ?

There is none. Please read:
http://www.postgresql.org/docs/8.3/static/client-authentication.html

Then take any further discussion on the matter to the pgsql-general@
mailing list.

--
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

wmoran@collaborativefusion.com
Phone: 412-422-3463x4023

Jagadeesha.Janardhanachari@fmr.com ("Janardhanachari, Jagadeesha") writes:

What is the password for postgres ?

This isn't a bug, to be sure, and there isn't a password declared, by
default.

The account that is created, initially, by default, has *no* password,
which means you must connect via some means that does not require a
password. You can control this via pg_hba.conf:

http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html
--
output = reverse("gro.mca" "@" "enworbbc")
http://cbbrowne.com/info/spiritual.html
"LISP car-and-cdr worlds are a more reasonable representation of the
things that make life interesting than fixed decimal(15) or FILE
OLDMSTR RECORD IS PAYROLL." -- Bernie Greenberg.

HI,

Thanks for your reply, but tell me what is the default password for
postgres on windows environment ?

_______________________________________
Jagu
Fidelity Business Services India.
Mobile: 9900540134
Direct : 40334528
Voip : 8-658-1596

Any comments or statements made in this email are not necessarily those
of Fidelity Business Services India Pvt. Ltd. or any of the Fidelity
Investments group companies. The information transmitted is intended
only for the person or entity to which it is addressed and may contain
confidential and/or privileged material. If you have received this in
error, please contact the sender and delete the material from any
computer. All e-mails sent from or to Fidelity Business Services India
Pvt. Ltd. may be subject to our monitoring procedures

-----Original Message-----
From: Pavel Stehule [mailto:pavel.stehule@gmail.com]
Sent: Monday, August 25, 2008 7:59 PM
To: Janardhanachari, Jagadeesha
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] Need default password for the user "sa"

2008/8/25 Janardhanachari, Jagadeesha
<Jagadeesha.Janardhanachari@fmr.com>:

What is the password for postgres ?

You filled it on win platforms, on unix platform this password isn't
filled. Try to login as system user postgres, then open local connect
to postgresql and then you can change password.

Pavel

_______________________________________
Jagu
Fidelity Business Services India.
Mobile: 9900540134
Direct : 40334528
Voip : 8-658-1596

Any comments or statements made in this email are not necessarily

those

of Fidelity Business Services India Pvt. Ltd. or any of the Fidelity
Investments group companies. The information transmitted is intended
only for the person or entity to which it is addressed and may contain
confidential and/or privileged material. If you have received this in
error, please contact the sender and delete the material from any
computer. All e-mails sent from or to Fidelity Business Services India
Pvt. Ltd. may be subject to our monitoring procedures

-----Original Message-----
From: Pavel Stehule [mailto:pavel.stehule@gmail.com]
Sent: Monday, August 25, 2008 7:47 PM
To: Janardhanachari, Jagadeesha
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] Need default password for the user "sa"

Hello

PostgreSQL doesn't know username "sa". Same role is "postgres" in
PostgreSQL.

What is your operation system?

regards
Pavel Stehule

p.s. it isn't bug, so mail to mailing list general -
http://www.postgresql.org/mailpref/pgsql-general

2008/8/25 Janardhanachari, Jagadeesha
<Jagadeesha.Janardhanachari@fmr.com>:

HI,

I have installed "Postgresql" but don't know the login password for
"sa".
please help me.

_______________________________________
Jagu
Fidelity Business Services India.
Mobile: 9900540134
Direct : 40334528
Voip : 8-658-1596

Any comments or statements made in this email are not necessarily

those

of Fidelity Business Services India Pvt. Ltd. or any of the Fidelity
Investments group companies. The information transmitted is intended
only for the person or entity to which it is addressed and may

contain

confidential and/or privileged material. If you have received this in
error, please contact the sender and delete the material from any
computer. All e-mails sent from or to Fidelity Business Services

India

On Tue, Aug 26, 2008 at 7:16 AM, Janardhanachari, Jagadeesha
<Jagadeesha.Janardhanachari@fmr.com> wrote:

HI,

Thanks for your reply, but tell me what is the default password for
postgres on windows environment ?

Assuming you used the installer, whatever password you entered when
prompted. It won't let you continue without entering something.

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com