3

I am trying to install this Temporal Tables extension into my localhost installation of PostgreSQL. (pg9.4, windows 7)

I have figured out I needed to put the files into the 9.4/share/contrib folder (currently the files are at 9.4/share/contrib/temporal_tables-1.0.2) but I cannot figure out how to make CREATE EXTENSION work. I know I have to do the windows equivalent of "make install", and I would like to avoid needing to use Visual Studio if I can.

  • Please give us more info. You can not run "CREATE EXTENSION temporal_tables;" or else ? – Luan Huynh Oct 23 '15 at 2:31
  • my issue is I was working in windows; I've started up a linux VM now so that ought to solve my problems with working in windows – NextTime Oct 28 '15 at 0:03
0

Since you are on Windows, you also have to copy the compiled DLLs to your PostgreSQL lib directory. Step-by-step instructions are in the manual.

0

From the docs,

Compiling Yourself

If you are running Windows, you need to run the MSBuild command in the Visual Studio command prompt.

msbuild /p:pgversion=9.4 /p:configuration=Release /p:platform=x64

The platforms available are x64 and x86 and the configuration are 9.2, 9.3 , 9.4, and 9.5.

Compiled Download

Or you can download the latest released zip here.

Installing

Then you must copy the DLL from the project into the PostgreSQL's lib directory and the .sql and .control files into the directory share\extension.

copy x64\9.4\temporal_tables.dll "C:\Program Files\PostgreSQL\9.4\lib"
copy *.control "C:\Program Files\PostgreSQL\9.4\share\extension"
copy *.sql "C:\Program Files\PostgreSQL\9.4\share\extension"

Once the extension is installed, you can add it to a database. Connect to a database as a super user and do this:

$ CREATE EXTENSION temporal_tables;

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.