HOWTO: postgresql on Dremhost Private Server
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:
postgres:x:32:32:PostgreSQL administrator,,,:/var/lib/postgresql:/bin/false
to:
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!
jack1852 and 
jack1852 5:16 pm on June 18, 2011 Permalink |
Domanda forse stupida: cos’è che viene cambiato rispetto a prima? (sappi che non ho un hosting su Dreamhost, solo curiosità linuxiana
)
diegor 11:17 pm on June 19, 2011 Permalink |
La cosa che cambia è il comando da eseguire al login. Ho editato il post. Grazie per la precisazione.
jack1852 6:28 pm on June 20, 2011 Permalink |
In pratica abiliti la possibilità di login dell’utente postgres. Dovrebbe funzionare anche il comando (sempre da root): usermod -s /bin/bash postgres