Blz..entendi, como estou configurando para fazer um hot_standby, teria como zerar esses logs ? pelo que entendi, pode ter até arquivos que nao estao mais sendo utilizados.
2013/5/17 Fabrízio de Royes Mello <[email protected]> > > 2013/5/17 Douglas Fabiano Specht <[email protected]> > > > > Boa tarde Pessoal > > seguinte tenho configurado em checkpoint_segments=100 e > checkpoint_timeout = 15min > > ocorre que ao analisar a pasta pg_xlog, tenho la 203 arquivos de 16mb. > > nao deveria de ter apenas 100 no maximo? > > Não... veja o que diz um trecho da documentação extraido de [1] > > "There will always be at least one WAL segment file, and will normally not > be more than (2 + checkpoint_completion_target) * checkpoint_segments + 1 > or checkpoint_segments +wal_keep_segments + 1 files. Each segment file is > normally 16 MB (though this size can be altered when building the server). > You can use this to estimate space requirements for WAL. Ordinarily, when > old log segment files are no longer needed, they are recycled (renamed to > become the next segments in the numbered sequence). If, due to a short-term > peak of log output rate, there are more than 3 * checkpoint_segments + 1 > segment files, the unneeded segment files will be deleted instead of > recycled until the system gets back under this limit." > > Att, > > [1] http://www.postgresql.org/docs/current/static/wal-configuration.html > > -- > Fabrízio de Royes Mello > Consultoria/Coaching PostgreSQL > >> Blog sobre TI: http://fabriziomello.blogspot.com > >> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello > >> Twitter: http://twitter.com/fabriziomello > > _______________________________________________ > pgbr-geral mailing list > [email protected] > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > > -- Douglas Fabiano Specht
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
