##不重启数据库,更新配置
/usr/local/pgsql/bin/pg_ctl reload -D /home/postgres/data
远程备份:
/usr/local/pgsql/bin/pg_dump dbname -f db_backup -h 192.168.1.2 -U username
远程还原:
/usr/local/pgsql/bin/psql -h 192.168.1.2 -U username -d dbname < db_backup
连接数据库
/usr/local/pgsql/bin/psql -h 192.168.1.2 -U username -d dbname