password for postgres

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

password for postgres

Postby saadeet » Fri Jul 22, 2011 7:40 am

windows 7 home premium.
Attempting to install postgresql9.0.4 windows_x64

I have had postgresql installed before or have tried to install it. I have uninstalled deleted folders with postgresql and tried the: net user postgres/delete which says NET USER
[contraseña : *] [opciones]] [/DOMAIN]
etc. etc.
When installing it asks for a password, I have tried the usual dbpass etc. but that does not work. I saw that to avoid this I could enter computer administration and delete the postgresql in users, but the users do not appear. This seems to be on home premium that they do not appear.

So now I need some help. Any suggestions on how to get this installed and get around the password problem?
saadeet
 
Posts: 13
Joined: Sun Mar 16, 2008 6:09 pm

Re: password for postgres

Postby saadeet » Fri Jul 22, 2011 7:56 am

Ok, managed to change the password with command prompt, but now when installing pt3 in the configure postgreSQL Server it is unable to connect.
saadeet
 
Posts: 13
Joined: Sun Mar 16, 2008 6:09 pm

Re: password for postgres

Postby kraada » Fri Jul 22, 2011 8:11 am

That password is not the same as the database password - try using postgrespass and see if it works. If it doesn't, try following this tutorial as that will likely get things working for you.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: password for postgres

Postby saadeet » Fri Jul 22, 2011 12:08 pm

The password does not work and the tutorial is for 8.3 and 8.4, I have installed 9.0.
I have followed the firewall guide and this does not help either.

Other suggestions?
saadeet
 
Posts: 13
Joined: Sun Mar 16, 2008 6:09 pm

Re: password for postgres

Postby kraada » Fri Jul 22, 2011 12:52 pm

There is an identical file in a similar location in 9.0 and once you change it in the same way it will still fix the problem when you restart PostgreSQL.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: password for postgres

Postby saadeet » Sun Jul 24, 2011 8:42 am

Not on my computer. In the data folder there are no files and I cannot find a pg_hba.conf file anywhere in the 9.0 folder.
saadeet
 
Posts: 13
Joined: Sun Mar 16, 2008 6:09 pm

Re: password for postgres

Postby WhiteRider » Sun Jul 24, 2011 11:21 am

If there are no files in the 9.0 folder then it is not installed correctly. Please try uninstalling and reinstalling it - the guides in the Documentation are for 8.3 or 8.4 but the process is basically the same.
If you still have problems please create a Support ticket and one of our support technicians will work with you to get things working.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: password for postgres

Postby saadeet » Sun Jul 24, 2011 1:14 pm

In the data folder there are no files. There are plenty of files in the 9.0 folder
saadeet
 
Posts: 13
Joined: Sun Mar 16, 2008 6:09 pm

Re: password for postgres

Postby saadeet » Sun Jul 24, 2011 1:30 pm

I uninstalled and installed again. When the installation finishes it says: Problem running post-install step. Installation may not complete correctly. The database cluster initialisation failed.
saadeet
 
Posts: 13
Joined: Sun Mar 16, 2008 6:09 pm

Re: password for postgres

Postby kraada » Mon Jul 25, 2011 8:42 am

WhiteRider wrote:If you still have problems please create a Support ticket and one of our support technicians will work with you to get things working.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 28 guests

cron