Thread: Postgresql DB on a live cd

Postgresql DB on a live cd

From
Date:
Hi,

I'am trying to create a demo cd (knoppix) with a jdbc application.

This application uses a static (read-only, no insert, modify or delete) 200MB
postgresql db, so can't put pgsql/data/base and pgsql/data/pg_xlog in ramdisk.

postmaster fails to start because can't open the files in these two dirs with
read and write access.

The question is : can postmaster start only with read access ?

Any alternative solutions ?

Thank in advance,
Lucio


Re: Postgresql DB on a live cd

From
"jtaaribi"
Date:
http://www.varlena.com/varlena/GeneralBits/42.php

Regards

Inaki

-----Mensaje original-----
De: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org]En nombre de mail@iond.it
Enviado el: miércoles, 19 de noviembre de 2003 11:33
Para: pgsql-admin@postgresql.org
Asunto: [ADMIN] Postgresql DB on a live cd


Hi,

I'am trying to create a demo cd (knoppix) with a jdbc application.

This application uses a static (read-only, no insert, modify or delete)
200MB
postgresql db, so can't put pgsql/data/base and pgsql/data/pg_xlog in
ramdisk.

postmaster fails to start because can't open the files in these two dirs
with
read and write access.

The question is : can postmaster start only with read access ?

Any alternative solutions ?

Thank in advance,
Lucio


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)


Re: Postgresql DB on a live cd

From
Date:
> 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


Re: Postgresql DB on a live cd

From
Greg Spiegelberg
Date:
Why not have a static copy of the pg_clog on boot, copy it to a ramdisk
and point Postgres there?

Greg


mail@iond.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@postgresql.org)


--
Greg Spiegelberg
  Sr. Product Development Engineer
  Cranel, Incorporated.
  Phone: 614.318.4314
  Fax:   614.431.8388
  Email: gspiegelberg@Cranel.com
Cranel. Technology. Integrity. Focus.



Re: Postgresql DB on a live cd

From
Mailer
Date:
Alle 16:13, mercoledì 19 novembre 2003, hai scritto:
> Why not have a static copy of the pg_clog on boot, copy it to a ramdisk
> and point Postgres there?
>
> Greg

Hi, Greg

My problem is around base (70MB) and pg_xlog (115MB) dirs, and not pc_clog (20Kb) dir
that, as you also say, can be copied to the ramdisk.

How to redirect postgresql log files to /dev/null ?
Wandering around the net, I have read that wal can't be disabled.

Regards

Lucio