From: | Greg Spiegelberg <gspiegelberg(at)cranel(dot)com> |
---|---|
To: | mail(at)iond(dot)it |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Postgresql DB on a live cd |
Date: | 2003-11-19 15:13:35 |
Message-ID: | 3FBB889F.1050404@cranel.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Why not have a static copy of the pg_clog on boot, copy it to a ramdisk
and point Postgres there?
Greg
mail(at)iond(dot)it wrote:
>>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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
--
Greg Spiegelberg
Sr. Product Development Engineer
Cranel, Incorporated.
Phone: 614.318.4314
Fax: 614.431.8388
Email: gspiegelberg(at)Cranel(dot)com
Cranel. Technology. Integrity. Focus.
From | Date | Subject | |
---|---|---|---|
Next Message | Mailer | 2003-11-19 15:26:43 | Re: Postgresql DB on a live cd |
Previous Message | Robert Treat | 2003-11-19 14:56:06 | Re: Point-in-time data recovery - v.7.4 |