How To Query Working Backup And Restore On Postgresql

------Backup Database-----

1. pg_dump -U [nameuser] [namedatabase] > [newnamefile]

2. pg_dump [namedatabase] > {LocationPath}/[namedatabase].sql

3. pg_dump -U [nameuser] [namedatabase] --table='[nametable]' > [newnamefile]

------Restore Database-----

1. psql -U [nameuser] [namedatabase] < [namefilebackup]

2. psql -U [namuser] [namedatabase] < [namafilebackup]

------Backup Tabel-----

1. COPY (SELECT * FROM [nametable] WHERE [fieldtable]<=5) TO '/var/lib/pgsql/10/[namefile.sql/csv/pdf/..etc]';

-----Backup Tabel Ke CSV or EXCEL

1. select * into outfile '{LocationPath}/[namefile].csv' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' from [NAMATABEL];

-----Backup Dari Server Pusat Database-----

1. pg_dump -h [IP] -p [PORT] -U [USERNAME] -w -v –table="[NAMATABEL]" --data-only --column-inserts [NAMADATABASE] 1> {LocationPath}/[namedatabase].sql 2> {LocationPath}/[NEWINFORMASIHASILLOG].txt

-----Restore Dari Server Client Database-----

1. psql10 -h [IP] -p [PORT] -U [USERNAME] -w -v -e -d [NAMADATABASE] < {LocationPath}/[namedatabase].sql > {LocationPath}/[NEWINFORMASIHASILLOG].txt