Postgres Password

When you let the installer, install Postgres, it does not let you change the default password.    I looked at the password that the installer used and copied it.   Then restarted the install and the password although complex it appears to be fixed and does not change.

Having to deal with security issues on a regular basis, I was hoping to be able to customize the password or at the very least let it be generated at random.

Although, I suspect there is a way I can do this after installation.

The password is generated by the installer, at least that’s my understanding of it, will check tomorrow.

Hi Robert

The password is indeed fixed, I’m looking at ways to get the installer to generated a random password and also how to let the user customise it. One thing to note is that we install postgres so that it only listens on 127.0.0.1 so it’s not accessible from other machines, and it’s on a non standard port.

Another item that would be useful to people like me is to actually allow the specification of the PostgreSQL install path. Or at the very least, let us know where it goes.

I would much rather have it installed in a known location that’s not on my system drive. Old habits die hard.

And for those of us who don’t know (or want to know) are there plans to include some basic backup scripts for the PostgreSQL data?