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:

  1. Become root, typing:

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

    postgres:x:32:32:PostgreSQL administrator,,,:/var/lib/postgresql:/bin/false


    postgres:x:32:32:PostgreSQL administrator,,,:/var/lib/postgresql:/bin/bash

Now you can become postgres user and you can use PostgreSQL.
Doubts? Comment! :)

PS: Are you looking for a serious, riable and fast hosting? So Dreamhost is for you! Use Dreamhost promo code “DIEGOR” or click on this link to get 50$ off right now!