[GENERAL] table partition problem

2017-10-07 Thread Hung Phan
criteria will check. (One way to perform that is to check on application layer but I think it is not good idea) Regards, Hung Phan

Re: [GENERAL] pg_rewind copy so much data

2017-09-29 Thread Hung Phan
. On Fri, Sep 29, 2017 at 12:06 PM, Michael Paquier wrote: > On Fri, Sep 29, 2017 at 1:06 PM, Hung Phan wrote: > > I used tablespace to store data and it seems to be that pg_rewind copied > > everthing in the tablespace. Today I found an article posted by you > (Michael > &g

Re: [GENERAL] pg_rewind copy so much data

2017-09-28 Thread Hung Phan
so, is there anyway to work around ? Regards, Hung Phan On Fri, Sep 15, 2017 at 1:55 PM, Michael Paquier wrote: > On Fri, Sep 15, 2017 at 2:57 PM, Hung Phan wrote: > > [...] > > Please do not top-post. This breaks the logic of the thread. > > > I use ver 9.5.3. >

Re: [GENERAL] pg_rewind copy so much data

2017-09-14 Thread Hung Phan
PG_9.5_201510051/16387/16665", offset 500, size 100 received chunk for file "pg_tblspc/16386/PG_9.5_201510051/16387/16665", offset 600, size 100 received chunk for file "pg_tblspc/16386/PG_9.5_201510051/16387/16665", offset 700, size 100 received chunk

Re: [GENERAL] pg_rewind copy so much data

2017-09-12 Thread Hung Phan
just show additional bunch of files copied in directories like base or pg_tblspc. I claim that there is no data inserted of modified from the first step. The only difference between two server is caused by restarting old master. Thanks and Regards, Hung Phan On Wed, Sep 13, 2017 at 10:48 AM, Micha

[GENERAL] pg_rewind copy so much data

2017-09-12 Thread Hung Phan
with progress option The pg_rewind ran successfully but I saw it copied more than 4GB (4265891 kB copied). So I wonder there was very minor difference between two servesr but why did pg_rewind copy almost all data of new master? Regards, Hung Phan