On 1 April 2019 08:09:37 CEST, Sathish Kumar <satcs...@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
