diff options
author | nsayer <nsayer@FreeBSD.org> | 2002-11-06 09:41:53 +0800 |
---|---|---|
committer | nsayer <nsayer@FreeBSD.org> | 2002-11-06 09:41:53 +0800 |
commit | 0ffa29422df434a4e1d539a9c45ad8434cbcf70b (patch) | |
tree | 8569b6dd2b7d30ee7159d0dae80d83e405312c7c /databases | |
parent | 7491c351f1b117b3fc48a83aeec8779122ed9de3 (diff) | |
download | freebsd-ports-gnome-0ffa29422df434a4e1d539a9c45ad8434cbcf70b.tar.gz freebsd-ports-gnome-0ffa29422df434a4e1d539a9c45ad8434cbcf70b.tar.zst freebsd-ports-gnome-0ffa29422df434a4e1d539a9c45ad8434cbcf70b.zip |
Port update submitted by maintainer
PR: ports/44983
Submitted by: girgen@pingpong.net
Diffstat (limited to 'databases')
-rw-r--r-- | databases/postgresql-devel-server/files/502.pgsql | 4 | ||||
-rw-r--r-- | databases/postgresql7/files/502.pgsql | 4 | ||||
-rw-r--r-- | databases/postgresql73-server/files/502.pgsql | 4 | ||||
-rw-r--r-- | databases/postgresql73/files/502.pgsql | 4 | ||||
-rw-r--r-- | databases/postgresql74-server/files/502.pgsql | 4 | ||||
-rw-r--r-- | databases/postgresql80-server/files/502.pgsql | 4 | ||||
-rw-r--r-- | databases/postgresql81-server/files/502.pgsql | 4 | ||||
-rw-r--r-- | databases/postgresql82-server/files/502.pgsql | 4 | ||||
-rw-r--r-- | databases/postgresql83-server/files/502.pgsql | 4 | ||||
-rw-r--r-- | databases/postgresql84-server/files/502.pgsql | 4 | ||||
-rw-r--r-- | databases/postgresql90-server/files/502.pgsql | 4 | ||||
-rw-r--r-- | databases/postgresql91-server/files/502.pgsql | 4 | ||||
-rw-r--r-- | databases/postgresql92-server/files/502.pgsql | 4 |
13 files changed, 39 insertions, 13 deletions
diff --git a/databases/postgresql-devel-server/files/502.pgsql b/databases/postgresql-devel-server/files/502.pgsql index 3a44f1132ac8..c372163f7407 100644 --- a/databases/postgresql-devel-server/files/502.pgsql +++ b/databases/postgresql-devel-server/files/502.pgsql @@ -53,10 +53,12 @@ echo "PostgreSQL maintenance" umask 077 dbnames=`psql -q -t -A -d template1 -c "SELECT datname FROM pg_database WHERE datname != 'template0'"` rc=$? +file=${PGBACKUPDIR}/pgglobals_`date "+%Y%m%d"` +pg_dumpall -g | gzip -9 > ${file}.gz for db in ${dbnames}; do echo -n " $db" file=${PGBACKUPDIR}/pgdump_${db}_`date "+%Y%m%d"` - pg_dump ${PGDUMP_ARGS} -d $db -f ${file} + pg_dump ${PGDUMP_ARGS} -f ${file} ${db} [ $? -gt 0 ] && rc=3 done diff --git a/databases/postgresql7/files/502.pgsql b/databases/postgresql7/files/502.pgsql index 3a44f1132ac8..c372163f7407 100644 --- a/databases/postgresql7/files/502.pgsql +++ b/databases/postgresql7/files/502.pgsql @@ -53,10 +53,12 @@ echo "PostgreSQL maintenance" umask 077 dbnames=`psql -q -t -A -d template1 -c "SELECT datname FROM pg_database WHERE datname != 'template0'"` rc=$? +file=${PGBACKUPDIR}/pgglobals_`date "+%Y%m%d"` +pg_dumpall -g | gzip -9 > ${file}.gz for db in ${dbnames}; do echo -n " $db" file=${PGBACKUPDIR}/pgdump_${db}_`date "+%Y%m%d"` - pg_dump ${PGDUMP_ARGS} -d $db -f ${file} + pg_dump ${PGDUMP_ARGS} -f ${file} ${db} [ $? -gt 0 ] && rc=3 done diff --git a/databases/postgresql73-server/files/502.pgsql b/databases/postgresql73-server/files/502.pgsql index 3a44f1132ac8..c372163f7407 100644 --- a/databases/postgresql73-server/files/502.pgsql +++ b/databases/postgresql73-server/files/502.pgsql @@ -53,10 +53,12 @@ echo "PostgreSQL maintenance" umask 077 dbnames=`psql -q -t -A -d template1 -c "SELECT datname FROM pg_database WHERE datname != 'template0'"` rc=$? +file=${PGBACKUPDIR}/pgglobals_`date "+%Y%m%d"` +pg_dumpall -g | gzip -9 > ${file}.gz for db in ${dbnames}; do echo -n " $db" file=${PGBACKUPDIR}/pgdump_${db}_`date "+%Y%m%d"` - pg_dump ${PGDUMP_ARGS} -d $db -f ${file} + pg_dump ${PGDUMP_ARGS} -f ${file} ${db} [ $? -gt 0 ] && rc=3 done diff --git a/databases/postgresql73/files/502.pgsql b/databases/postgresql73/files/502.pgsql index 3a44f1132ac8..c372163f7407 100644 --- a/databases/postgresql73/files/502.pgsql +++ b/databases/postgresql73/files/502.pgsql @@ -53,10 +53,12 @@ echo "PostgreSQL maintenance" umask 077 dbnames=`psql -q -t -A -d template1 -c "SELECT datname FROM pg_database WHERE datname != 'template0'"` rc=$? +file=${PGBACKUPDIR}/pgglobals_`date "+%Y%m%d"` +pg_dumpall -g | gzip -9 > ${file}.gz for db in ${dbnames}; do echo -n " $db" file=${PGBACKUPDIR}/pgdump_${db}_`date "+%Y%m%d"` - pg_dump ${PGDUMP_ARGS} -d $db -f ${file} + pg_dump ${PGDUMP_ARGS} -f ${file} ${db} [ $? -gt 0 ] && rc=3 done diff --git a/databases/postgresql74-server/files/502.pgsql b/databases/postgresql74-server/files/502.pgsql index 3a44f1132ac8..c372163f7407 100644 --- a/databases/postgresql74-server/files/502.pgsql +++ b/databases/postgresql74-server/files/502.pgsql @@ -53,10 +53,12 @@ echo "PostgreSQL maintenance" umask 077 dbnames=`psql -q -t -A -d template1 -c "SELECT datname FROM pg_database WHERE datname != 'template0'"` rc=$? +file=${PGBACKUPDIR}/pgglobals_`date "+%Y%m%d"` +pg_dumpall -g | gzip -9 > ${file}.gz for db in ${dbnames}; do echo -n " $db" file=${PGBACKUPDIR}/pgdump_${db}_`date "+%Y%m%d"` - pg_dump ${PGDUMP_ARGS} -d $db -f ${file} + pg_dump ${PGDUMP_ARGS} -f ${file} ${db} [ $? -gt 0 ] && rc=3 done diff --git a/databases/postgresql80-server/files/502.pgsql b/databases/postgresql80-server/files/502.pgsql index 3a44f1132ac8..c372163f7407 100644 --- a/databases/postgresql80-server/files/502.pgsql +++ b/databases/postgresql80-server/files/502.pgsql @@ -53,10 +53,12 @@ echo "PostgreSQL maintenance" umask 077 dbnames=`psql -q -t -A -d template1 -c "SELECT datname FROM pg_database WHERE datname != 'template0'"` rc=$? +file=${PGBACKUPDIR}/pgglobals_`date "+%Y%m%d"` +pg_dumpall -g | gzip -9 > ${file}.gz for db in ${dbnames}; do echo -n " $db" file=${PGBACKUPDIR}/pgdump_${db}_`date "+%Y%m%d"` - pg_dump ${PGDUMP_ARGS} -d $db -f ${file} + pg_dump ${PGDUMP_ARGS} -f ${file} ${db} [ $? -gt 0 ] && rc=3 done diff --git a/databases/postgresql81-server/files/502.pgsql b/databases/postgresql81-server/files/502.pgsql index 3a44f1132ac8..c372163f7407 100644 --- a/databases/postgresql81-server/files/502.pgsql +++ b/databases/postgresql81-server/files/502.pgsql @@ -53,10 +53,12 @@ echo "PostgreSQL maintenance" umask 077 dbnames=`psql -q -t -A -d template1 -c "SELECT datname FROM pg_database WHERE datname != 'template0'"` rc=$? +file=${PGBACKUPDIR}/pgglobals_`date "+%Y%m%d"` +pg_dumpall -g | gzip -9 > ${file}.gz for db in ${dbnames}; do echo -n " $db" file=${PGBACKUPDIR}/pgdump_${db}_`date "+%Y%m%d"` - pg_dump ${PGDUMP_ARGS} -d $db -f ${file} + pg_dump ${PGDUMP_ARGS} -f ${file} ${db} [ $? -gt 0 ] && rc=3 done diff --git a/databases/postgresql82-server/files/502.pgsql b/databases/postgresql82-server/files/502.pgsql index 3a44f1132ac8..c372163f7407 100644 --- a/databases/postgresql82-server/files/502.pgsql +++ b/databases/postgresql82-server/files/502.pgsql @@ -53,10 +53,12 @@ echo "PostgreSQL maintenance" umask 077 dbnames=`psql -q -t -A -d template1 -c "SELECT datname FROM pg_database WHERE datname != 'template0'"` rc=$? +file=${PGBACKUPDIR}/pgglobals_`date "+%Y%m%d"` +pg_dumpall -g | gzip -9 > ${file}.gz for db in ${dbnames}; do echo -n " $db" file=${PGBACKUPDIR}/pgdump_${db}_`date "+%Y%m%d"` - pg_dump ${PGDUMP_ARGS} -d $db -f ${file} + pg_dump ${PGDUMP_ARGS} -f ${file} ${db} [ $? -gt 0 ] && rc=3 done diff --git a/databases/postgresql83-server/files/502.pgsql b/databases/postgresql83-server/files/502.pgsql index 3a44f1132ac8..c372163f7407 100644 --- a/databases/postgresql83-server/files/502.pgsql +++ b/databases/postgresql83-server/files/502.pgsql @@ -53,10 +53,12 @@ echo "PostgreSQL maintenance" umask 077 dbnames=`psql -q -t -A -d template1 -c "SELECT datname FROM pg_database WHERE datname != 'template0'"` rc=$? +file=${PGBACKUPDIR}/pgglobals_`date "+%Y%m%d"` +pg_dumpall -g | gzip -9 > ${file}.gz for db in ${dbnames}; do echo -n " $db" file=${PGBACKUPDIR}/pgdump_${db}_`date "+%Y%m%d"` - pg_dump ${PGDUMP_ARGS} -d $db -f ${file} + pg_dump ${PGDUMP_ARGS} -f ${file} ${db} [ $? -gt 0 ] && rc=3 done diff --git a/databases/postgresql84-server/files/502.pgsql b/databases/postgresql84-server/files/502.pgsql index 3a44f1132ac8..c372163f7407 100644 --- a/databases/postgresql84-server/files/502.pgsql +++ b/databases/postgresql84-server/files/502.pgsql @@ -53,10 +53,12 @@ echo "PostgreSQL maintenance" umask 077 dbnames=`psql -q -t -A -d template1 -c "SELECT datname FROM pg_database WHERE datname != 'template0'"` rc=$? +file=${PGBACKUPDIR}/pgglobals_`date "+%Y%m%d"` +pg_dumpall -g | gzip -9 > ${file}.gz for db in ${dbnames}; do echo -n " $db" file=${PGBACKUPDIR}/pgdump_${db}_`date "+%Y%m%d"` - pg_dump ${PGDUMP_ARGS} -d $db -f ${file} + pg_dump ${PGDUMP_ARGS} -f ${file} ${db} [ $? -gt 0 ] && rc=3 done diff --git a/databases/postgresql90-server/files/502.pgsql b/databases/postgresql90-server/files/502.pgsql index 3a44f1132ac8..c372163f7407 100644 --- a/databases/postgresql90-server/files/502.pgsql +++ b/databases/postgresql90-server/files/502.pgsql @@ -53,10 +53,12 @@ echo "PostgreSQL maintenance" umask 077 dbnames=`psql -q -t -A -d template1 -c "SELECT datname FROM pg_database WHERE datname != 'template0'"` rc=$? +file=${PGBACKUPDIR}/pgglobals_`date "+%Y%m%d"` +pg_dumpall -g | gzip -9 > ${file}.gz for db in ${dbnames}; do echo -n " $db" file=${PGBACKUPDIR}/pgdump_${db}_`date "+%Y%m%d"` - pg_dump ${PGDUMP_ARGS} -d $db -f ${file} + pg_dump ${PGDUMP_ARGS} -f ${file} ${db} [ $? -gt 0 ] && rc=3 done diff --git a/databases/postgresql91-server/files/502.pgsql b/databases/postgresql91-server/files/502.pgsql index 3a44f1132ac8..c372163f7407 100644 --- a/databases/postgresql91-server/files/502.pgsql +++ b/databases/postgresql91-server/files/502.pgsql @@ -53,10 +53,12 @@ echo "PostgreSQL maintenance" umask 077 dbnames=`psql -q -t -A -d template1 -c "SELECT datname FROM pg_database WHERE datname != 'template0'"` rc=$? +file=${PGBACKUPDIR}/pgglobals_`date "+%Y%m%d"` +pg_dumpall -g | gzip -9 > ${file}.gz for db in ${dbnames}; do echo -n " $db" file=${PGBACKUPDIR}/pgdump_${db}_`date "+%Y%m%d"` - pg_dump ${PGDUMP_ARGS} -d $db -f ${file} + pg_dump ${PGDUMP_ARGS} -f ${file} ${db} [ $? -gt 0 ] && rc=3 done diff --git a/databases/postgresql92-server/files/502.pgsql b/databases/postgresql92-server/files/502.pgsql index 3a44f1132ac8..c372163f7407 100644 --- a/databases/postgresql92-server/files/502.pgsql +++ b/databases/postgresql92-server/files/502.pgsql @@ -53,10 +53,12 @@ echo "PostgreSQL maintenance" umask 077 dbnames=`psql -q -t -A -d template1 -c "SELECT datname FROM pg_database WHERE datname != 'template0'"` rc=$? +file=${PGBACKUPDIR}/pgglobals_`date "+%Y%m%d"` +pg_dumpall -g | gzip -9 > ${file}.gz for db in ${dbnames}; do echo -n " $db" file=${PGBACKUPDIR}/pgdump_${db}_`date "+%Y%m%d"` - pg_dump ${PGDUMP_ARGS} -d $db -f ${file} + pg_dump ${PGDUMP_ARGS} -f ${file} ${db} [ $? -gt 0 ] && rc=3 done |