Feedback-ID: i76984098:Fastmail
Message-ID: <f0e1f58f-ab5d-4906-bfd5-1ae29575f5b5@aklaver.com>
Date: Wed, 23 Oct 2024 12:47:01 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Backup
To: Andy Hartman <hartman60home@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
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>
 <1be444fc-e613-4489-aa19-b02ca16d4e30@aklaver.com>
 <CAEZv3coA9H5FA0pJ2Fcm9pXn76SwBUC3UBDGmNaAQApfp90hgA@mail.gmail.com>
 <17c9eeb9-f8a9-4ab3-b177-0c11dd345b6e@aklaver.com>
 <CAEZv3cqpyQX66xvWJHWLKmN8HAOL73Zu-mbEzPj+6Q1VW9RDKg@mail.gmail.com>
 <d5a7ba8c-c7f9-4945-8505-c2cbc1a297fe@aklaver.com>
 <CAEZv3crUuwOoGbD754awgJ7cRZoJ7-wYmoVTymR9GbfNbMFsSQ@mail.gmail.com>
 <2895baa9-abe7-4ff9-a7d5-03d3ae500df2@aklaver.com>
 <CAEZv3coqKQdiNFvLKE=-aiT9VYzzhvrjBr_UC0Z0smYfaHoM+A@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAEZv3coqKQdiNFvLKE=-aiT9VYzzhvrjBr_UC0Z0smYfaHoM+A@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/f0e1f58f-ab5d-4906-bfd5-1ae29575f5b5%40aklaver.com>
Precedence: bulk

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.klaver@aklaver.com