2016-08-05 7:05 GMT+12:00 Enio <[email protected]>: > Pessoal, > > Preciso monitorar o Wal Archiving do PostgreSQL. Vi que na versão 9.4 > tem uma view pg_stat_archiver, mas em outras versões(8.4, 9.2, 9.3)? > > Alguém tem alguma dica. >
Nunca usei, mas parece ser bem interessante: https://bucardo.org/wiki/Check_postgres Checks how many WAL files exist in the *pg_xlog* directory, which is found > off of your *data_directory*, sometimes as a symlink to another physical > disk for performance reasons. This action must be run as a superuser, in > order to access the contents of the *pg_xlog* directory. The minimum > version to use this action is Postgres 8.1. The *--warning* and > *--critical* options are simply the number of files in the *pg_xlog* > directory. > What number to set this to will vary, but a general guideline is to put a > number slightly higher than what is normally there, to catch problems early. > Normally, WAL files are closed and then re-used, but a long-running open > transaction, or a faulty *archive_command* script, may cause Postgres to > create too many files. Ultimately, this will cause the disk they are on to > run out of space, at which point Postgres will shut down. > Example 1: Check that the number of WAL files is 20 or less on host "pluto" > check_postgres_wal_files --host=pluto --critical=20 > For MRTG output, reports the number of WAL files on line 1.
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
