Обсуждение: 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
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)
> 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
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.
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