Re: Master slave replication

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi Fabio, 

Thanks for your comment but my px_xlog, log_archive and data_dir all three are in the different-different partition.
pls see the attached snapshot 
image.png

On Wed, Sep 19, 2018 at 3:44 PM Fabio Pardi <f.pardi@xxxxxxxxxxxx> wrote:
Hi Arvind,

From what you describe, looks like you are sharing WAL and archive under the same partition. It is not good idea.

A lot depends from how much disk space you have available and how you setup the disks, but from what i see, max_wal_size in your configuration is quite big. I would set it to something smaller, and make sure that archive, data and pg_xlog are on different partitions or better, disks

https://www.postgresql.org/docs/9.5/static/runtime-config-wal.html#GUC-MAX-WAL-SIZE

regards,

fabio pardi



On 19/09/18 11:54, arvind chikne wrote:
Hi All, 

I have successfully configured the master slave replication through WAL, but after some time my px_xlog and log_archive gets full is there any option to set the limit for the same 


Error
cp: error writing '/var/lib/postgresql/9.5/main/log_archive/00000001000002E0000000D5': No space left on device
2018-09-19 15:19:19 IST [15642-34394] LOG:  archive command failed with exit code 1
2018-09-19 15:19:19 IST [15642-34395] DETAIL:  The failed archive command was: cp pg_xlog/00000001000002E0000000D5 /var/lib/postgresql/9.5/main/log_archive/00000001000002E0000000D5
cp: error writing '/var/lib/postgresql/9.5/main/log_archive/00000001000002E0000000D5': No space left on device
2018-09-19 15:19:20 IST [15642-34396] LOG:  archive command failed with exit code 1
2018-09-19 15:19:20 IST [15642-34397] DETAIL:  The failed archive command was: cp pg_xlog/00000001000002E0000000D5 /var/lib/postgresql/9.5/main/log_archive/00000001000002E0000000D5
2018-09-19 15:19:20 IST [15642-34398] WARNING:  archiving transaction log file "00000001000002E0000000D5" failed too many times, will try again later
cp: error writing '/var/lib/postgresql/9.5/main/log_archive/00000001000002E0000000D5': No space left on device
2018-09-19 15:19:24 IST [15642-34399] LOG:  archive command failed with exit code 1
2018-09-19 15:19:24 IST [15642-34400] DETAIL:  The failed archive command was: cp pg_xlog/00000001000002E0000000D5 /var/lib/postgresql/9.5/main/log_archive/00000001000002E0000000D5

pls see my postgres.conf
max_wal_size = 100GB
archive_mode = on
archive_command = 'cp %p /var/lib/postgresql/9.5/main/log_archive/%f'
max_wal_senders = 5  
wal_keep_segments = 32 
hot_standby = on

My recovery.conf
standby_mode = 'on'
primary_conninfo = 'host=XXX.XXX.XXX.XXX port=5432 user=rep password=REP'

trigger_file = '/tmp/postgresql.trigger.5432'
restore_command = 'cp /var/lib/postgresql/9.5/main/log_archive/%f "%p"'
archive_cleanup_command = 'pg_archivecleanup /var/lib/postgresql/9.5/main/log_archive/ %r'


--
Thanks & Regards
Arvind rao chikne
9818979986
Think Green!!! Please consider your environmental responsibility before printing this e-mail




--
Thanks & Regards
Arvind rao chikne
9818979986
Think Green!!! Please consider your environmental responsibility before printing this e-mail


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux