Re: Help Needed

On Mon, 27 Dec 2004 07:55:27 +0530 (IST), Ameya S. Sakhalkar
<ameya(at)cse(dot)iitb(dot)ac(dot)in> wrote:
>
> For my project (main memory DBMS), I have written a main memory filesystem.
> Idea is, the primary copy of data will reside in main memory. (Workable
> only for small size data, at most 2GB).
>
> Now, I want to plug this filesystem with Postgres, so that, instead of
> Unix filesystem, this main memory filesystem(MMFS) will now store the
> data.

I believe that all you need to do is to mount your filesystem somewhere,
and then tell postgres to use that directory for storing the database files.

1. Mount your filesystem to a directory, e.g /mnt/mem_drive
(possibly : mount -t mmfs /dev/mmfs /mnt/mem_drive)
2. export PG_DATA=/mnt/mem_drive
3. initdb
4. pg_ctl start

I hope this helps.

Adrian Maier

> I want to know, how to plug it with Postgres. i.e. whether replacing all
> calls to Unix filesystem by calls to MMFS is enough, or do I need to do
> something else/more. I am really a newbie to Postgres. So, can someone pls
> guide me, abt how should I go.