This article contains information/examples using root/sudo/admin users. If you require sudo/admin access, you must upgrade to a Dedicated Server.

PostgreSQL is a SQL database product comparable to MySQL. PostgreSQL is most commonly the platform for PostGIS, a set of GIS extensions for handling geospatial data. DreamHost does not support PostgreSQL.

Installing PostgreSQL on a Dedicated Server

DreamHost support is unable to provide any assistance with this configuration.

  1. Use SSH to log into your Dedicated Server using your admin user.
  2. Run the following commands:
    [server]$ sudo apt-get update
    [server]$ sudo apt-get install postgresql postgresql-contrib
  3. Run the following command to see if it’s functioning. PostgreSQL should now be installed:
    [server]$ psql --version
    psql (PostgreSQL) 9.1.14
    contains support for command-line editing

See also

Did this article answer your questions?

Article last updated PST.

Still not finding what you're looking for?