Docs Navigation

PostgreSQL

PostgreSQL is running on the default port of 5432.

Credentials for using PostgreSQL are available in environment variables listed below:

Name Value
DATABASE_POSTGRESQL_USERNAME runner
DATABASE_POSTGRESQL_PASSWORD semaphoredb

If your application doesn't create its own database as part of the start-up process, you can create a PostgreSQL database manually. Adding the following command to your build commands will create a PostgreSQL database:

createdb test_db -U $DATABASE_POSTGRESQL_USERNAME

Note that the createdb command doesn't require password, since PostgreSQL doesn't require password for accessing a database that belongs to the PostgreSQL user that has the same name as host operating system user, by default.

Executing Postgres commands

Add a build command which looks something like:

psql -c "some command" -d $DATABASE_NAME_TEST -P pager

List of all packages and versions is available on the supported application stack page.

Extensions

Semaphore Docs are open source — Edit on GitHub

Newsletter

Occasional lightweight product and blog updates. Unsubscribe at any time.

2009-2017 © Rendered Text. All rights reserved. Terms of Service, Privacy policy, Security.