public inbox for [email protected]
help / color / mirror / Atom feedFrom: Andy Hartman <[email protected]>
To: Adrian Klaver <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: Backup
Date: Wed, 23 Oct 2024 19:59:26 -0400
Message-ID: <CAEZv3cqu7Uukbdjdq+sMq7vXx+BpfHJg4dJWr+1T2TALW=SFhQ@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
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>
<[email protected]>
<CAEZv3coA9H5FA0pJ2Fcm9pXn76SwBUC3UBDGmNaAQApfp90hgA@mail.gmail.com>
<[email protected]>
<CAEZv3cqpyQX66xvWJHWLKmN8HAOL73Zu-mbEzPj+6Q1VW9RDKg@mail.gmail.com>
<[email protected]>
<CAEZv3crUuwOoGbD754awgJ7cRZoJ7-wYmoVTymR9GbfNbMFsSQ@mail.gmail.com>
<[email protected]>
<CAEZv3coqKQdiNFvLKE=-aiT9VYzzhvrjBr_UC0Z0smYfaHoM+A@mail.gmail.com>
<[email protected]>
The images are part of the csv file...
On Wed, Oct 23, 2024 at 3:47 PM Adrian Klaver <[email protected]>
wrote:
> On 10/23/24 10:43, Andy Hartman wrote:
> > 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...
> Your choice, though the factors I would consider would be:
>
> 1) The process you use to load the CSV files into Postgres and whether
> that is faster then loading the data from the dump file?
>
> 2) Loading from the CSV files directly would be month by month steps
> versus loading from the dump file which would be cumulative to the last
> backup.
>
> Also, what format are the image files in and are they part of the CSV
> files or separate?
>
>
> >
> > THanks .
> >
>
>
> --
> Adrian Klaver
> [email protected]
>
>
view thread (5+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Backup
In-Reply-To: <CAEZv3cqu7Uukbdjdq+sMq7vXx+BpfHJg4dJWr+1T2TALW=SFhQ@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox