I have just installed postgres 8.4 on Ubuntu 9.10 and it has never asked me to create a superuser. Is there a default superuser and its password? If not, how do I create a new one?
CAUTION The answer about changing the UNIX password for "postgres" through "$ sudo passwd postgres" is not preferred, and can even be DANGEROUS!
This is why: By default, the UNIX account "postgres" is locked, which means it cannot be logged in using a password. If you use "sudo passwd postgres", the account is immediately unlocked. Worse, if you set the password to something weak, like "postgres", then you are exposed to a great security danger. For example, there are a number of bots out there trying the username/password combo "postgres/postgres" to log into your UNIX system.
What you should do is follow Chris James's answer:
sudo -u postgres psql postgres # \password postgres Enter new password:
To explain it a little bit. There are usually two default ways to login to PostgreSQL server:
By running the "psql" command as a UNIX user (so-called IDENT/PEER authentication), e.g.:
sudo -u postgres psql. Note that
sudo -udoes NOT unlock the UNIX user.
by TCP/IP connection using PostgreSQL's own managed username/password (so-called TCP authentication) (i.e., NOT the UNIX password).
So you never want to set the password for UNIX account "postgres". Leave it locked as it is by default.
Of course things can change if you configure it differently from the default setting. For example, one could sync the PostgreSQL password with UNIX password and only allow local logins. That would be beyond the scope of this question.
Enter on the command line:
$ sudo -u postgres psql postgres postgres=# \password postgres
Enter new password: Enter it again:
You manipulate postgres through the user
postgres, as so:
# su - postgres $ createdb mydb $ psql -s mydb # create user someuser password 'somepassword'; # GRANT ALL PRIVILEGES ON DATABASE mydb TO someuser;
In Windows, do the following (IMPORTANT: Use a Windows administrator account):
After installation, open
Modify these two lines, and change "md5" to "trust":
host all all 127.0.0.1/32 md5
host all all ::1/128 md5
Restart the PostgreSQL service (might not be necessary).
(Optional) Open a command prompt, and change code page to 1252:
cmd.exe /c chcp 1252
Log in to PostgreSQL. Non password will be needed (notice the uppercase -U parameter):
psql -U postgres
(Optional, recommended for security reasons) Change the
and change "trust" back to "md5" in
If you are trying to access the PostgreSQL shell, you can type:
psql -U postgres my_database
my_database is your database name.
protected by Chris S Nov 18 '14 at 20:24
Thank you for your interest in this question.
Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?