Installation

pg_timetable is compatible with the latest supported PostgreSQL versions: 11, 12, 13, 14 (stable); 15 (dev).

Older PostgreSQL versions (9.5, 9.6, and 10)

If you want to use pg_timetable with older versions (9.5, 9.6 and 10), please execute this SQL command before running pg_timetable:

CREATE OR REPLACE FUNCTION starts_with(text, text)
RETURNS bool AS 
$$
SELECT 
    CASE WHEN length($2) > length($1) THEN 
        FALSE 
    ELSE 
        left($1, length($2)) = $2 
    END
$$
LANGUAGE SQL
IMMUTABLE STRICT PARALLEL SAFE
COST 5;

Official release packages

You may find binary package for your platform on the official Releases page. Right now Windows, Linux and macOS packages are available.

Docker

The official docker image can be found here: https://hub.docker.com/r/cybertecpostgresql/pg_timetable

Note

The latest tag is up to date with the master branch thanks to this github action. In production you probably want to use the latest stable tag.

Run pg_timetable in Docker:

docker run --rm \
cybertecpostgresql/pg_timetable:latest \
-h 10.0.0.3 -p 54321 -c worker001

Run pg_timetable in Docker with Environment variables:

docker run --rm \
-e PGTT_PGHOST=10.0.0.3 \
-e PGTT_PGPORT=54321 \
cybertecpostgresql/pg_timetable:latest \
-c worker001

Build from sources

1. Download and install Go on your system.

2. Clone pg_timetable repo:

   $ git clone https://github.com/cybertec-postgresql/pg_timetable.git
   $ cd pg_timetable
   

3. Run pg_timetable:

   $ go run main.go --clientname=worker001 postgresql://scheduler:strongpwd@localhost:5432/dbname
   

4. Alternatively, build a binary and run it:

   $ go build
   $ ./pg_timetable --clientname=worker001 postgresql://scheduler:strongpwd@localhost:5432/dbname
   

5. (Optional) Run tests in all sub-folders of the project:

   $ psql --command="CREATE USER scheduler PASSWORD 'somestrong'"
   $ createdb --owner=scheduler timetable
   $ go test -failfast -timeout=300s -count=1 -p 1 ./...