Setup PostgreSQL Database - charleshross/soarin GitHub Wiki

This guides assumes you have already installed a fresh copy of 64bit Debian Linux (https://www.debian.org/distrib/netinst) on your server or virtual machine.

• Words like this are commands to run on your server or virtual machine.
• The 'pico' text editor I use comes with Debian and is super simple to use. Arrow keys to navigate, and in order press "[CTRL]+[X], [Y], [ENTER]" to save.

To begin installing, SSH into your Linux Debian server.

Install PostgreSQL

---

PostgreSQL is another great relational database that has been quietly stealing the thunder from MySQL, I recommend having both.

Note: This step is optional but if you skip it your compiled PHP and Soarin deployment will not support PostgreSQL.

Create the file /etc/apt/sources.list.d/pgdg.list

sudo pico /etc/apt/sources.list.d/pgdg.list

Paste the following in the file and save it

deb http://apt.postgresql.org/pub/repos/apt/ wheezy-pgdg main

Import the repository signing key

sudo wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | apt-key add -

Update the package lists

sudo apt-get update

You can now check to see what the latest version is with apt-cache show postgresql and apt-cache show pgadmin3

As of this writing the next command for v9.3 of PostgreSQL with pgadmin3 was

sudo apt-get install postgresql=9.3+151.pgdg70+1 pgadmin3=1.18.1-1.pgdg70+1