Обсуждение: Looking at the contents of a WAL file

Поиск

Рассылки

Список Везде pgsql-general pgsql-hackers buildfarm-members pgadmin-hackers pgadmin-support pgsql-admin pgsql-advocacy pgsql-announce pgsql-benchmarks pgsql-bugs pgsql-chat pgsql-cluster-hackers pgsql-committers pgsql-cygwin pgsql-docs pgsql-hackers-pitr pgsql-hackers-win32 pgsql-interfaces pgsql-jdbc pgsql-jobs pgsql-novice pgsql-odbc pgsql-patches pgsql-performance pgsql-php pgsql-pkg-debian pgsql-pkg-yum pgsql-ports pgsql-rrreviewers pgsql-ru-general pgsql-sql pgsql-students pgsql-testers pgsql-translators pgsql-www psycopg

Период Все Вчера Неделя Месяц Полгода Год

Сортировка По дате, новые По дате, старые По релевантности

Искать

Looking at the contents of a WAL file

От

"Winning Runner"

Дата:

26 августа 2011 г., 20:27:00

Postgres 9.0 on Solaris 10.  Is there any meaningful way to check the contents of a WAL file?  I had a server run out of space and I wanted to check the WAL files to see what was going on that filled up the disk space.  No errors in the log file so whatever was running was running "error free" until the space was all used up.  Server is down right now.   I assume the WAL files are mostly binary files but I was able to cat the last WAL file to the strings utility and see some text which gave me some more clues.