24 Ekim 2019 Perşembe

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.

Hiç yorum yok:

Yorum Gönder