Install Postgresql in VPS Ubuntu 12.04

[jhernandez]

Hi

I'm trying to install postgresql with

apt-get install postgresql postgresql-client

but, the postgres services is not active.

When i run

/etc/init.d/postgresql status

Nothing comes. Anyone has had the same problem ?

[suwunk]

Hi There,

Hope this following tutorial helps
PostgreSQL installation in Ubuntu 12.04 « railskey (http://railskey.wordpress.com/2012/05/19/postgresql-installation-in-ubuntu-12-04/)

Cheers

[jhernandez]

thanl's but, the problem is the service.

even when i try this:

# psql
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

the service not work

[jhernandez]

Answer me:

i purge all postgresql packages

# apt-get --purge remove postgresql*

And then, i follow the tutorial PostgreSQL installation in Ubuntu 12.04 « railskey (http://railskey.wordpress.com/2012/05/19/postgresql-installation-in-ubuntu-12-04/)

and the services work, thank you @suwunk.

[suwunk]

You're welcome. Thanks for sharing the detailed step with us.
Have a nice day!!