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 /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.
To obtain the PostgreSQL version, execute the following command:
$ postgres --version
PostgreSQL configuration files
The PostgreSQL configuration files will be located in the following paths:
* PostgreSQL configuration settings file: */opt/bitnami/postgresql/conf/postgresql.conf* * PostgreSQL client authentication configuration file: */opt/bitnami/postgresql/conf/pg_hba.conf*.
The PostgreSQL official documentation has more details on how to configure the PostgreSQL database.
The default port in which PostgreSQL listens is 5432.
PostgreSQL log file
The main PostgreSQL log file is created at /opt/bitnami/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.