Re: Postgresql DB on a live cd

From: <mail(at)iond(dot)it>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgresql DB on a live cd
Date: 2003-11-19 13:45:36
Message-ID: 200311191445.36827.mail@iond.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> http://www.varlena.com/varlena/GeneralBits/42.php
> Regards
> Inaki

Thank you Inaki for the direction,

This is the interesting part :

--> log file -- this can be directed to /dev/null
--> There are ways to stop the writing to the log file and pgstat.stat, but pg_clog cannot be turned off.

Sorry for my questions but I'm a newbie postgresql user.

Real data are only in pgsql/data/base ?
Does postmaster open these files in read-write mode ?

What is defined as "log file" is in pgsql/data/pg_xlog ?
Here I have the biggest files and if these ones are only logs I could turning off them.
Please, can you give me any direction how to do it, or how to redirect them to /dev/null ?

I don't care about turning off pc_clog, can put it in ramdisk.

Thanks

Lucio

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Robert Treat 2003-11-19 14:56:06 Re: Point-in-time data recovery - v.7.4
Previous Message Dave Cramer 2003-11-19 13:32:36 Re: Point-in-time data recovery - v.7.4