sudo apt install postgresql postgresql-contrib \password postgres Accept Remote connections Dumping DB files into remote DB server
psql -h hobes-db.postgres.database.azure.com -p 5432 -d hobes_prod -U hobes_prod@hobes-db -W -f .\dump-joy-202307040234.sql
pg_restore -h localhost -p 5432 -U postgres -d old_db -v
"/usr/local/backup/10.70.0.61.backup"
pg_dump -h ls-fa61d96f688ddd7a7a0902cb819b0b73293ac0c3.cpecr3t51wff.ap-northeast-2.rds.amazonaws.com -U prod_hobes joy > joy_latest_dump.0.1.sql
Accept Remote connections
sudo nano /etc/postgresql/12/main/postgresql.conf
Allow on Table
sudo nano /etc/postgresql/12/main/pg_hba.conf
