Diego Russo

HOWTO: postgresql on Dremhost Private Server

less than 1 minute read

If you have a PS with
DreamHost and you need to use
PostgreSQL as database, you’ll see that’s
impossible to login with postgres user and so you won’t able to use
PostgreSQL.
Dreamhost supports officially only MySQL, so they don’t provide any info about
PostgreSQL.
Anyway the problem of using PostgreSQL in DH’s PS is permit the login to
postgres user. Follow this two steps:

Become root, typing:

$ sudo su

Edit /etc/passwd file and find the line containing postgres. Change it from: