PostgreSQL is running on the default port of 5432.
Credentials for using PostgreSQL are available in environment variables listed below:
If your application doesn’t create it’s 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.