On 3/31/19 11:09 PM, Sathish Kumar 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?
So what is creating the downtime now? In addition to other suggestions you might want to take a look at: https://www.postgresql.org/docs/9.5/postgres-fdw.html
Table Size: 160GB Postgresql Server Version: 9.5
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx