ports/119482: date format in ${PORTSDIR}/database/postgresql*-server/files/502.pgsql

[Piotr Szmytka]

>Number:         119482
>Category:       ports
>Synopsis:       date format in ${PORTSDIR}/database/postgresql*-server/files/502.pgsql
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          change-request
>Submitter-Id:   current-users
>Arrival-Date:   Wed Jan 09 10:00:08 UTC 2008
>Closed-Date:
>Last-Modified:
>Originator:     Piotr Szmytka
>Release:        6.2-RELEASE
>Organization:
PW
>Environment:
FreeBSD worker2 6.2-RELEASE FreeBSD 6.2-RELEASE #0: Fri Jan 12 10:40:27 UTC 2007     root at dessler.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC  i386
>Description:
The date format of file names for backups looks odd.
Here is line 62 of /database/postgresql*-server/files/502.pgsql:
    now=`date "+%Y-%m-%dT%H:%M:%S"
which gives something like:
'2008-01-09T10:54:51'
>How-To-Repeat:

>Fix:
I suggest:
    now=`date "+%Y-%m-%d-%T"

Patch attached with submission follows:

--- 502.pgsql   Wed Jan  9 10:47:17 2008
+++ 502.pgsql.mine      Wed Jan  9 10:46:57 2008
@@ -58,7 +58,7 @@
        umask 077
        dbnames=`su -l pgsql -c "psql -q -t -A -d template1 -c SELECT\ datname\ FROM\ pg_database\ WHERE\ datname!=\'template0\'"`
        rc=$?
-       now=`date "+%Y-%m-%d-%T"`
+       now=`date "+%Y-%m-%dT%H:%M:%S"`
        file=${daily_pgsql_backupdir}/pgglobals_${now}
        su -l pgsql -c "pg_dumpall -g | gzip -9 > ${file}.gz"
        for db in ${dbnames}; do



>Release-Note:
>Audit-Trail:
>Unformatted: