arkhipov / temporal_tables

Temporal Tables PostgreSQL Extension
BSD 2-Clause "Simplified" License
937 stars 47 forks source link

Procedures for installing on EC2 #27

Open jerryhall opened 7 years ago

jerryhall commented 7 years ago

I tripped up a number of times trying to install this on my AWS instance and thought this might help: Environment: Centos 6 - AWS EC2 - Postgres 95 - Python 2.7 Installing this PG Extension w/o pgxn //no extra sudos, nothing different than this:

$ cd /tmp
$ mkdir /tmp/temp_tables
$ cd /tmp/temp_tables
$ git clone https://github.com/arkhipov/temporal_tables.git
$ make //don't do in sudo)
$ sudo make install
$ make installcheck //don't do in sudo) //http://stackoverflow.com/questions/37661605/how-to-set-user-for-installcheck-in-the-makefile-of-a-postgres-extension
$ PGUSER=postgres make installcheck
$ su - postgres //login as postgres (pg root)
$ psql postgresql //connect to db named postgres
$ CREATE EXTENSION temporal_tables; //create extension
for usage see: //https://github.com/arkhipov/temporal_tables