Skip to content
This repository was archived by the owner on Dec 22, 2023. It is now read-only.

postgresql.md

Latest commit

 

History

History
87 lines (65 loc) · 2.25 KB

postgresql.md

File metadata and controls

87 lines (65 loc) · 2.25 KB

Postgresql README

Installation

Mac OS X

The following examples assumed you had Homebrew and (homebrew-services|https://github.com/gapple/homebrew-services) installed.

  • brew install postgres
  • Stop the server
    • brew services stop postgresql
  • Delete the cluster created by homebrew by default since it might be created with arbitrary locale
    • rm -rf /usr/local/var/postgres
  • Create a new cluster with correct locale
    • initdb --pgdata=/usr/local/var/postgres --locale=en_US.UTF-8
  • Now start the postgres server
    • brew services start postgresql
  • Create a default database to avoid psql complaining
    • createdb
  • Verify database is created correctly w.r.t cluster locale
    • psql, then;
    • \l 
      ...
   Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges
 limouren  | limouren | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
  • Now create a new database for Skygear
    • createdb skygear
  • Done!

Ubuntu

Precise

  1. sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
  2. sudo apt-get install wget ca-certificates
  3. wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
  4. sudo apt-get update
  5. sudo apt-get install postgresql-9.5 pgadmin3
  6. Done!

See (Apt|https://wiki.postgresql.org/wiki/Apt) in the Postgresql's wiki for more information.

Trusty

  1. sudo apt-get install postgresql-9.5 pgadmin3
  2. Done!

After postgresql installed:

Let's say we are running skygear server under the user account named skyuser

  1. sudo su postgres
  2. createuser --superuser skyuser
  3. exit
  4. sudo su skyuser
  5. createdb; stop psql from complaining
  6. createdb skygear
  7. psql
  8. \l; verify that the database is created correctly
Name    | Owner    | Encoding |   Collate   |    Ctype    |   Access privileges
--------+----------+----------+-------------+-------------+-----------------------
skygear | skyuser  | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
  1. Done!

PostGIS

Skygear uses PostGIS extension to handle geometry stroage and query.

To install:

Mac OS X

$ brew install postgis

Deb

$ sudo apt-get postgis-2.2