pgAdmin GUI Tool

Giriş

Açıklaması şöyle

An Open Source cross-platform PostgreSQL GUI tool. 

Strengths:

- Compatible with Linux, Windows, macOS.

- Allows for working with multiple servers at a time.

- CSV file export.

- Query planning functionality.

- An ability to monitor your sessions, database locks via the dashboard.

- Shortcuts in the SQL editor for more convenient work.

- A procedural language debugger inside aimed to help in code debugging. 

- Thorough documentation and vibrant community.

Weaknesses:

- Slow and not intuitive UI compared to the paid competitors.

- Too heavy.

- Not easy to onboard.

- You need advanced skills to work with several databases at a time.

Login

Şöyle yaparız

version: '3.8'
services:
  db:
    container_name: pg_container
    image: postgres
    restart: always
    environment:
      POSTGRES_USER: root
      POSTGRES_PASSWORD: root
      POSTGRES_DB: test_db
    ports:
      - "5432:5432"
  pgadmin:
    container_name: pgadmin4_container
    image: dpage/pgadmin4
    restart: always
    environment:
      PGADMIN_DEFAULT_EMAIL: admin@admin.com
      PGADMIN_DEFAULT_PASSWORD: root
    ports:
      - "5050:80"

Açıklaması şöyle

First, access the pgadmin4 via your favorite web browser by visiting the URL http://localhost:5050/. Use the admin@admin.com as the email address and root as the password to log in.

Servers > Create > Server 

Şeklen şöyle. Yeni bir PostgreSQL sunucusu yaratır.

Database Simgesi
Restore Menüsü

Tüm bağlantıların kapalı olması gerekir. Ayrıcate veritabanı drop edilir. Açıklaması şöyle.

Before restoring a database, you need to terminate all connections to that database and prepare the backup file.

Table Simgesi
Import Menüsü
Tablo'ya dosyadan veriyi aktarmayı sağlar.

Restore Menüsü
Önce tablonun truncate edilmesi gerekir.