pg_logs and pg_variables Files

Started by Art Taylorabout 25 years ago2 messagesgeneral
Jump to latest
#1Art Taylor
taylor003a@yahoo.com

PostgreSQL gurus,

I am in the process of writing a technical book featuring PostgreSQL (among
other technologies). I would like to document the contents of the PGDATA
directory. There are a few files there that I haven't been able to figure out.
They are 'pg_logs' and 'pg_variables'. I can make an educated guess as to the
contents, but I would prefer to hear from those in the know about what these
files are used for.

Thanks,

-- Art Taylor

__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/

#2Bruce Momjian
bruce@momjian.us
In reply to: Art Taylor (#1)
Re: pg_logs and pg_variables Files

See my book, last chapter. pg_log is transaction log status.
pg_variable holds next object id and next transaction id.

http://www.postgresql.org/docs/awbook.html

PostgreSQL gurus,

I am in the process of writing a technical book featuring PostgreSQL (among
other technologies). I would like to document the contents of the PGDATA
directory. There are a few files there that I haven't been able to figure out.
They are 'pg_logs' and 'pg_variables'. I can make an educated guess as to the
contents, but I would prefer to hear from those in the know about what these
files are used for.

Thanks,

-- Art Taylor

__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026