Overview
The following instructions show you how to install PostgreSQL on a Dedicated Server.
Background
PostgreSQL is a SQL database product comparable to MySQL. It is 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.
Make sure you are aware of the following before proceeding:
- This article contains information/examples using root/sudo/admin users. If you require sudo/admin access, you must upgrade to a Dedicated Server.
- DreamHost support is unable to provide any assistance with this configuration.
Installing 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