791 B
791 B
Postgres-gtfs-rest-api Setup
Table of Contents
Preparation
- check out git repository as descirbted in the Quick Start Guide
- download GTFS static file in question
- make use of this repository to load GTFS data into Postgres database
- set up ssh tunnel\
ssh -L <local port>:localhost:5432 <user>@<postgrs host>
- create schema\
~/git/gtfs2psqlschema/gtfs_schema.sh . > <schema name>.sql
- load feed into database\
psql --host=localhost --port=5442 --username=<usr> --dbname=<db> --file=<schema name> --password