News

Welcome to End Point’s blog

Ongoing observations by End Point people

Windows installer tip: passwords

Updated below!

When specifying a password for the Windows PostgreSQL one-click installer, you get this message:

Please provide a password for the database superuser and service account (postgres). If the service account already exists in Windows, you must enter the current password for the account. If the account does not exist, it will be created when you click 'Next'.

If you have already installed Postgres as a service, you will need to enter the current user postgres service user password to get past the password dialog box. Meaning, if you're logged in to Windows as 'selena', you need to enter selena's password. As a non-Windows user, this baffled me, and a few other people on this thread.

Otherwise, you can just enter a password that will be used for the 'postgres' database user. Hope this helps someone!

Update:

Further explanation from Dave Page, the maintainer of the windows package:

Selena: It's not the password for the user that you are logged in as that you need to enter, it's the password for the service account (ie. postgres).

Unlike *nix & Mac, service accounts on Windows need to have passwords so unfortunately we need to ensure we have the correct password to install the service. Hence, if there's an existing postgres account, we need the existing password, otherwise the account will be created with whatever password you specify.

In all OSs, we use the password entered on that page as the database superuser password.

5 comments:

Anonymous said...

Another issue baffled me last time I ran that thing on a freshly installed machine. When I ran it the account did of course not exist so a password was generated. But there was no possibility of copying it and it was too long for it to be worthwhile to write down for use next time.

Now this was a while ago so it might be fixed.

pgolub said...

May be this post will help someone:
http://pgolub.wordpress.com/2009/05/28/postgresql-8-4-beta2-under-windows-installation-issue/

I wrote about beta2 installer, but the things are the pritty same for official 8.4.0

pgSnake said...

@Anonymous: The one-click installer *never* generates a password. You must be thinking of the old MSI installer.

pgSnake said...

Selena: It's not the password for the user that you are logged in as that you need to enter, it's the password for the service account (ie. postgres).

Unlike *nix & Mac, service accounts on Windows need to have passwords so unfortunately we need to ensure we have the correct password to install the service. Hence, if there's an existing postgres account, we need the existing password, otherwise the account will be created with whatever password you specify.

In all OSs, we use the password entered on that page as the database superuser password.

Anonymous said...

I struggled to use secure passwords and then remember them when required. I have started using pixelock.com and its fast and easy but is it as secure as they claim, any opinions?

Cheers
Steve