Re: [GENERAL] wal_files from slave to another slave

Sorry guys.. just found the answer on the docs: https://www.postgresql.org/docs/9.2/static/warm-standby.html#Cascading-Replication (were trying to find it for a while lol) it is indeed possible to do that!

[GENERAL] wal_files from slave to another slave

Hi guys, can a slave server (streaming replication) send the wal_files to another slave, instead the master? If so, that would be done by setting the archive_mode = on and also a archive_command? I'm using PostgreSQL 9.2 Thanks! Patrick

Re: [GENERAL] reject

On Mon, Jun 27, 2016 at 9:21 AM, 유성열 wrote: > Please, I want to unsubscribe your email. Delete my mail address in your > mail list, please...OMG.. > You can do it by yourself here: https://www.postgresql.org/community/lists/subscribe/ There is an unsubscribe option. -- Michael

Re: [GENERAL] pg_archivecleanup - Increase time files are deleted

On Mon, Jun 27, 2016 at 6:42 AM, Melvin Davidson wrote: > >That means there will be at least 256 files before postgres delete them? > > Yes! Not exactly. To be more precise, for an instance generating WAL, the decision regarding the number of WAL segments to remove or recycled is done at the crea

[GENERAL] reject

Please, I want to unsubscribe your email. Delete my mail address in your mail list, please...OMG.. 네이버 메일앱에서 보냈습니다.

Re: [GENERAL] pg_archivecleanup - Increase time files are deleted

On Sun, Jun 26, 2016 at 7:39 PM, Ian Barwick wrote: > On 06/27/2016 06:33 AM, Patrick B wrote: > >> ...I'd like to have the wal_files stored for 24h, and then the >>> pg_archivecleanup could do its job and delete the files.. >>> >>> >>> *You cannot do that, but you can change the wal_keep_se

Re: [GENERAL] pg_archivecleanup - Increase time files are deleted

Apparently I can't do that via Postgres. So I've made a bash script to do the work for me. The script will only delete the wal_files older than 24h ( -mmin +1440 ) * It has been tested and it's working. *recovery.conf:* > archive_cleanup_command = 'exec nice -n 19 ionice -c 2 -n 7 > ../archiv

Re: [GENERAL] pg_archivecleanup - Increase time files are deleted

On 06/27/2016 06:33 AM, Patrick B wrote: ...I'd like to have the wal_files stored for 24h, and then the pg_archivecleanup could do its job and delete the files.. *You cannot do that, but you can change the wal_keep_segments

Re: [GENERAL] pg_archivecleanup - Increase time files are deleted

On Sun, Jun 26, 2016 at 5:33 PM, Patrick B wrote: > >> >> >...I'd like to have the wal_files stored for 24h, and then the >> pg_archivecleanup could do its job and delete the files.. >> >> >> *You cannot do that, but you can change the wal_keep_segments >>

Re: [GENERAL] pg_archivecleanup - Increase time files are deleted

> > > > >...I'd like to have the wal_files stored for 24h, and then the > pg_archivecleanup could do its job and delete the files.. > > > *You cannot do that, but you can change the wal_keep_segments >

Re: [GENERAL] pg_archivecleanup - Increase time files are deleted

On Sun, Jun 26, 2016 at 5:14 PM, Patrick B wrote: > Hi guys, > > I've got one MASTER and three SLAVES servers, running PostgreSQL 9.2. > > I had a problem with one of the masters, and because the wal_files aren't > kept for a long time, I had to re-sync all the DB. > If the wal_files were being k

[GENERAL] pg_archivecleanup - Increase time files are deleted

Hi guys, I've got one MASTER and three SLAVES servers, running PostgreSQL 9.2. I had a problem with one of the masters, and because the wal_files aren't kept for a long time, I had to re-sync all the DB. If the wal_files were being kept longer than they are now, I wouldn't have to re-sync (pg_bas