Command for postgres

login ke postgresql dengan user postgres:
sudo su – postgres

tampilkan list database:
psql -U postgres -l

backup database:
pg_dump nama_databse > file_backup

get file backup from server:
sftp user@server
sftp> get nama_file
sftp> exit

Advertisements

About this entry