Search

How to Use Container Station to Establish a Managed PostgreSQL Container

Last modified date: 2020-12-28

Introduction

This tutorial explains how to use Container Station to establish a PostgreSQL database and manage it with phpPgAdmin.

Note:

Since our recommended phpPgAdmin is only supported by amd64 architecture, this tutorial will only focus on the x86-based devices.

Installing Container Station

  1. Log in to QTS.
  2. Open App Center.
  3. Search for Container Station.
  4. Click Install.

App Center installs Container Station.

Importing a PostgreSQL and phpPgAdmin YAML File

  1. Open Container Station.
  2. Click Create.
  3. Click Create Application.
  4. Select PostgreSQL in Sample.
    Note:

    Supported by x86-based devices only.

  5. Specify an application name.
  6. Optional: Modify the YAML code.

    Entry Row

    Value

    Description

    Example

    Row 5

    		 
    postgres: 11.6

    The tags for the PostgresSQL database

    Tip:

    For a list of supported tags, go here.

    		 11.6

    Row 8

    		 
    127.0.0.1:5432:5432

    The published port for the PostgreSQL database

    		 5432
    Note:

    When using the database internally, add the prefix 127.0.0.1 (e.g., 127.0.0.1:5432).

    Row 10

    		 
    /share/Container/postgresdb:/var/lib/postgresql/data

    The path to the host folder storing the PostgreSQL data, which uses the following format:

    /share/{SHARED_FOLDER_NAME}
    		 /share/Container/postgresdb

    Row 12

    		 
    POSTGRES_USER={USER NAME}

    The account name for the superuser and the name of the database

    Tip:

    For security reasons, QNAP recommends defining a new username.

    -

    Row 13

    		 
    POSTGRES_PASSWORD={ PASSWORD}

    The superuser password for PostgreSQL

    Tip:

    For security reasons, QNAP recommends defining a new password.

    -

    Row 16

    		 
    edhongcy/phppgadmin:latest

    The docker image and tag for phpPgAdmin

    		 edhongcy/phppgadmin:latest

    Row 19

    		 
    7070:80

    The published port for HTTP web service

    		 7070

    Row 20

    		 
    7443:443

    The published port for HTTPS web service

    		 7443
  7. Click Validate YAML.
  8. Click Create.

Container Station creates the container.

Accessing phpPgAdmin With Container Station

  1. Open Container Station.
  2. Click Containers.
  3. Identify the PostgreSQL app.
  4. Click to expand the details.
  5. Identify the phpPgAdmin container.
  6. Click .

The phpPgAdmin page opens.

Was this article helpful?

Yes. No.
42% of people think it helps.
Thank you for your feedback.

Please tell us how this article can be improved:

If you want to provide additional feedback, please include it below.

Choose specification

      Show more Less

      Choose Your Country or Region

      open menu
      back to top