For development purposes, you can also use a VPN or SSH tunnel. If you must make it accessible over a public IP address, we recommend restricting access to a trusted list of source IP addresses using firewall rules.
For security reasons, we do not recommend making the database port accessible over a public IP address. 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. For example, if you are using ufw, you would run the following commands: $ sudo ufw allow postgres/tcp Open port 5432 in your firewall (on Linux only). 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. NOTE: This section assumes that you have downloaded and installed pgAdmin 4. Learn more about the Bitnami stack environment and about OS X VMs. On OS X VMs, the installation directory is /opt/bitnami and OS X VM users can click the “Open Terminal” button to run commands. Before running the commands shown on this page, you should load the Bitnami stack environment by executing the installdir/use_APPNAME script (Linux and MacOS) or by clicking the shortcut in the Start Menu under “Start -> Bitnami APPNAME Stack -> Application console” (Windows).
0 kommentar(er)
