The images are part of the csv file... On Wed, Oct 23, 2024 at 3:47 PM Adrian Klaver <adrian.kla...@aklaver.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.kla...@aklaver.com > >
