| Server IP : 82.148.16.210 / Your IP : 216.73.216.19 Web Server : nginx/1.29.5 System : Linux mail.sarafai.ru 6.1.0-43-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.162-1 (2026-02-08) x86_64 User : root ( 0) PHP Version : 7.4.33 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /usr/share/postgresql-common/ |
Upload File : |
#!/bin/bash
# `pg_dumpall|psql` pipeline called from `pg_upgradecluster -m dump`
set -eu
set -o pipefail # needs dash >= 0.5.12-7
# all these options are mandatory
while getopts "A:h:H:p:P:Q:U:" opt ; do
case $opt in
A) PG_DUMPALL="$OPTARG" ;;
h) OLDHOST="$OPTARG" ;;
H) NEWHOST="$OPTARG" ;;
p) OLDPORT="$OPTARG" ;;
P) NEWPORT="$OPTARG" ;;
Q) PSQL="$OPTARG" ;;
U) NEWUSER="$OPTARG" ;;
*) exit 5 ;;
esac
done
"$PG_DUMPALL" --quote-all-identifiers -h "$OLDHOST" -p "$OLDPORT" |
LC_ALL=C grep --text -v "^CREATE ROLE \"$NEWUSER\";$" | # force text mode; avoid error on existing role
"$PSQL" --no-psqlrc --echo-queries --output /dev/null -vON_ERROR_STOP=on -h "$NEWHOST" -p "$NEWPORT" postgres |
cut -c 1-${COLUMNS:-80} # avoid overly long output (lowrite)