# 在客户端服务器的用户家目录下,创建一个.pgpass文件,并将权限设置为600,就可以实现了
# .pgpass文件格式如下,每行一个
hostname:port:database:username:password
# shell执行命令
psql -h 地址 -p 端口 -U 用户 -c "CREATE DATABASE test"
alias gp_rd='psql -h x.x.x.x -p 5432 -d gp_pay -U gp_rd
#!/bin/bash
. ~/.bashrc
export LANG="zh_CN.UTF-8"
export LC_ALL="zh_CN.UTF-8"
basepath=$(cd `dirname $0`; pwd)
cd ${basepath}
LOAD_SQL="truncate table open.t_monthly_org_test;insert into open.t_monthly_org_test select * from open.t_monthly_org;"
tempfile="${basepath}/temp.log"
export PGPASSWORD=***
/usr/bin/psql -h *.*.*.* -p 5432 -d * -U * -c "$LOAD_SQL" > ${tempfile} 2>&1
if [ $? -eq 0 ]
then
logmsg=`cat ${tempfile}`
echo "SUCCESS ${logmsg}"
else
logmsg=`cat ${tempfile}`
echo "FATAL ${logmsg}"
fi