Thread: Postgres user password
<font face="Calibri, Verdana, Helvetica, Arial"><span style="font-size:11pt">Hello,<br /> I’ve downloaded PostgreSQL8.3.7-1for Mac OSX from <a href="http://www.enterprisedb.com/products/pgdownload.do#osx">http://www.enterprisedb.com/products/pgdownload.do#osx</a><br />The install went OK and the service started OK. I want to connect to the db server in pgAdminIII for the default postgresuser. However when prompted for postgres user password, I’ve tried postgres and it did not work.<br /> How do I goabout changing the password for postgres user?<br /> Michelle</span></font>
Hi Michelle, Le mardi 28 juillet 2009 à 16:51:01, Michelle Lu a écrit : > I¹ve downloaded PostgreSQL8.3.7-1 for Mac OSX from > http://www.enterprisedb.com/products/pgdownload.do#osx > The install went OK and the service started OK. I want to connect to the db > server in pgAdminIII for the default postgres user. However when prompted > for postgres user password, I¹ve tried postgres and it did not work. > How do I go about changing the password for postgres user? Did you try without a password? -- Guillaume.http://www.postgresqlfr.orghttp://dalibo.com
On Tue, Jul 28, 2009 at 3:51 PM, Michelle Lu<Michelle.Lu@mantech.com> wrote: > Hello, > I’ve downloaded PostgreSQL8.3.7-1 for Mac OSX from > http://www.enterprisedb.com/products/pgdownload.do#osx > The install went OK and the service started OK. I want to connect to the db > server in pgAdminIII for the default postgres user. However when prompted > for postgres user password, I’ve tried postgres and it did not work. > How do I go about changing the password for postgres user? > Michelle Edit pg_hba.conf in the data directory and set the appropriate access rule to 'trust', then reload the server config. That will allow you to login without a password, from where you can change it using pgAdmin. But... the password for the postgres user will be set to whatever you specified when you installed, so unless you forgot it, you shouldn't need to change the password. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com