Hi Sathish, as Michel Pelletier, pointed out, a trigger based approach (i.e
slony-I, bucardo) or the pg_logical plugin (requires server restart) is the
way to go, personally, I've worked with slony-I, the initial setup is
somewhat tricky, but it works, depending on how transactional the table,
stor
Hi All,
Can you tell me a way for table replication or sync or to achieve minimal
downtime from dbserver1 to dbserver2 on Postgresql 9.5
Table Size: 160gb
4VCPU, 16gb RAM
On Tue, Apr 2, 2019, 12:19 AM Sathish Kumar wrote:
> The table size is 160gb. We would like to move/copy this table fro one
The table size is 160gb. We would like to move/copy this table fro one db
server to another db server.
On Tue, Apr 2, 2019, 12:17 AM Michel Pelletier
wrote:
> On Mon, Apr 1, 2019 at 7:47 AM Sathish Kumar wrote:
>
>> Hi Adrian,
>> We are exporting live table data to a new database, so we need to
On Mon, Apr 1, 2019 at 7:47 AM Sathish Kumar wrote:
> Hi Adrian,
> We are exporting live table data to a new database, so we need to stop our
> application until the export/import is completed. We would like to minimise
> this downtime.
>
It's more complicated if you want to keep your applicatio
/"so we need to stop our application until the export/import is completed."/
Why?
On 4/1/19 9:47 AM, Sathish Kumar wrote:
Hi Adrian,
We are exporting live table data to a new database, so we need to stop our
application until the export/import is completed. We would like to
minimise this down
Hi Adrian,
We are exporting live table data to a new database, so we need to stop our
application until the export/import is completed. We would like to minimise
this downtime.
On Mon, Apr 1, 2019, 10:22 PM Adrian Klaver
wrote:
> On 3/31/19 11:09 PM, Sathish Kumar wrote:
> > Hi Team,
> >
> > We
As other have pointed out, you can take a pg_dump at anytime. You can
provide arguments to pg_dump to only dump a subset of the database (like
one table). Also mentioned is using a foreign data wrapper (FDW). yet
another approach is to use the "copy to/from program" command to stream the
table f
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 addit
ge:
> cid:image004.png@01D4BE20.1EAF68B0]
>
>
>
>
>
> *De :* satcs...@gmail.com [mailto:satcs...@gmail.com]
> *Envoyé :* lundi 1 avril 2019 08:10
> *À :* pgsql-gene...@postgresql.org >> PG-General Mailing List <
> pgsql-gene...@postgresql.org>
> *Objet :
03.png@01D4BE20.1EAF68B0]<mailto:prenom@edf.fr>[cid:image004.png@01D4BE20.1EAF68B0]
De : satcs...@gmail.com [mailto:satcs...@gmail.com]
Envoyé : lundi 1 avril 2019 08:10
À : pgsql-gene...@postgresql.org >> PG-General Mailing List
Objet : Table Export & Import
Hi Team,
We have a requi
On 1 April 2019 08:09:37 CEST, 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?
>
>Table Size: 160GB
>Postgresql Se
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
12 matches
Mail list logo
