As a result, you will only be able to connect to your database nodes from machines that are running in the same network. IMPORTANT: By default, the database port for the nodes in this solution cannot be accessed over a public IP address. Open port 5432 in the server firewall ( instructions). Make sure that you have your cloud server’s IP address and application credentials ( instructions). PostgreSQL client authentication configuration file: /opt/bitnami/postgresql/data/pg_hba.conf.
![pgadmin 4 put result window into panel at bottom pgadmin 4 put result window into panel at bottom](https://georgik.rocks/wp-content/uploads/pgadmin4-dpi-awareness-0.jpg)
PostgreSQL configuration settings file: /opt/bitnami/postgresql/data/nf.PostgreSQL client authentication configuration file: /opt/bitnami/postgresql/conf/pg_hba.confĪpproach B (Self-contained Bitnami installations):.PostgreSQL configuration settings file: /opt/bitnami/postgresql/conf/nf.Depending on your installation type, these files will be located in the following paths:Īpproach A (Bitnami installations using system packages): NOTE: In the steps below, you will be modifying a couple of PostgreSQL configuration files. To connect to your remote PostgreSQL database server using pgAdmin 4, follow these steps: Check the pgAdmin official page for more information. PgAdmin is the most popular and feature-rich platform for administration and development of PostgreSQL databases.
![pgadmin 4 put result window into panel at bottom pgadmin 4 put result window into panel at bottom](https://blog.eldernode.com/wp-content/uploads/2021/04/Install-pgAdmin-4-on-CentOS-7-PostgreSQL-Instance-Details-1-1024x646.jpg)
NOTE: This section assumes that you have downloaded and installed pgAdmin 4. Refer to the FAQ for more information on these changes. The output of the command indicates which approach (A or B) is used by the installation, and will allow you to identify the paths, configuration and commands to use in this guide. To identify your Bitnami installation type and what approach to follow, run the command below: $ test ! -f "/opt/bitnami/common/bin/openssl" & echo "Approach A: Using system packages." || echo "Approach B: Self-contained installation." On account of these changes, the file paths stated in this guide may change depending on whether your Bitnami stack uses native Linux system packages (Approach A), or if it is a self-contained installation (Approach B). NOTE: We are in the process of modifying the file structure and configuration for many Bitnami stacks.