Understand the default configuration
The default configuration consists of:
A database cluster or directory under which all data will be stored. Depending on your installation type, the default data directory in Bitnami is located at the following paths:
- Approach A (Bitnami installations using system packages): /bitnami/postgresql/data.
- Approach B (Self-contained Bitnami installations): installdir/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.
To obtain the PostgreSQL version, execute the following command:
$ postgres --version
PostgreSQL configuration files
Depending on your installation type, the PostgreSQL configuration files will be located in the following paths:
Approach A (Bitnami installations using system packages):
- PostgreSQL configuration settings file: installdir/postgresql/conf/pg_hba.conf
- PostgreSQL client authentication configuration file: installdir/postgresql/conf/pg_hba.conf.
Approach B (Self-contained Bitnami installations):
- PostgreSQL configuration settings file: installdir/postgresql/data/pg_hba.conf
- PostgreSQL client authentication configuration file: installdir/postgresql/data/pg_hba.conf.
The default port in which PostgreSQL listens is 5432.
PostgreSQL log file
The main PostgreSQL log file is created at installdir/postgresql/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.