google-templatespostgresql

Understand the default configuration

The default configuration consists of:

  • A database cluster or directory under which all data will be stored. The default data directory in Bitnami is located at /opt/bitnami/postgresql/data.
  • Every connection to the PostgreSQL database server is made using the name of some particular role. A database superuser bypasses all permission checks, except the right to log in. Bitnami configures a default superuser role with a name of postgres. The postgres role has remote access to the database.

Check our recommendations for a production server.

PostgreSQL version

To obtain the PostgreSQL version, execute the following command:

$ postgres --version

PostgreSQL configuration files

The PostgreSQL configuration settings file is located at /opt/bitnami/postgresql/conf/postgresql.conf on the database server host.

The PostgreSQL client authentication configuration file is located at /opt/bitnami/postgresql/data/pg_hba.conf on the database server host.

The PostgreSQL official documentation has more details on how to configure the PostgreSQL database.

PostgreSQL port

The default port in which PostgreSQL listens is 5432.

PostgreSQL log file

The main PostgreSQL log file is created at /opt/bitnami/postgresql/logs/postgresql.log file. You can change the default error reporting and logging configuration settings in the postgresql.conf file.

NOTE: On some platforms, you may need root account privileges to view these files.

Last modification August 30, 2018