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 1t3c2B-00DarN-1s for pgsql-general@arkaria.postgresql.org; Wed, 23 Oct 2024 14:08:23 +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 1t3c19-00A8tp-7N for pgsql-general@arkaria.postgresql.org; Wed, 23 Oct 2024 14:07:19 +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 1t3c18-00A8th-R5 for pgsql-general@lists.postgresql.org; Wed, 23 Oct 2024 14:07:19 +0000 Received: from mail-yb1-xb2b.google.com ([2607:f8b0:4864:20::b2b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1t3c16-002Zrd-Cl for pgsql-general@postgresql.org; Wed, 23 Oct 2024 14:07:18 +0000 Received: by mail-yb1-xb2b.google.com with SMTP id 3f1490d57ef6-e291cbbf05bso7012835276.2 for ; Wed, 23 Oct 2024 07:07:16 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1729692435; x=1730297235; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=spHFo40cpWYcaC1H2ys8ZaYVN9HcKCK8B7TGUrHf8KU=; b=gjxzogjXbmtxPIeUtROQedQf1PPYii/YYz+4RofkPMcho1Xx9tt9jWhNNxt+0r2CPV UgQNK3IG44K/7oiqwt4o0PoevmD8DYxxU19kEEdmaH1qDce+eapeO5ctt9twu4eoy2uk raMNkbT2cK3rKP7VhQdflL9sBbYeRJ99GDu+Kfs0hWF2aJDLCAkZzEhN2X2bzCFIyOfU 6NUfDc8rVW0Mbd4hS2gDXAmdo1bLdv86PfxtbzlzhS+1dfjScnZU387g/ymjo5BRffKh iu67nRCn4qXwCiocbGiBJL8/vm0/aIQXlAILrK7VKoHHSZkCJ+rjOR/RFraHvIEY4C3G Pw+g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1729692435; x=1730297235; h=cc: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=spHFo40cpWYcaC1H2ys8ZaYVN9HcKCK8B7TGUrHf8KU=; b=a9xz6MiLzALFhsLGYHxbcEqKSetquqI4giqGBiQw9yIFa1m/8RlGvxFm3RP8lDZZTn tq0VmiXifMxPN1d3pGMptbSalzGl9gO+nkyGcIw78YNEoeGzfT0vgVnnjXo6UMfFTWoM 1IsZ3PvXPfIRO+gkvgGKwdtJZHUo3HMRHthr5Z5vIgtIMNSVzs0mJdzmK66HkUQzeMyR x4No28IBOYpoR5OzTRatkNUXXXcdjwH8FNGvbVWrHJaRdHx1j6stTxx2FPnx3VhJDH+/ ZW+vdepNQnZuq/0Y3jsJOjZPSNsmZLFSuowXcqn3BT9RaGn5ywcTpMMCu/QriRSGYqZB FUeg== X-Gm-Message-State: AOJu0YzX+5o079jhCOhlMP5i6vzt1Jddop9o5YKysfcU4aFBJJH8m7EE we6atXWsgx7nLJJWora3WKo1agyVLTlZM6FeVJyqWZx7ih8UTg+/YyHeMdXu1TjPBcdiiHDE6oD U4TP2EMPqyZKX0Ra99CxcPEBfed7XYw== X-Google-Smtp-Source: AGHT+IGm4OF9A/Gn36iqHPtUg3RXHr8P+1iUtv3PYSfO48AhXpOteIN/fPP5ZZPkCNa6i9GBE0QkDYA0PF5lGzTtwUE= X-Received: by 2002:a05:6902:11c7:b0:e2b:b45a:149 with SMTP id 3f1490d57ef6-e2e3a6d228emr2784104276.39.1729692434350; Wed, 23 Oct 2024 07:07:14 -0700 (PDT) MIME-Version: 1.0 References: <1be444fc-e613-4489-aa19-b02ca16d4e30@aklaver.com> <17c9eeb9-f8a9-4ab3-b177-0c11dd345b6e@aklaver.com> In-Reply-To: From: Andy Hartman Date: Wed, 23 Oct 2024 10:07:02 -0400 Message-ID: Subject: Re: Backup To: Adrian Klaver Cc: pgsql-general Content-Type: multipart/alternative; boundary="0000000000001ecb9e062525670a" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000001ecb9e062525670a Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable I have been testing different backup methods suggested and wonder if I have all my files used to load the DB .. could that be considered a backup... obviously need to have schema backup in case of problem, but that seems to be easily re-created Thoughts? On Fri, Oct 18, 2024 at 2:30=E2=80=AFPM Adrian Klaver wrote: > > > On 10/18/24 11:25 AM, Andy Hartman wrote: > > Windows Server 2022 > > > > I would like a backup process similar to what I'm used to using in the > > mssql world if that's possible with Postgres... I will be > > loading monthly archive data to Postgresql so that's why I probably onl= y > > need once a backup .. once loaded data is just viewed thru an app... no > > updates.. > > > > in mssql you create the .bak and easily restorable .... that's what I'= m > > looking for with Postgres > > > > Then pg_dump for database backup: > > https://www.postgresql.org/docs/current/app-pgdump.html > > and pg_dumpall for entire cluster backup: > > https://www.postgresql.org/docs/current/app-pg-dumpall.html > > > thanks for replies.. > > > > > > > > On Fri, Oct 18, 2024 at 1:00=E2=80=AFPM Adrian Klaver > > wrote: > > > > On 10/18/24 09:52, Andy Hartman wrote: > > > > Reply to list also > > Ccing list. > > > > > Windows 22 and Postgres 16.4 > > > > > Is that Windows Server 2022 or Windows 10/11 with the 22H2 update? > > > > You also need to provide a more detailed description of what you wa= nt > > the backup to do? > > > > > > > > > > > On Fri, Oct 18, 2024 at 12:04=E2=80=AFPM Adrian Klaver > > > > > > >> wrote: > > > > > > On 10/18/24 05:39, Andy Hartman wrote: > > > > I would like to use the closest thing to a mssql backup..= . > > > > > > > > > > As in? > > > > > > Searching on 'mssql backup' returns a lot of choices. You > > will need to > > > be more specific on what you want to achieve. Also be > > specific about > > > what versions of OS and Postgres you are using. > > > > > > -- > > > Adrian Klaver > > > adrian.klaver@aklaver.com > > >> > > > > > > > -- > > Adrian Klaver > > adrian.klaver@aklaver.com > > > > -- > Adrian Klaver > adrian.klaver@aklaver.com > --0000000000001ecb9e062525670a Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
I have been testing different backup methods suggested and= wonder if I have all my files used to load the DB .. could that be conside= red a backup... obviously=C2=A0need to have schema backup in case of proble= m, but that seems to be easily re-created

Thoughts?

On Fri, Oct 18, 2= 024 at 2:30=E2=80=AFPM Adrian Klaver <adrian.klaver@aklaver.com> wrote:


On 10/18/24 11:25 AM, Andy Hartman wrote:
> Windows Server 2022
>
> I would like a backup process similar=C2=A0to what I'm used to usi= ng in the
> mssql world if that's=C2=A0=C2=A0possible with Postgres... I will = be
> loading=C2=A0monthly archive data to Postgresql so that's why I pr= obably only
> need once a backup .. once loaded data is just viewed thru an app... n= o
> updates..
>
> in mssql you create the .bak and easily=C2=A0restorable=C2=A0....=C2= =A0 that's what I'm
> looking for with Postgres
>

Then pg_dump for database backup:

https://www.postgresql.org/docs/current/app-p= gdump.html

and pg_dumpall for entire cluster backup:

https://www.postgresql.org/docs/current/a= pp-pg-dumpall.html

> thanks for replies..
>
>
>
> On Fri, Oct 18, 2024 at 1:00=E2=80=AFPM Adrian Klaver <adrian.klaver@aklaver.co= m
> <mailto:adrian.klaver@aklaver.com>> wrote:
>
>=C2=A0 =C2=A0 =C2=A0On 10/18/24 09:52, Andy Hartman wrote:
>
>=C2=A0 =C2=A0 =C2=A0Reply to list also
>=C2=A0 =C2=A0 =C2=A0Ccing list.
>
>=C2=A0 =C2=A0 =C2=A0 > Windows 22 and Postgres 16.4
>=C2=A0 =C2=A0 =C2=A0 >
>=C2=A0 =C2=A0 =C2=A0Is that Windows Server 2022 or Windows 10/11 with t= he 22H2 update?
>
>=C2=A0 =C2=A0 =C2=A0You also need to provide a more detailed descriptio= n of what you want
>=C2=A0 =C2=A0 =C2=A0the backup to do?
>
>=C2=A0 =C2=A0 =C2=A0 >
>=C2=A0 =C2=A0 =C2=A0 >
>=C2=A0 =C2=A0 =C2=A0 > On Fri, Oct 18, 2024 at 12:04=E2=80=AFPM Adri= an Klaver
>=C2=A0 =C2=A0 =C2=A0 > <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.co= m>
>=C2=A0 =C2=A0 =C2=A0<mailto:adrian.klaver@aklaver.com
>=C2=A0 =C2=A0 =C2=A0<mailto:adrian.klaver@aklaver.com>>> wrote:
>=C2=A0 =C2=A0 =C2=A0 >
>=C2=A0 =C2=A0 =C2=A0 >=C2=A0 =C2=A0 =C2=A0On 10/18/24 05:39, Andy Ha= rtman wrote:
>=C2=A0 =C2=A0 =C2=A0 >=C2=A0 =C2=A0 =C2=A0 > I would like to use = the closest thing to a mssql backup...
>=C2=A0 =C2=A0 =C2=A0 >=C2=A0 =C2=A0 =C2=A0 >
>=C2=A0 =C2=A0 =C2=A0 >
>=C2=A0 =C2=A0 =C2=A0 >=C2=A0 =C2=A0 =C2=A0As in?
>=C2=A0 =C2=A0 =C2=A0 >
>=C2=A0 =C2=A0 =C2=A0 >=C2=A0 =C2=A0 =C2=A0Searching on 'mssql ba= ckup' returns a=C2=A0 lot of choices. You
>=C2=A0 =C2=A0 =C2=A0will need to
>=C2=A0 =C2=A0 =C2=A0 >=C2=A0 =C2=A0 =C2=A0be more specific on what y= ou want to achieve. Also be
>=C2=A0 =C2=A0 =C2=A0specific about
>=C2=A0 =C2=A0 =C2=A0 >=C2=A0 =C2=A0 =C2=A0what versions of OS and Po= stgres you are using.
>=C2=A0 =C2=A0 =C2=A0 >
>=C2=A0 =C2=A0 =C2=A0 >=C2=A0 =C2=A0 =C2=A0--
>=C2=A0 =C2=A0 =C2=A0 >=C2=A0 =C2=A0 =C2=A0Adrian Klaver
>=C2=A0 =C2=A0 =C2=A0 > adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>=C2=A0 =C2=A0 =C2=A0<mailto:adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.c= om>>
>=C2=A0 =C2=A0 =C2=A0 >
>
>=C2=A0 =C2=A0 =C2=A0--
>=C2=A0 =C2=A0 =C2=A0Adrian Klaver
>=C2=A0 =C2=A0 =C2=A0adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com><= br> >

--
Adrian Klaver
adrian.klave= r@aklaver.com
--0000000000001ecb9e062525670a--