Overview
PostgreSQL is a SQL database product comparable to MySQL, most commonly used as the platform for PostGIS, a set of GIS extensions for handling geospatial data. DreamHost does not support PostgreSQL, and it can only be installed on a Dedicated Server. The following instructions show you how to install it.
Make sure you are aware of the following before proceeding:
This article contains information/examples using sudo/admin users. If you require sudo/admin access, you must upgrade to a Dedicated Server.
You can also install PostgreSQL on a DreamCompute instance after creating a sudo user.
DreamHost support is unable to provide any assistance with this configuration.
How do I install PostgreSQL on a Dedicated Server?
To install PostgreSQL:
Use SSH to log in to your Dedicated Server using your admin user.
Run the following commands:
[server]$ sudo apt-get update [server]$ sudo apt-get install postgresql postgresql-contrib
To make sure PostgreSQL is working after it's installed, run the following command:
[server]$ psql --version psql (PostgreSQL) 9.1.14 contains support for command-line editing
See also
DreamHost links
Third-party links
