Articles on: Databases

PostgreSQL - Database Management Overview

This document provides an overview of managing a PostgreSQL database instance in Galaxy Databases, including details on database type, plan information, access credentials, and usage instructions.


Overview


After creating a PostgreSQL database, users will have access to a comprehensive interface providing all necessary information to manage and access their database. The interface is structured into several main sections, including database type, plan details, access credentials, and additional configuration and support options.


To access details of the created database, click open.


User Interface


Sidebar Menu


In the sidebar menu (located on the left), users will find the following options:


  • Databases: Options related to databases.



  • Overview: Details of the selected database.


Main Section


In the main section of the interface, the following information is presented:



Database Details


  • Database Name: postgresql
  • Type: Standalone
  • Region: your region


Plan Information


  • Plan: Standard
  • Database: PostgreSQL version 17.4


Resources:


  • RAM: 2 GB
  • CPUs: 2
  • Storage: 15 GB
  • Status: Running


Credentials


The credentials section provides necessary information to access the database:


  • Username: postgres
  • Password: password
  • Connection String:

postgres://username:<password>@yourhost-postgresql.galaxy-cloud.io:33028/postgres


Usage Instructions


Accessing the Database


  1. Use the provided credentials:
  • Copy the username and password.
  • Use the provided connection string to connect to the database.


  1. If you need the host name/address, you can find it within your connection string. Let's break it down:

Connection string format: postgres://username:password@hostname:port/databasename


Managing the Database


  • Monitor Status: Regularly check the service status to ensure the database is operating as expected.
  • Request Support: Use the support option in the sidebar menu to resolve any issues or questions that may arise.


Updated on: 02/10/2025