Re: Backup

The images are part of the csv file...

On Wed, Oct 23, 2024 at 3:47 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
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
> adrian(dot)klaver(at)aklaver(dot)com
>
>