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 ) id 1sJyu5-007g5X-0m for pgsql-general@arkaria.postgresql.org; Wed, 19 Jun 2024 17:15:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sJyu2-0037jA-Pu for pgsql-general@arkaria.postgresql.org; Wed, 19 Jun 2024 17:15:23 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sJyu2-0037j2-CQ for pgsql-general@lists.postgresql.org; Wed, 19 Jun 2024 17:15:23 +0000 Received: from mail-oa1-x30.google.com ([2001:4860:4864:20::30]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sJyu1-002VM3-1p for pgsql-general@postgresql.org; Wed, 19 Jun 2024 17:15:22 +0000 Received: by mail-oa1-x30.google.com with SMTP id 586e51a60fabf-25488f4e55aso49651fac.0 for ; Wed, 19 Jun 2024 10:15:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1718817318; x=1719422118; darn=postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=XyqeFfMFtXhOfkABTx3eB2v2cC3XZs3b4C15t+tnwUQ=; b=bTmi40EjdK1dqgsSRecrQEl6m68sydS02Hib5hw59W42qtzxJmyj3Qexuoty3WD4xv CXbythVzq7l9ca5TI/pGUczXdAUayQ6v7eqKshAjQNsIB3xK8+mJtYI0qHBXqNCEtfaz ONejWQ8juqtZsYIWT4VOkoWq5k1XrbtN3McK5NWJ4VJvWfKT4aYclgU5XMqvJQwho3+n GRv+sCpPqxEb/nPNl+7I0bE3ITVgMxWNx6zZIF94Pq7V++44cpD1yfRoHy4lYs96IwLv J4JkhOQ3CSTTCs0AP5IMWyrQSMH12wXGAnXi3MRxVzks9XZRuTuPivkKlUwcvJVFrz/c bciQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1718817318; x=1719422118; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=XyqeFfMFtXhOfkABTx3eB2v2cC3XZs3b4C15t+tnwUQ=; b=VjAYR5Io+A4Fj0LnFWv88kbTgcNt1fIO6P3UNOtmp1pvdwVjBS3fvLVUiB9Sx0XBJL TujEUQO/e1F/sq48z0zDYOJ4s1meNg1ZNO6GSkT7F1IpTD5BASR55+84X5rfLItjm5yd U9wQaMJTzrCs1K/zfVEA+mqLX+HYRdxU/yJd3e2ltJdk6wxQKCSsvN21udTtRbHluarR H7nrdLHvE5JattXDzoMqpqQXA6QTyjGSc1iJhLxJy6kCWVu6v1qNcLqJptk/75FsFjaO HN2UCVFeVV7Nh5kmXUoT+WGeTEkkMSZXViuc0V1VBKGdfaSLetfZO8jMR4+Wc5fUSmbM FxpQ== X-Gm-Message-State: AOJu0YxdwkBuzbna3O1hL0eq2MlR+2Ms5TI/08mJppedfQC1lovLSc7B O4Oq3hwwBa5qceeFB77d4Q5a22kkkfbO49atXNeCBbmdqefaBkvCJmfCQ4HX7Npo84DHO14++mp FAGku9LBpqJQDIBH1kccLaDHxUqAkQQ== X-Google-Smtp-Source: AGHT+IGOp1IHw4kHN21APDOrKJ82w+z4ytNelep+TweCWjgIwbXtlk9ViUdtGvNXZwVMBok+Q8lNg5hXlR9rBJAwykU= X-Received: by 2002:a05:6870:f6a8:b0:24f:d9fe:8b9f with SMTP id 586e51a60fabf-25c94999cdemr3144905fac.22.1718817318514; Wed, 19 Jun 2024 10:15:18 -0700 (PDT) MIME-Version: 1.0 References: <9f2bfd4-1c20-ea61-40c1-b9911f6049b@appl-ecosys.com> In-Reply-To: <9f2bfd4-1c20-ea61-40c1-b9911f6049b@appl-ecosys.com> From: Ron Johnson Date: Wed, 19 Jun 2024 13:15:07 -0400 Message-ID: Subject: Re: Proper format for pg_dump file date To: pgsql-general Content-Type: multipart/alternative; boundary="000000000000b439a9061b415756" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000b439a9061b415756 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wed, Jun 19, 2024 at 11:55=E2=80=AFAM Rich Shepard wrote: > Is the correct date format for pg_dump > -$(date +%Y-%m-%d).sql > or > -YYYY-MM-DD.sql > "Click select" stops at dash in some ssh clients, but not in others. That's what drives *my* decision making. (Also, "%F" is equivalent to "%Y-%m-%d".) --000000000000b439a9061b415756 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Wed, Jun 19, 2024 at 11:55=E2=80=AFAM = Rich Shepard <rshepard@appl-= ecosys.com> wrote:
Is the correct date format for pg_dump=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 <filename>-$(date +%Y-%m-%d).sql
or
=C2=A0 =C2=A0 =C2=A0 =C2=A0 <filename>-YYYY-MM-DD.sql

"Click select" stops at dash in some ssh cli= ents, but not in others.=C2=A0 That's what drives my=C2=A0decisi= on making.

(Also, "%F" is equivalent to = "%Y-%m-%d".)
--000000000000b439a9061b415756--