public inbox for [email protected]  

help / color / mirror / Atom feed
From: Andy Hartman <[email protected]>
To: Adrian Klaver <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: Backup
Date: Wed, 23 Oct 2024 13:43:02 -0400
Message-ID: <CAEZv3coqKQdiNFvLKE=-aiT9VYzzhvrjBr_UC0Z0smYfaHoM+A@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
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>
	<[email protected]>
	<CAEZv3coA9H5FA0pJ2Fcm9pXn76SwBUC3UBDGmNaAQApfp90hgA@mail.gmail.com>
	<[email protected]>
	<CAEZv3cqpyQX66xvWJHWLKmN8HAOL73Zu-mbEzPj+6Q1VW9RDKg@mail.gmail.com>
	<[email protected]>
	<CAEZv3crUuwOoGbD754awgJ7cRZoJ7-wYmoVTymR9GbfNbMFsSQ@mail.gmail.com>
	<[email protected]>

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...

THanks .

On Wed, Oct 23, 2024 at 11:50 AM Adrian Klaver <[email protected]>
wrote:

> On 10/23/24 07:07, Andy Hartman wrote:
> > I have been testing different backup methods suggested and wonder if I
> > have all my files used to load the DB .. could that be considered a
> > backup... obviously need to have schema backup in case of problem, but
> > that seems to be easily re-created
> >
> > Thoughts?
>
> Did you actually read the information at the links provided?
>
> By default pg_dump and pg_dumpall will dump both the schema definitions
> as well as the data.
>
> Yes it is a backup of the database(s) at the point in time you initiate
> the dump. If you want something different then you are probably looking
> for one of the replication methods. You still have not answered:
>
> " You also need to provide a more detailed description of what you want
> the backup to do?"
>
> so it is hard to say what method is best for your situation.
>
> >
>
>
> --
> Adrian Klaver
> [email protected]
>
>


view thread (5+ messages)  latest in thread

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Backup
  In-Reply-To: <CAEZv3coqKQdiNFvLKE=-aiT9VYzzhvrjBr_UC0Z0smYfaHoM+A@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox