Articles on: Databases

PostgreSQL - Connect Database with pgAdmin

Step-by-step guide to connect to a PostgreSQL database instance using pgAdmin, provided by Galaxy Databases.


Objective


This guide provides detailed instructions on how to connect to a PostgreSQL database instance using pgAdmin, a popular Open Source management tool for PostgreSQL.


Requirements


  • Access to the Galaxy Control Panel.
  • Request a PostgreSQL database from the Galaxy team.
  • pgAdmin installed (stable version) and an internet connection.


Instructions


Installation


Connect with pgAdmin 4

  • Open pgAdmin: Launch pgAdmin on your computer.
  • Create New Connection: Right-click on "Servers" in the left sidebar and select "Register" > "Server".
  • Enter Connection Details: Fill in the connection information provided by the Galaxy team.
  • Establish Connection: Click "Save" to establish a connection to the PostgreSQL instance.




Detailed Steps


  1. Access the Control Panel: Ensure you have access to the Galaxy Control Panel to obtain the credentials and database connection details.
  2. Request the Database: Contact the Galaxy team and request the creation of a PostgreSQL database.
  3. Install pgAdmin: If pgAdmin is not installed, visit the official website and follow the installation instructions for your operating system.
  4. Obtain Connection Credentials: In the Galaxy Control Panel, navigate to "Galaxy Database" and locate the following information for your PostgreSQL database:
    • Host/Server address
    • Port (typically 33028)
    • Database name
    • Username
    • Password
  1. Connect in pgAdmin 4:
    • Open pgAdmin 4.
    • In the left panel, right-click on "Servers".
    • Select "Register" > "Server".
    • In the General tab:
      • Enter a name to identify this connection (e.g., "Galaxy PostgreSQL").
    • In the Connection tab:
      • Host name/address: Paste the server address provided.
      • Port: Enter the port number (default: 33028).
      • Maintenance database: Enter the database name.
      • Username: Enter the username provided.
      • Password: Enter the password provided.
      • (Optional) Check "Save password" to avoid entering the password each time.
    • Click the "Save" button to establish a connection to the database.


Security Considerations


  • Ensure secure handling of PostgreSQL credentials and connection details.
  • Use strong, unique passwords for database access.
  • Regularly review access permissions and audit logs for security purposes.
  • Keep pgAdmin 4 updated to the latest version.


By following these steps, you will be able to efficiently connect to and manage your PostgreSQL database instance using pgAdmin 4, facilitated by Galaxy Databases.

Updated on: 01/10/2025