public inbox for [email protected]
help / color / mirror / Atom feedFrom: David G. Johnston <[email protected]>
To: dfgpostgres <[email protected]>
Cc: [email protected]
Subject: Re: can recs be transferred between DBs ?
Date: Tue, 28 Apr 2026 09:05:31 -0700
Message-ID: <CAKFQuwbyRfoacj=OPEt6dmpF3sTiDvZ7ujtVVRXhjhO3vRn24g@mail.gmail.com> (raw)
In-Reply-To: <CAAcmDX9t2Od6DmPs3zUq=P2jDFhm-wiVsdF5=+yp=OtsYt1vxQ@mail.gmail.com>
References: <CAAcmDX9t2Od6DmPs3zUq=P2jDFhm-wiVsdF5=+yp=OtsYt1vxQ@mail.gmail.com>
On Tue, Apr 28, 2026 at 8:56 AM dfgpostgres <[email protected]> wrote:
>
> The managers tell me that they want to restore "beta" back to the main DB.
> I know I could do this with something like a perl script, making
> connections to both DBs and transferring them over using select statements
> in "beta_archive" and insert statements in the main DB. But is there a
> better way, something inherent in PG SQL that allows me to do something
> like this ?
>
>
pg_dump / pg_restore are the core tools at your disposal. The ability to
specify --inserts and --on-conflict-do-nothing on pg_dump in particular
make at least attempting this against a copy of the backups quite appealing
before trying to write a more targeted transfer script.
David J.
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: can recs be transferred between DBs ?
In-Reply-To: <CAKFQuwbyRfoacj=OPEt6dmpF3sTiDvZ7ujtVVRXhjhO3vRn24g@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