Semaphore supports 2 versions of PostgreSQL:
The default version is 9.6, and it's running on port of 5432.
Versions can be changed by adding change-pg-version <version> to your setup commands:
This will shut down the currently active version, start version 10, and export PGCLUSTER=10. After this, the whole PostgreSQL toolchain will be switched to version 10, and port 5432 will be served by the newly selected version as well.
Note that adding this command to a script currently isn't supported.
Credentials for using PostgreSQL are available in environment variables listed below:
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.
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.
Semaphore Docs are open source — Edit on GitHub