Command สำหรับ Backup ฐานข้อมูล
รูปแบบคำสั่ง
pg_dump -h [hostname] -P [port_number] -U [username] [databasename] > [backup_file].dump
ตัวอย่างบน linux
Code: Select all
pg_dump -h localhost -U username databasename > databasename.dump
Code: Select all
//path to/PostgreSQL/bin\pg_dump.exe --host localhost --port 5432 --username "openpg" --no-password --verbose --file "C:\\path to backup folder\db_name.backup" "db_name"