[corat-coret] setup postgresql backup server

  • 0
apt-get install postgresql postgresql-client apache2 php5 php5-postgresql
su postgres
psql

create user [local_user] with password '[local_userpassw]';
create database [local_dbname] owner [local_user];

pg_dump -co -h [remote_address] -U [remote_user] [remote_dbname] | psql -h localhost -U [local_user] [local_dbname]

Tidak ada komentar :

Posting Komentar