PostgreSQL – Default Password Information

postgresql

What is the default password for the "postgres" user when I install postgreSQL on Windows? I googled for "postgres default password" but it doesn't return any immediate result.

Best Answer

There is no default password on Windows - the install will ask you during the wizard to create one. If you forgot or don't remember you can:

Go to Control Panel -> Administrative Tools -> Computer Management. There under "Local Users and Groups" you can see all users created for your system. Remove "postgres" and reinstall PostgreSQL

Related Solutions

PostgreSQL – Startup Script for Second Instance on Ubuntu

If you're on Ubuntu, which it seems like you are, you don't have to roll any of this yourself.

Read the docs for pg_ctlcluster, pg_createcluster, pg_lsclusters. These are part of the pg_wrapper package for Ubuntu, which provides management of multiple instances and versions built-in.

Windows – How to install PostgreSQL using the command prompt

You change the directory (cd) to the one where you downloaded the PostgreSQL installer to and just type in the name of the executable and hit enter.

As an example:

cd C:\Users\<User>\Download\
PostgreSQL-Installer.exe

Or just use the whole path (be careful with spaces):

C:\Users\<User>\Download\PostgreSQL-Installer.exe

Another option would've been to rightclick while holding Shift and selecting "Run as different User" or "Run as administrator". Both methods might not working depending on whenver administrative priviliges or a separate user account are actually needed.

Best Answer

Related Solutions

PostgreSQL – Startup Script for Second Instance on Ubuntu

Windows – How to install PostgreSQL using the command prompt

Related Question