| From: | Thomas Güttler <guettliml(at)thomas-guettler(dot)de> |
|---|---|
| To: | Francisco Olarte <folarte(at)peoplecall(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Move rows from one database to other |
| Date: | 2017-02-23 15:25:13 |
| Message-ID: | edf4201c-7d0d-fba6-416b-125511c40b73@thomas-guettler.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Am 23.02.2017 um 10:33 schrieb Francisco Olarte:
> Thomas:
>
> On Wed, Feb 22, 2017 at 1:51 PM, Thomas Güttler
> <guettliml(at)thomas-guettler(dot)de> wrote:
>> I want to **move** the data. The data should get deleted on the satellite
>> after transfer.
>> I don't know how to delete the data which was copied, since inserts can
>> happen during the copy statement.
> Depending on the structure / control / kind of ops you have on the
> satellite you can try a two-table trick, similar to a common one used
> to process files in spool directories.
> [cut]
This sound good. Is there a name for this trick, to find more details?
Regards,
Thomas
--
Thomas Guettler http://www.thomas-guettler.de/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Güttler | 2017-02-23 15:26:27 | Re: Move rows from one database to other |
| Previous Message | Benoit Lobréau | 2017-02-23 15:23:30 | Re: NOTIFY command impact |