Re: Backup

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