Menu
I installed Postgres on Windows 7, it only asks me for password not for username so what's the default. It is said here:
When Postgres is installed in your account, there is a default user with the same name as the account (login) name
It's not crystal clear. Is it the username of my computer account?
723
There is no 'default' PostgreSQL username/password. The credentials supplied in the install process are also used to make these accounts. If you know that username and password you might be able to use the same password to log into PostgreSQL.
It should not be your default. Create an ordinary user, possibly one with CREATEDB rights, but not a superuser. Use that user for most tasks and only switch to a superuser ( postgres or some other user you created for the purpose) when you need superuser rights.
PostgreSQL: Find Users in PostgreSQL Answer: In PostgreSQL, there is a system table called pg_user. You can run a query against this system table that returns all of the Users that have been created in PostgreSQL as well as information about these Users.
Default Username of PostgreSQL on Windows is postgres.
I don't know what installer have you used but when I install it the username is clearly indicated:
156
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
