Обсуждение: Help Needed

For my project (main memory DBMS), I hv 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 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.

_________________________________ Ameya S Sakhalkar, Sr. Postgraduate Student, CSE, C-720, H12, IIT Bombay. email:
ameya@cse.iitb.ac.inPhone: 9892252239 Visit me at: http://www.cse.iitb.ac.in/~ameya
 

On Mon, 27 Dec 2004 07:55:27 +0530 (IST), Ameya S. Sakhalkar
<ameya@cse.iitb.ac.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.