Обсуждение: Need default password for the user "sa"
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 Pvt. Ltd. may be subject to our monitoring procedures
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 > Pvt. Ltd. may be subject to our monitoring procedures > > > > -- > Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-bugs >
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 >> Pvt. Ltd. may be subject to our monitoring procedures >> >> >> >> -- >> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-bugs >> > > >
What is the password for postgres ?=20 _______________________________________ 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]=20 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 > Pvt. Ltd. may be subject to our monitoring procedures > > > > -- > Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-bugs >
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]=20 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 >> Pvt. Ltd. may be subject to our monitoring procedures >> >> >> >> -- >> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-bugs >> > > >
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