Monday, July 10, 2017

FTP Client Console Linux Centos

You can use ncftpput. Do the following:
  1. Install ncftp:
    Yum install ncftp
    apt-get install ncftp
  2. Execute the following command:
    ncftpput -R -v -u "ftp-username" ftp-upload-path local-path/*

Saturday, July 8, 2017

Troubleshoot Postgres

##Backup Seluruh Database
$ pg_dumpall > all.backup.out
$ pg_dumpall | gzip -c > all.backup.out.gz

#Import file dump postgres
psql -U postgres -f backup.out zipruz

#Melihat error pada saat proses import
psql -U postgres -f backup.out zipruz -v ON_ERROR_STOP=1

#CWP postgres
yum install postgresql-contrib