"Stéphane A. Schildknecht" stephane.schildknecht at postgresql.fr
Thu Jun 23 05:55:12 PDT 2011
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Le 23/06/2011 11:03, francescoboccacci at libero.it a écrit :
> Hi to all,
> i have a question for you. I'n using slony to replicate two databases.
> I run cluster script, after:
> 
> /usr/lib/postgresql/8.4/bin/slon sql_cluster_master_slave  "dbname=master 
> user=navmap" > slonmaster.log &
> /usr/lib/postgresql/8.4/bin/slon sql_cluster_master_slave "dbname=slave 
> user=navmap" > slonslave.log &
> 
> at the end subscribe script.
> 
> My question is:
> 
> the two log file grow up in size day by day. I like to clean up these files 
> and rebuild from scratch.
> Is there a slony command to do that or i have to create a script and run it 
> from crontab that delete these files?
> 

logrotate will do the trick.

I use syslog (configured through slon configuration file) and configured
logrotation through a file located in logrotate.d, which contains :

/var/log/slony/*.log {
  weekly
  rotate 2
  copytruncate
  delaycompress
  compress
  notifempty
  missingok
}



- -- 
Stéphane Schildknecht
Loxodata
Contact régional PostgreSQL

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk4DN68ACgkQA+REPKWGI0EOKACfcAJQUN8rxH2GnTJT6MGM+YCk
JugAn26AV8BCPJHlxq8rULoxvLW/et7Q
=qySi
-----END PGP SIGNATURE-----


More information about the Slony1-general mailing list