| From: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org,Sathish Kumar <satcse88(at)gmail(dot)com>,"pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Table Export & Import |
| Date: | 2019-04-01 06:15:16 |
| Message-ID: | 16765AD8-A0A1-4B90-9FDE-E72B335B5C6F@a-kretschmer.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 1 April 2019 08:09:37 CEST, Sathish Kumar <satcse88(at)gmail(dot)com> wrote:
>Hi Team,
>
>We have a requirement to copy a table from one database server to
>another
>database server. We are looking for a solution to achieve this with
>lesser
>downtime on Prod. Can you help us with this?
>
>Table Size: 160GB
>Postgresql Server Version: 9.5
You can take a dump at any time without downtime. Other solution would be a logical replicarion using, for instance, slony, londiste or pg_logical from 2ndQuadrant.
Regards, Andreas
--
2ndQuadrant - The PostgreSQL Support Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ankit Trivedi | 2019-04-01 07:42:50 | Required postgreSQL 10.4 version for Suse enterprise |
| Previous Message | Sathish Kumar | 2019-04-01 06:09:37 | Table Export & Import |