Обсуждение: Just Forgot
All, Do not use PG that often and have it installed on several PCs. Have it turned off normally so have to go to: Start + All Programs + System Tools + Administrative Tools + Services find PG in the list and start. Then I open my pgAdminIII and attempt login. Somehow it is not accepting the UID/PWD combo I set for this, and I have forgotten the defaults, so can not get in. I have been looking for the install notes to find the defaults but forgot where I put them and could not find online. A quick help with HOWTO URL would be nice right now! Thanks! OMR -- View this message in context: http://www.nabble.com/Just-Forgot-tp24972962p24972962.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
David,
You need to set your pg_hba.conf method to trust for your
connection and reload your configuration (service). That way you'll be
able to get into your database and change your pwd.
Regards,
gb.-
On Fri, Aug 14, 2009 at 11:49 AM, OldManRiver<davisoft@megsinet.net> wrote:
>
> All,
>
> Do not use PG that often and have it installed on several PCs. Have it
> turned off normally so have to go to:
>
> Start + All Programs + System Tools + Administrative Tools + Services
>
> find PG in the list and start. Then I open my pgAdminIII and attempt login.
>
> Somehow it is not accepting the UID/PWD combo I set for this, and I have
> forgotten the defaults, so can not get in. I have been looking for the
> install notes to find the defaults but forgot where I put them and could not
> find online.
>
> A quick help with HOWTO URL would be nice right now!
>
> Thanks!
>
> OMR
> --
> View this message in context: http://www.nabble.com/Just-Forgot-tp24972962p24972962.html
> Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
Explain please! Guido Barosio wrote: > > David, > > You need to set your pg_hba.conf method to trust for your > connection and reload your configuration (service). That way you'll be > able to get into your database and change your pwd. > > Regards, > gb.- > > On Fri, Aug 14, 2009 at 11:49 AM, OldManRiver<davisoft@megsinet.net> > wrote: >> >> All, >> >> Do not use PG that often and have it installed on several PCs. Have it >> turned off normally so have to go to: >> >> Start + All Programs + System Tools + Administrative Tools + Services >> >> find PG in the list and start. Then I open my pgAdminIII and attempt >> login. >> >> Somehow it is not accepting the UID/PWD combo I set for this, and I have >> forgotten the defaults, so can not get in. I have been looking for the >> install notes to find the defaults but forgot where I put them and could >> not >> find online. >> >> A quick help with HOWTO URL would be nice right now! >> >> Thanks! >> >> OMR >> -- >> View this message in context: >> http://www.nabble.com/Just-Forgot-tp24972962p24972962.html >> Sent from the PostgreSQL - admin mailing list archive at Nabble.com. >> >> >> -- >> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-admin >> > > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin > > -- View this message in context: http://www.nabble.com/Just-Forgot-tp24972962p24974044.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
OldManRiver wrote: > Somehow it is not accepting the UID/PWD combo I set for this, and I have > forgotten the defaults, so can not get in. I have been looking for the > install notes to find the defaults but forgot where I put them and could not > find online. http://wiki.postgresql.org/wiki/FAQ#I_lost_the_database_password.__What_can_I_do_to_recover_it.3F -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
All, I had to change both entries to "trust" for it to work and also changed the passwords and set up backup admin user. Thanks! OMR -- View this message in context: http://www.nabble.com/Just-Forgot-tp24972962p25008848.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.