PostgreSQL

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. As of April 2015, DreamHost does not support PostgreSQL. You can always add a Suggestion in the user forum to add support.

DreamHost support is unable to provide any assistance for these instructions. If anything does not function as intended, you must check the DreamHost forum for forum user assistance. Support cannot assist in any way 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. PostgreSQL should now be installed. Run the following command to see if it’s functioning:

   [server]$ psql --version
   psql (PostgreSQL) 9.1.14
   contains support for command-line editing