Date: Wed, 9 Jan 2008 09:54:14 GMT
From: Piotr Szmytka <piotr.szmytka@iem.pw.edu.pl>
To: freebsd-gnats-submit@FreeBSD.org
Subject: ports/119482: date format in ${PORTSDIR}/database/postgresql*-server/files/502.pgsql
Message-ID: <200801090954.m099sEkQ084606@www.freebsd.org>
Resent-Message-ID: <200801091000.m09A080f020650@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>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@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:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200801090954.m099sEkQ084606>