From owner-freebsd-ports-bugs@FreeBSD.ORG Wed Jan 9 10:00:08 2008 Return-Path: Delivered-To: freebsd-ports-bugs@hub.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id C0A7F16A469 for ; Wed, 9 Jan 2008 10:00:08 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (freefall.freebsd.org [IPv6:2001:4f8:fff6::28]) by mx1.freebsd.org (Postfix) with ESMTP id 6A05513C4D1 for ; Wed, 9 Jan 2008 10:00:08 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (gnats@localhost [127.0.0.1]) by freefall.freebsd.org (8.14.2/8.14.2) with ESMTP id m09A087E020651 for ; Wed, 9 Jan 2008 10:00:08 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.2/8.14.1/Submit) id m09A080f020650; Wed, 9 Jan 2008 10:00:08 GMT (envelope-from gnats) Resent-Date: Wed, 9 Jan 2008 10:00:08 GMT Resent-Message-Id: <200801091000.m09A080f020650@freefall.freebsd.org> Resent-From: FreeBSD-gnats-submit@FreeBSD.org (GNATS Filer) Resent-To: freebsd-ports-bugs@FreeBSD.org Resent-Reply-To: FreeBSD-gnats-submit@FreeBSD.org, Piotr Szmytka Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 5505116A47F for ; Wed, 9 Jan 2008 09:55:19 +0000 (UTC) (envelope-from nobody@FreeBSD.org) Received: from www.freebsd.org (www.freebsd.org [IPv6:2001:4f8:fff6::21]) by mx1.freebsd.org (Postfix) with ESMTP id 3FDD113C448 for ; Wed, 9 Jan 2008 09:55:19 +0000 (UTC) (envelope-from nobody@FreeBSD.org) Received: from www.freebsd.org (localhost [127.0.0.1]) by www.freebsd.org (8.14.2/8.14.2) with ESMTP id m099sElj084607 for ; Wed, 9 Jan 2008 09:54:14 GMT (envelope-from nobody@www.freebsd.org) Received: (from nobody@localhost) by www.freebsd.org (8.14.2/8.14.1/Submit) id m099sEkQ084606; Wed, 9 Jan 2008 09:54:14 GMT (envelope-from nobody) Message-Id: <200801090954.m099sEkQ084606@www.freebsd.org> Date: Wed, 9 Jan 2008 09:54:14 GMT From: Piotr Szmytka To: freebsd-gnats-submit@FreeBSD.org X-Send-Pr-Version: www-3.1 Cc: Subject: ports/119482: date format in ${PORTSDIR}/database/postgresql*-server/files/502.pgsql X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 09 Jan 2008 10:00:08 -0000 >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: