Postgres Pro
Downloads
Home   >   mailing lists

Re: Table Export & Import - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: Table Export & Import
Date
Msg-id 16765AD8-A0A1-4B90-9FDE-E72B335B5C6F@a-kretschmer.de
Whole thread Raw
In response to Table Export & Import  (Sathish Kumar <satcse88@gmail.com>)
List pgsql-general
Tree view 
On 1 April 2019 08:09:37 CEST, Sathish Kumar <satcse88@gmail.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

pgsql-general by date:

Previous
From: Sathish Kumar
Date:
Subject: Table Export & Import
Next
From: Ankit Trivedi
Date:
Subject: Required postgreSQL 10.4 version for Suse enterprise