MIME-Version: 1.0
References: <CAEZv3cqct1WFb9KYmYa5kjdxfVK8JEFdzbJ5bRL6b4r+XR2dug@mail.gmail.com>
 <CAJ9xe=sdH2-kgM0+bMH8Oe_4=npPwetue+ukz9MXDTZfJ_poUg@mail.gmail.com>
 <CAEZv3cpDuCNg=vN_Q=ogk7ems0fho3xTWoCjLhZr47yM5u77KQ@mail.gmail.com>
 <CAEZv3co3spuFH6JWB7fwxjobZA2CfiBxjx59kPvBLrmm_ro_0A@mail.gmail.com>
 <1be444fc-e613-4489-aa19-b02ca16d4e30@aklaver.com> <CAEZv3coA9H5FA0pJ2Fcm9pXn76SwBUC3UBDGmNaAQApfp90hgA@mail.gmail.com>
 <17c9eeb9-f8a9-4ab3-b177-0c11dd345b6e@aklaver.com>
In-Reply-To: <17c9eeb9-f8a9-4ab3-b177-0c11dd345b6e@aklaver.com>
From: Andy Hartman <hartman60home@gmail.com>
Date: Fri, 18 Oct 2024 14:25:28 -0400
Message-ID: <CAEZv3cqpyQX66xvWJHWLKmN8HAOL73Zu-mbEzPj+6Q1VW9RDKg@mail.gmail.com>
Subject: Re: Backup
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000001592a60624c46ed1"
Archived-At: <https://www.postgresql.org/message-id/CAEZv3cqpyQX66xvWJHWLKmN8HAOL73Zu-mbEzPj%2B6Q1VW9RDKg%40mail.gmail.com>
Precedence: bulk

--0000000000001592a60624c46ed1
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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 only 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

thanks for replies..


On Fri, Oct 18, 2024 at 1:00=E2=80=AFPM Adrian Klaver <adrian.klaver@aklave=
r.com>
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 want
> the backup to do?
>
> >
> >
> > On Fri, Oct 18, 2024 at 12:04=E2=80=AFPM Adrian Klaver
> > <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> 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 nee=
d
> to
> >     be more specific on what you want to achieve. Also be specific abou=
t
> >     what versions of OS and Postgres you are using.
> >
> >     --
> >     Adrian Klaver
> >     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> >
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>
>

--0000000000001592a60624c46ed1
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">Windows Server 2022<br><br>I would like a=
 backup process similar=C2=A0to what I&#39;m used to using in the mssql wor=
ld if that&#39;s=C2=A0=C2=A0possible with Postgres... I will be loading=C2=
=A0monthly archive data to Postgresql so that&#39;s why I probably only nee=
d once a backup .. once loaded data is just viewed thru an app... no update=
s..<br><br>in mssql you create the .bak and easily=C2=A0restorable=C2=A0...=
.=C2=A0 that&#39;s what I&#39;m looking for with Postgres<br><br>thanks for=
 replies..<br><br><br></div></div><br><div class=3D"gmail_quote"><div dir=
=3D"ltr" class=3D"gmail_attr">On Fri, Oct 18, 2024 at 1:00=E2=80=AFPM Adria=
n Klaver &lt;<a href=3D"mailto:adrian.klaver@aklaver.com">adrian.klaver@akl=
aver.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D=
"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-le=
ft:1ex">On 10/18/24 09:52, Andy Hartman wrote:<br>
<br>
Reply to list also<br>
Ccing list.<br>
<br>
&gt; Windows 22 and Postgres 16.4<br>
&gt; <br>
Is that Windows Server 2022 or Windows 10/11 with the 22H2 update?<br>
<br>
You also need to provide a more detailed description of what you want <br>
the backup to do?<br>
<br>
&gt; <br>
&gt; <br>
&gt; On Fri, Oct 18, 2024 at 12:04=E2=80=AFPM Adrian Klaver <br>
&gt; &lt;<a href=3D"mailto:adrian.klaver@aklaver.com" target=3D"_blank">adr=
ian.klaver@aklaver.com</a> &lt;mailto:<a href=3D"mailto:adrian.klaver@aklav=
er.com" target=3D"_blank">adrian.klaver@aklaver.com</a>&gt;&gt; wrote:<br>
&gt; <br>
&gt;=C2=A0 =C2=A0 =C2=A0On 10/18/24 05:39, Andy Hartman wrote:<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt; I would like to use the closest thing to a ms=
sql backup...<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt;<br>
&gt; <br>
&gt;=C2=A0 =C2=A0 =C2=A0As in?<br>
&gt; <br>
&gt;=C2=A0 =C2=A0 =C2=A0Searching on &#39;mssql backup&#39; returns a=C2=A0=
 lot of choices. You will need to<br>
&gt;=C2=A0 =C2=A0 =C2=A0be more specific on what you want to achieve. Also =
be specific about<br>
&gt;=C2=A0 =C2=A0 =C2=A0what versions of OS and Postgres you are using.<br>
&gt; <br>
&gt;=C2=A0 =C2=A0 =C2=A0-- <br>
&gt;=C2=A0 =C2=A0 =C2=A0Adrian Klaver<br>
&gt;=C2=A0 =C2=A0 =C2=A0<a href=3D"mailto:adrian.klaver@aklaver.com" target=
=3D"_blank">adrian.klaver@aklaver.com</a> &lt;mailto:<a href=3D"mailto:adri=
an.klaver@aklaver.com" target=3D"_blank">adrian.klaver@aklaver.com</a>&gt;<=
br>
&gt; <br>
<br>
-- <br>
Adrian Klaver<br>
<a href=3D"mailto:adrian.klaver@aklaver.com" target=3D"_blank">adrian.klave=
r@aklaver.com</a><br>
<br>
</blockquote></div>

--0000000000001592a60624c46ed1--