allow connection client remote postgresql on remote
danang setya pramanaedit pg_hba.conf and add host all all 192.168.1.0/24 scram-sha-256 after that enter on…
Backup & Restore Postgre SQL Database
pg_dump and pg_restore are command-line utilities for backing up and restoring PostgreSQL databases. The tar format is one of the non-plain text archive formats that pg_dump can produce and which pg_restore is designed to handle. Backing Up with pg_dump (TAR format) …
strict change column type table postgre from string to int
ALTER TABLE table_name ALTER COLUMN column_name TYPE BIGINT USING (column_name::bigint);
migrate database from mysql to postgre using docker pg_loader
karena saya menggunakan jendela saat ini , terpaksa saya menggunakan pg_loader dari docker , pertama ambil packagenya dulu dari remote milik dimitri docker pull ghcr.io/dimitri/pgloader:latest pertama pastikan kalian punya akses…