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> <CAEZv3cqpyQX66xvWJHWLKmN8HAOL73Zu-mbEzPj+6Q1VW9RDKg@mail.gmail.com>
 <d5a7ba8c-c7f9-4945-8505-c2cbc1a297fe@aklaver.com> <CAEZv3crUuwOoGbD754awgJ7cRZoJ7-wYmoVTymR9GbfNbMFsSQ@mail.gmail.com>
 <2895baa9-abe7-4ff9-a7d5-03d3ae500df2@aklaver.com>
In-Reply-To: <2895baa9-abe7-4ff9-a7d5-03d3ae500df2@aklaver.com>
From: Andy Hartman <hartman60home@gmail.com>
Date: Wed, 23 Oct 2024 13:43:02 -0400
Message-ID: <CAEZv3coqKQdiNFvLKE=-aiT9VYzzhvrjBr_UC0Z0smYfaHoM+A@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="0000000000008d574c0625286b9b"
Archived-At: <https://www.postgresql.org/message-id/CAEZv3coqKQdiNFvLKE%3D-aiT9VYzzhvrjBr_UC0Z0smYfaHoM%2BA%40mail.gmail.com>
Precedence: bulk

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

I'm using the DB as a History repository... I'm pulling info from a Mssql
db using a P/S script to a csv file then Import that to Postgres I only
keep 6 months live on the mssql db and roll everything else to Postgres
Arch DB.

  After I load this latest month to Postgres I just need to backup, or
should I just retain my .csv files as a Backup... I have 2 tables that I
load to Hist and one table holds the images...

THanks .

On Wed, Oct 23, 2024 at 11:50=E2=80=AFAM Adrian Klaver <adrian.klaver@aklav=
er.com>
wrote:

> On 10/23/24 07:07, Andy Hartman wrote:
> > 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?
>
> Did you actually read the information at the links provided?
>
> By default pg_dump and pg_dumpall will dump both the schema definitions
> as well as the data.
>
> Yes it is a backup of the database(s) at the point in time you initiate
> the dump. If you want something different then you are probably looking
> for one of the replication methods. You still have not answered:
>
> " You also need to provide a more detailed description of what you want
> the backup to do?"
>
> so it is hard to say what method is best for your situation.
>
> >
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>
>

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

<div dir=3D"ltr">I&#39;m using the DB as a History repository... I&#39;m pu=
lling info from a Mssql db using a P/S script to a csv file then Import tha=
t to Postgres I only keep 6 months live on the mssql db and roll everything=
 else to Postgres Arch DB.<br><br>=C2=A0 After I load this latest month to =
Postgres I just need to backup, or should I just retain my .csv files as a =
Backup... I have 2 tables that I load to Hist and one table holds the image=
s...<br><br>THanks .</div><br><div class=3D"gmail_quote"><div dir=3D"ltr" c=
lass=3D"gmail_attr">On Wed, Oct 23, 2024 at 11:50=E2=80=AFAM Adrian Klaver =
&lt;<a href=3D"mailto:adrian.klaver@aklaver.com">adrian.klaver@aklaver.com<=
/a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0=
px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">O=
n 10/23/24 07:07, Andy Hartman wrote:<br>
&gt; I have been testing different backup methods suggested and wonder if I=
 <br>
&gt; have all my files used to load the DB .. could that be considered a <b=
r>
&gt; backup... obviously=C2=A0need to have schema backup in case of problem=
, but <br>
&gt; that seems to be easily re-created<br>
&gt; <br>
&gt; Thoughts?<br>
<br>
Did you actually read the information at the links provided?<br>
<br>
By default pg_dump and pg_dumpall will dump both the schema definitions <br=
>
as well as the data.<br>
<br>
Yes it is a backup of the database(s) at the point in time you initiate <br=
>
the dump. If you want something different then you are probably looking <br=
>
for one of the replication methods. You still have not answered:<br>
<br>
&quot; You also need to provide a more detailed description of what you wan=
t<br>
the backup to do?&quot;<br>
<br>
so it is hard to say what method is best for your situation.<br>
<br>
&gt; <br>
<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>

--0000000000008d574c0625286b9b--