Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 6 Nov 2002 02:10:04 +0100 (CET)
From:      Palle Girgensohn <girgen@pingpong.net>
To:        FreeBSD-gnats-submit@FreeBSD.org
Cc:        Nick Sayer <nsayer@FreeBSD.org>
Subject:   ports/44983: postgresql periodic file update
Message-ID:  <200211060110.gA61A4Of084508@palle.girgensohn.se>

next in thread | raw e-mail | index | archive | help

>Number:         44983
>Category:       ports
>Synopsis:       postgresql periodic file update
>Confidential:   no
>Severity:       non-critical
>Priority:       medium
>Responsible:    freebsd-ports
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          maintainer-update
>Submitter-Id:   current-users
>Arrival-Date:   Tue Nov 05 17:20:01 PST 2002
>Closed-Date:
>Last-Modified:
>Originator:     Palle Girgensohn <girgen@pingpong.net>
>Release:        FreeBSD 4.7-RELEASE i386
>Organization:
PING PONG
>Environment:
System: FreeBSD palle.girgensohn.se 4.7-RC FreeBSD 4.7-RC #0: Sun Sep 29 17:21:22 CEST 2002     root@palle.girgensohn.se:/usr/local/obj/usr/src/sys/STORDATAN  i386


	
>Description:
- Thanks to Nick Sayer for pointing out that a pg_dumpall -g is needed
  to backup users information.

- pg_dump does not use the `-d dbname' syntax...

	
>How-To-Repeat:
	
>Fix:

	


Index: 502.pgsql
===================================================================
RCS file: /home/ncvs/ports/databases/postgresql7/files/502.pgsql,v
retrieving revision 1.3
diff -u -r1.3 502.pgsql
--- 502.pgsql	26 Aug 2002 08:12:40 -0000	1.3
+++ 502.pgsql	6 Nov 2002 00:44:34 -0000
@@ -53,10 +53,12 @@
 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
 
>Release-Note:
>Audit-Trail:
>Unformatted:

To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-ports" in the body of the message




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200211060110.gA61A4Of084508>