Cant get past password set-up

[jscobie]

Hi,

I have just tried to install postgresql 9.0 and in the installation set-up it is asking me to provide a password for the database superuser. I enter a password and it says incorrect. I click next to allow it to create a password for me and it says a password must be entered. I dont know if I have somehow set-up a password in the past but I am trying the same one I use for everything and it isnt working.

Has anyone else suffered these problems?

Thanks

[jscobie]

Small update on status:

Im in pgAdmin for postgresql 8.3 and trying to change the password there but having no joy as again I dont have the original

Should I uninstall postgresql 8.3 first or could this f**k my PT?

[kraada]

Try dbpass, svcPASS83 and postgrespass and see if any of those work.

[jscobie]

Exerpt from Documentation

"PostgreSQL database passwords are separate from operating system user passwords. The password for each database user is stored in the pg_authid system catalog. Passwords can be managed with the SQL commands CREATE USER and ALTER USER, e.g., CREATE USER foo WITH PASSWORD 'secret'. If no password has been set up for a user, the stored password is null and password authentication will always fail for that user."

Should I try CREATE USER jscobie WITH PASSWORD "my usual password here"

Where do I input this?

Thanks in advance

[kraada]

I don't think the documentation you're quoting is about the password that's the problem for you - there are two postgres user passwords - one for the Windows user, one to connect to the database. You're having problems in the installation which implies the former is the problem, not the latter (which is what the quoted documentation is talking about).

Please follow the uninstall/reinstall instructions on our documentation page as they include instructions on how to delete the postgres Windows user from the command line - once it's deleted, it'll be recreated with whatever password you specify in the installation.

[jscobie]

Try dbpass, svcPASS83 and postgrespass and see if any of those work.

Sorry, they didnt work

[jscobie]

I don't think the documentation you're quoting is about the password that's the problem for you - there are two postgres user passwords - one for the Windows user, one to connect to the database. You're having problems in the installation which implies the former is the problem, not the latter (which is what the quoted documentation is talking about).

Please follow the uninstall/reinstall instructions on our documentation page as they include instructions on how to delete the postgres Windows user from the command line - once it's deleted, it'll be recreated with whatever password you specify in the installation.

I'll give it a try... will let you know how i get on