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.
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 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.