Overview
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.
- Use SSH to log into your Dedicated Server using your admin user.
- Run the following commands:
[server]$ sudo apt-get update [server]$ sudo apt-get install postgresql postgresql-contrib
- 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