From: | Andy Hartman <hartman60home(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Backup |
Date: | 2024-10-23 23:59:26 |
Message-ID: | CAEZv3cqu7Uukbdjdq+sMq7vXx+BpfHJg4dJWr+1T2TALW=SFhQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Michel Pelletier | 2024-10-24 01:39:03 | Re: Using Expanded Objects other than Arrays from plpgsql |
Previous Message | David G. Johnston | 2024-10-23 21:48:18 | Re: Max size per relation for partitioned tables |