psql --help 命令可查看数据库连接帮助文档。
pg_dump 命令可查看导数帮助文档。
dyb为库名,username为数据库用户
方法一,需要手动输入密码:
psql -U username -h 196.128.0.19 -p 5432 -d dyb
enter passwd for username: (这里输入密码)
pg_dump -U username -h 196.128.0.19 -p 5432 -f /data/backup/dyb${day_id}.sql dyb
enter passwd for username: (这里输入密码)
方法二,不需要手动输入密码:
psql "host =196.128.0.19 port =5432 user =username password =password dbname =dyb "
pg_dump "host =196.128.0.19 port =5432 user =username password =password dbname =dyb " -f /data/backup/dyb${day_id}.sql