Re: [GENERAL] Question about wal files / pg_xlogs

2016-08-05 Thread Patrick B
Hi guys, I can now confirm that by taking off the IONICE command solved my problem. Thanks a lot ! Patrick

Re: [GENERAL] Question about wal files / pg_xlogs

2016-08-05 Thread Alex Ignatov
Hello! As I can see files is delivered not with delay but with timeshift. 1. Can you show me restore_command on slave? 2. Also can you check archived WAL creation time on slaves in archive location after you copied them with archive_command? Is in near WAL creation time in pg_xlogs? Or differ

Re: [GENERAL] Question about wal files / pg_xlogs

2016-08-04 Thread Patrick B
> > > And the time difference is on ALL slaves, or just the two in a different > country? > > > All of them! :(

Re: [GENERAL] Question about wal files / pg_xlogs

2016-08-04 Thread Melvin Davidson
On Thu, Aug 4, 2016 at 4:32 PM, Patrick B wrote: > >>> >> Just out of curiostity, are the slaves in the same physical location, or >> by some chance are they on a remote site? >> >> >> > two of them in the same physical location, and the other two different > country. > > >two of them in the same

Re: [GENERAL] Question about wal files / pg_xlogs

2016-08-04 Thread Patrick B
> > >> > Just out of curiostity, are the slaves in the same physical location, or > by some chance are they on a remote site? > > > two of them in the same physical location, and the other two different country.

Re: [GENERAL] Question about wal files / pg_xlogs

2016-08-04 Thread Melvin Davidson
On Thu, Aug 4, 2016 at 4:16 PM, Patrick B wrote: > >>> >> https://www.postgresql.org/docs/9.5/static/continuous-archiv >> ing.html#BACKUP-ARCHIVING-WAL >> >> "However, archive_command can be changed with a configuration file >> reload." >> >> > > > Cheers... I removed the IONICE command from the

Re: [GENERAL] Question about wal files / pg_xlogs

2016-08-04 Thread Adrian Klaver
On 08/04/2016 01:16 PM, Patrick B wrote: https://www.postgresql.org/docs/9.5/static/continuous-archiving.html#BACKUP-ARCHIVING-WAL "However, archive_command can be changed with a configura

Re: [GENERAL] Question about wal files / pg_xlogs

2016-08-04 Thread Patrick B
> > >> > https://www.postgresql.org/docs/9.5/static/continuous-archiv > ing.html#BACKUP-ARCHIVING-WAL > > "However, archive_command can be changed with a configuration file reload." > > Cheers... I removed the IONICE command from the archive_command. However, did not see any difference. Any ide

Re: [GENERAL] Question about wal files / pg_xlogs

2016-08-04 Thread Adrian Klaver
On 08/04/2016 12:55 PM, Patrick B wrote: @Adrian, Seems to me the settings for nice and ionice above would, on a busy machine, slow down the transfer. Has there always been a notable time difference in the transfer or has it gotten worse over time? Yep... I also thought about that.

Re: [GENERAL] Question about wal files / pg_xlogs

2016-08-04 Thread Patrick B
@Adrian, > Seems to me the settings for nice and ionice above would, on a busy > machine, slow down the transfer. Has there always been a notable time > difference in the transfer or has it gotten worse over time? > > Yep... I also thought about that. Specially because the master is constantly ge

Re: [GENERAL] Question about wal files / pg_xlogs

2016-08-04 Thread Adrian Klaver
On 08/03/2016 07:59 PM, Patrick B wrote: Both machines have same timezone? Yes! Shouldn't be showing 2 hours before.. I just checked and both server has the same date / timezone How fast are you generating WALs? Check below please checkpoint_segments = 64 checkpoint_tim

Re: [GENERAL] Question about wal files / pg_xlogs

2016-08-03 Thread John R Pierce
On 8/3/2016 7:59 PM, Patrick B wrote: *postgresql.conf:* archive_command = 'exec nice -n 19 ionice -c 2 -n 7 archive_command.bash "%p" slave01 slave02' *archive_command.bash:* Basically we use TAR to ship through ssh: # we use tar over SSH as I don't fully trust scp's exit status.

Re: [GENERAL] Question about wal files / pg_xlogs

2016-08-03 Thread Venkata Balaji N
> > I use a bash script to ship them. The script hasn't being changed So > it isn't the problem. > > > *postgresql.conf:* > >> archive_command = 'exec nice -n 19 ionice -c 2 -n 7 archive_command.bash >> "%p" slave01 slave02' > > *archive_command.bash:* > > Basically we use TAR to ship through s

Re: [GENERAL] Question about wal files / pg_xlogs

2016-08-03 Thread Patrick B
> > >> > Both machines have same timezone? > Yes! Shouldn't be showing 2 hours before.. I just checked and both server has the same date / timezone > > How fast are you generating WALs? > Check below please checkpoint_segments = 64 > checkpoint_timeout = 5min > checkpoint_completion_target =

Re: [GENERAL] Question about wal files / pg_xlogs

2016-08-03 Thread Adrian Klaver
On 08/03/2016 07:21 PM, Patrick B wrote: Hi all, I'm currently using PostgreSQL 9.2. I noticed that the wal_files are being generated by the master well, no problems. But on the slaves, it seems to be a delay to the delivery of those wal_files. I got two slaves using streaming replication and w

[GENERAL] Question about wal files / pg_xlogs

2016-08-03 Thread Patrick B
Hi all, I'm currently using PostgreSQL 9.2. I noticed that the wal_files are being generated by the master well, no problems. But on the slaves, it seems to be a delay to the delivery of those wal_files. I got two slaves using streaming replication and wal files shipment from Master. *On the mas