Re: postgres password - Mailing list pgsql-general

From Shoaib Mir
Subject Re: postgres password
Date
Msg-id bf54be870606151316g7f6b11a3vc8ce210b53e6da1a@mail.gmail.com
Whole thread Raw
In response to Re: postgres password  ("LLC" <kevin@kevinkempterllc.com>)
List pgsql-general
When you are logged in as user 'postgres' then you can run the pg_ctl reload like this:

pg_ctl -D <path of your datafolder> reload

/Shoaib

On 6/16/06, LLC <kevin@kevinkempterllc.com> wrote:
You cannot use the postgres account without some tweaks, Sorry I don't remember where I found this info - somewhere in the pgadmin install docs.
 
Create a new superuser with a password, add connectivity to the pg_hba.conf file if needed and pgadmin should work fine

----- Original Message -----

On Thu, 2006-06-15 at 13:24, Jasbinder Bali wrote:



> Hello,
> > I'm trying to connect to the local postgres database using pgadmin.
> It
> > asks for a password that i never set and hence i'm not able to
> connect
> > to my local postgres database.
> > Also, when i click postgresql help option in the Help tab of
> pgadmin,
> > the pgadmin screen would close down. Don't know whats going on
> wrong.
> >




Take a look here:







http://www.postgresql.org/docs/8.1/static/client-authentication.html




Basically, the password isn't set yet. You may or may not need to set



one depending on how you configure pg_hba.conf







---------------------------(end of broadcast)---------------------------



TIP 1: if posting/reading through Usenet, please send an appropriate



subscribe-nomail command to majordomo@postgresql.org so that your



message can get through to the mailing list cleanly








pgsql-general by date:

Previous
From: "shyju c.k"
Date:
Subject: query optimizer
Next
From: "Milen Kulev"
Date:
Subject: Re: query optimizer