[ADMIN] Contents of WAL files

[gabriel12345]

I was reading Chapter 29 of the postgres manual about WAL files and couldn't
find any specific information about what is actually in the WAL files, per
se.

To be as specific as possible, can anyone provide more detail about what
content is actually written into these files?

http://developer.postgresql.org/pgdocs/postgres/wal.html
http://developer.postgresql.org/pgdocs/postgres/wal.html



--
View this message in context: http://postgresql.1045698.n5.nabble.com/Contents-of-WAL-files-tp4892578p4892578.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

[gabriel12345]

Bump. I am looking for an informed reply on what are the actual contents that
are written inside of the WAL files. Thanks.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Contents-of-WAL-files-tp4892578p4893138.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

[gabriel12345]

Why is my post still not accepted yet, what's the problem?

Please reply.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Contents-of-WAL-files-tp4892578p4896892.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

[Cliff Pratt]

I think that you misunderstand the basics of this list. There is not a
bunch of people designated and waiting to answer your questions. It is
a self-help list. People come here to ask questions and *hope* that
someone, somewhere has an answer. Some people come here to help out by
answering peoples' questions out of the goodness of their hearts.

Many times you may ask a question and no one will be able to answer
it, though they may direct you in ways which they think might help you
to find the answer.

Cheers,

Cliff

Post by gabriel12345
Why is my post still not accepted yet, what's the problem?
Please reply.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Contents-of-WAL-files-tp4892578p4896892.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
http://www.postgresql.org/mailpref/pgsql-admin

[Kevin Grittner]

Post by gabriel12345
I was reading Chapter 29 of the postgres manual about WAL files
and couldn't find any specific information about what is actually
in the WAL files, per se.
To be as specific as possible, can anyone provide more detail
about what content is actually written into these files?

I'm not sure there's a level of detail available between that and
the links below.

http://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/backend/access/transam/README;h=c0c9aeaa318380908079cbb0f8f79e848cd105a9;hb=master#l387

http://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/backend/access/transam/xlog.c;h=befb507047721bcde868a5682b97a3829cc85b81;hb=master

http://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/include/access/xlog_internal.h;h=4eaa243948be5023707e9d35d04504a0ebdf6416;hb=master

-Kevin