Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1sJxib-007b6d-Bk
	for pgsql-general@arkaria.postgresql.org; Wed, 19 Jun 2024 15:59:29 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1sJxiY-001hSf-Nw
	for pgsql-general@arkaria.postgresql.org; Wed, 19 Jun 2024 15:59:27 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <adrian.klaver@aklaver.com>)
	id 1sJxiX-001hSX-Sa
	for pgsql-general@lists.postgresql.org; Wed, 19 Jun 2024 15:59:27 +0000
Received: from wfout7-smtp.messagingengine.com ([64.147.123.150])
	by makus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <adrian.klaver@aklaver.com>)
	id 1sJxiV-0026JG-RW
	for pgsql-general@lists.postgresql.org; Wed, 19 Jun 2024 15:59:25 +0000
Received: from compute4.internal (compute4.nyi.internal [10.202.2.44])
	by mailfout.west.internal (Postfix) with ESMTP id E9AAE1C000A3;
	Wed, 19 Jun 2024 11:59:20 -0400 (EDT)
Received: from mailfrontend2 ([10.202.2.163])
  by compute4.internal (MEProxy); Wed, 19 Jun 2024 11:59:21 -0400
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h=
	cc:content-transfer-encoding:content-type:content-type:date:date
	:from:from:in-reply-to:in-reply-to:message-id:mime-version
	:references:reply-to:subject:subject:to:to; s=fm1; t=1718812760;
	 x=1718899160; bh=9o35qwRkBFm914cciz+z2lktknrE2sx0uJFMH/WQZRI=; b=
	FPHierjGciz2ojT8OTFpcTU57nqynePPE7O0xv4i8jT3K7hj9aP+vAaZsA3VbtGP
	rgnibBEJxfA0GqrUn2lMsBPYvo2wtcAKbWJQAsjx/RSgdLdowFXLOdGVs23k4I+6
	ZrLL59Cnln0SEvb5CWMrWrSw+LqwYuqyMtzHheMhYj57FlsbgyqqofwEhIutO2sb
	cixbSH5qqgKDFhCGRxLoLVsKrsrKMGc60VRndzZRBkFTzOPJvoS72R5kJLRt++Ey
	KVVGCdaTyqwVLwcdoeJPGQwh1C2nI3McPodQE4QY7ihiMvPScw7xBkRt6mQTPyuL
	M+GzZNr0a8bf3ThLk1neJw==
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=
	messagingengine.com; h=cc:content-transfer-encoding:content-type
	:content-type:date:date:feedback-id:feedback-id:from:from
	:in-reply-to:in-reply-to:message-id:mime-version:references
	:reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy
	:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t=1718812760; x=
	1718899160; bh=9o35qwRkBFm914cciz+z2lktknrE2sx0uJFMH/WQZRI=; b=I
	rWA8UOfOrEHN7yg1VSaGztF1Ud3RsrBDudnrXBjCd5fFFaUM+0iwupDr7wF5eTlw
	bUu8l/lPpAL2SQswcA1cF69p+hOMwsPYBt5z5y7ycW7HEQ0OJLX/ceNyHXX2Wt8s
	j+FTWMBQPCGXl5pbUbNaoimAbauDHz02mMbhHBYpQqjCrDZIvKYo1OtDqplSAd4r
	sFlFtAY+V4q+y6+UY/nlkNvDtZTkK2rHpGeqMHK4BTNSQuO4suk9T8MI3Gk2pc3T
	mdLD1UJY2BzYHYe1XDPDxeJ4gFtIcb3VwrpEqM77+PLPfH+00MLEIO4D5y7EmzLH
	fcnhnzJ+7fKBBJyomgcog==
X-ME-Sender: <xms:WABzZkXVGAaAb0O4TkyVxtLLpPK9Lardfyejl8ipnd3PvpS00EGsng>
    <xme:WABzZonowKH8fsOTiZCxtMdRi-h7xRwFrPnyAj8c44lXeAbhu10HNqjqomanrCbaS
    1AYQWkTqzFgyv0>
X-ME-Received: <xmr:WABzZoZwulPwJ0Hksca9WV9tzmBh7oV4_RAki0LE8CSC7c7zflF73COHrMnIVeGKlDVuHaVRcdPfd3pjXxXENO1Aprk>
X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvledrfeeftddgleehucetufdoteggodetrfdotf
    fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen
    uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne
    cujfgurhepkfffgggfuffvfhfhjggtgfesthekredttddvjeenucfhrhhomheptegurhhi
    rghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtoh
    hmqeenucggtffrrghtthgvrhhnpeffleegieefgfevudehtdfhkeeutdffjeevgeffgeej
    vedthefgudeiteefheejheenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmh
    grihhlfhhrohhmpegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhm
X-ME-Proxy: <xmx:WABzZjW55VtagtvmZt6V7hmi098TUxWMdDUcrnDX9woCQ35fnYHuEQ>
    <xmx:WABzZuk9VXQnKoTwcvh2pCgw5hPxJAivShA8nDiyfx0CFbwT9zDikQ>
    <xmx:WABzZodOnb_lhz_CHusE3WSg6l9ajmhkOZ6-rRA5bURdj38YBE2dnA>
    <xmx:WABzZgFLmdOSYSoGQC-LdXGVMRV2ptweq0RzLFOXzLLBEWWMpaS0Qw>
    <xmx:WABzZjy_6FasZBnJ793gS92E8KFW57NHYBQ8WH4D8AiaASNZ0rM0Hw3s>
Feedback-ID: i76984098:Fastmail
Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed,
 19 Jun 2024 11:59:19 -0400 (EDT)
Message-ID: <000d0d21-c6d6-44af-ab49-5eb303e41994@aklaver.com>
Date: Wed, 19 Jun 2024 08:59:19 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Proper format for pg_dump file date
To: Rich Shepard <rshepard@appl-ecosys.com>,
 pgsql-general@lists.postgresql.org
References: <9f2bfd4-1c20-ea61-40c1-b9911f6049b@appl-ecosys.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <9f2bfd4-1c20-ea61-40c1-b9911f6049b@appl-ecosys.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/000d0d21-c6d6-44af-ab49-5eb303e41994%40aklaver.com>
Precedence: bulk

On 6/19/24 08:55, Rich Shepard wrote:
> Is the correct date format for pg_dump
>      <filename>-$(date +%Y-%m-%d).sql
> or
>      <filename>-YYYY-MM-DD.sql
> or something else?

That is your choice, whatever makes sense to you.

> 
> TIA,
> 
> Rich
> 
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com