PDA

View Full Version : Don't know password for postgres



anuplander
06-24-2011, 10:32 PM
Hello

I have just re donwloaded the HEM on my computer and i needed to re download the postgres as well but it says that i need to have a password in order to download it and i don't know it.

I have looked at passed threads about this and it talks about locating a .conf file but it is missing so i am stuck as to what to do.

Patvs
06-25-2011, 11:27 AM
Password is postgrespass
If it doesn't accept the password during the postgresql installation, delete the postgres user.

click on Start and go to Programs -> Accessories -> Command Prompt

* If you are on Vista, rightclick and choose "Run as Administrator".


A black box should appear. Type 'net user postgres /delete' (without the quotes) and press enter.

The user is now deleted and you can (re)install PostgreSQL.

(use the 8.4.8 installer from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org) --> downloads)

anuplander
06-25-2011, 12:30 PM
i am on vista and tried to write in the above on the command box but it said access was denied. I know this is probably because i am not running as an administrator. Can you go into more detail about how i do that please?

Patvs
06-25-2011, 12:43 PM
rightclick and choose "Run as Administrator" on Command Promt and you shouldn't get that error.

anuplander
06-25-2011, 01:03 PM
where exactly do i right click on? The program i opened as well was called "command". When i had the black box opened i right clicked inside it and i couldn't see run as administrator

Patvs
06-25-2011, 01:35 PM
Turn off User Account Control and reboot: How to Disable and Turn Off UAC in Windows 7 « My Digital Life (http://www.mydigitallife.info/2008/12/30/how-to-disable-and-turn-off-uac-in-windows-7/)


That should automatically enable every program to run with proper administrator privileges.

anuplander
06-25-2011, 01:42 PM
will have to try that later on tonight as i am on 9 tables atm and i can't reboot! Thank you sir.

Patvs
06-25-2011, 01:45 PM
http://www.blogsdna.com/wp-content/uploads/2009/01/windows-7-elevated-command-promot-run-as-administrator.png

Or read: Tip: How do I run the command line as an Administrator in Windows Vista | TechRepublic (http://www.techrepublic.com/blog/window-on-windows/tip-how-do-i-run-the-command-line-as-an-administrator-in-windows-vista/603)

anuplander
08-05-2011, 09:31 PM
I now have sorted out the postgres password and managed to download it successfully. Now every time i start up holdem manager i get the error statement saying " the following error occured while trying to open the database. Failed to establish a connection to '127.0.0.1'.

I use vista if that helps.

Patvs
08-05-2011, 09:48 PM
This is usually a firewall or windows update issue.

First try to reboot.

If no help, try this:

Start > Programs > PostgreSQL > 8.x > Stop Service

Start > Programs > PostgreSQL > 8.x > Start Service

If that doesnt help delete the \postgresql\8.x\data\postmaster.pid file, if you see it. And reboot.


If that doesn't help you will have to reinstall PostgreSQL completely

anuplander
08-05-2011, 10:01 PM
reboot doesn't work

tried to stop the server but it says "PostgreSQL server 8.4 is not started.......the stop command returned an error <2>"

When i tried to start the server it had a blank box.

Couldn't find \postgresql\8.x\data\postmaster.pid file, couldn't even find the "data" folder.

Will reinstalling postgresql again really help? If so what version should i use?

Patvs
08-05-2011, 10:27 PM
First try installing 8.4.8 (installing it will update the current installation)
If it won't install/update

Try to install PostgreSQL: Choose a Mirror (http://wwwmaster.postgresql.org/download/mirrors-ftp/binary/v8.2.21/win32/postgresql-8.2.21-1.zip) to port 5433

gabemart42
08-06-2011, 02:29 PM
I'm having the same problems as anuplander. Tried all the above still having the failed to establish connection screen. when i try to upgrade or install it will not let me. I've had hem for a year never had this issue. I have windows 7. thanks for your help.

netsrak
08-07-2011, 06:03 AM
Solutions:
1. Reboot your computer
2. If that doesn't help look for the hidden system file postmaster.pid in the postgresql data folder, delete it and reboot your computer again.
3. Check the postgresql service in the windows services (control panel->administration). Sometimes it helps to change the Logon As.. to "local system account"
4. Check our FAQ:
http://faq.holdemmanager.com/questions/91/Can%27t+Connect+%7B47%7D+Failed+to+Start+PostgreSQ L+

Patvs
08-07-2011, 06:06 AM
Turn on the secondary Logon. The secondary logon service is a standard windows service which is available on every windows computer. In the latest versions it is not started automatically. You need to start it via control panel > administrative tools > services. Starting it once should insure it works in the future also.

Install PostgreSQL: Choose a Mirror (http://wwwmaster.postgresql.org/download/mirrors-ftp/binary/v8.2.21/win32/postgresql-8.2.21-1.zip) to port 5433.


If it doesn't accept postgrespass (as password) during the installation, delete the postgres user first.
click on Start and go to Programs -> Accessories -> Command Prompt

* If you are on Vista, rightclick and choose "Run as Administrator".


A black box should appear. Type 'net user postgres /delete' (without the quotes) and press enter.

The user is now deleted and you can (re)install PostgreSQL.

gabemart42
08-14-2011, 09:43 AM
hey everyone thanks for your help. I'm still having the same issues. I Have
-rebooted
-got a mirror version
-tried an older version
I'm having the same problem regardless of what I do I cant get past the password stage? I have never used a password other then the postgrespass. I cannot get passed the password during the installation stage. It will not accept anything I put in. I have used the command prompt and typed net user postgres/delete it looks like its working but then i have the same issues. sorry to be a pain and thanks again in advance.

Patvs
08-14-2011, 09:55 AM
PM sent