[Postgres] Migrate the role to distant host

ssh <targetServer>". /usr/postgres/bin/setDB.bash <DBNAME>;export PGPASSWORD=pwd;pg_dumpall --roles-only -h <sourceServer> -p 5432 -U <username>| psql -a"

[Postgres] SET DB ENV

/tech/postgres/dba/jjy setDB.bash
#! /bin/bash
##################################################################
## Program      : setDB.bash                                 #
## Description  : Set environement variables according to        #
##                  database                                     #
##################################################################
#
#
#set -xv

# CONSTANTS
PRGNAME=$(basename $0 2> /dev/null)
if [ $? -ne 0 ]; then
  PRGNAME="Unknown"
fi
PRGPATH=$(dirname $0 2> /dev/null)
if [ "${PRGPATH}x" == "x" ] || [ ! -e "${PRGPATH}" ]; then
  PRGPATH="/tech/postgres/bin"
fi
# INCLUDE
if [ -e ${PRGPATH}/__pg.include ]; then
  . ${PRGPATH}/__pg.include
elif [ -e /tech/postgres/bin/__pg.include ]; then
  . /tech/postgres/bin/__pg.include
fi

# Check environement
if [ $# -ne 1 ]; then
  SID=""
  DBSet
  printf "nUsage: dbset SIDnn"
else
  SID=$1
  DBSet ${SID}
  echo "PGSID     : "${PGSID}" (port ${PGPORT}) STATUS : "${PGSTATUS,,}
  echo "PGVERSION : "${PGVERSION}
  echo "PGHOME    : "${PGHOME}
  echo "PGDATA    : "${PGDATA}
fi