Postgres Pro
Downloads
Home   >   mailing lists

Thread: PSQLFS - PostgreSQL File System

PSQLFS - PostgreSQL File System

From
Edward Macnaghten
Date:
Hi

If this is not the right list for this please forgive me, and point me
to the right one.

For a bit of fun I have created a file system, that looks like a normal
mounted file tree to the user, but who's data is stored on a PostgreSQL
database server.  It uses LUFS to do it.

Like LUFS - it is released under the GPL.

For those interested it can be got from http://www.edlsystems.com/psqlfs

Enjoy


--
Edward macnaghten <eddy@eddy.me.uk>
http://www.eddy.me.uk

Re: PSQLFS - PostgreSQL File System

From
David Garamond
Date:
Edward Macnaghten wrote:
> If this is not the right list for this please forgive me, and point me
> to the right one.
>
> For a bit of fun I have created a file system, that looks like a normal
> mounted file tree to the user, but who's data is stored on a PostgreSQL
> database server.  It uses LUFS to do it.
>
> Like LUFS - it is released under the GPL.
>
> For those interested it can be got from http://www.edlsystems.com/psqlfs

Cool.

I know that Oracle has had something like this for years. Does it
actually get used for "real world" purposes?

--
dave

Re: PSQLFS - PostgreSQL File System

From
Tatsuo Ishii
Date:
> If this is not the right list for this please forgive me, and point me
> to the right one.
>
> For a bit of fun I have created a file system, that looks like a normal
> mounted file tree to the user, but who's data is stored on a PostgreSQL
> database server.  It uses LUFS to do it.
>
> Like LUFS - it is released under the GPL.
>
> For those interested it can be got from http://www.edlsystems.com/psqlfs

Nice work!

I'm writing an article and am evaluating psqlfs. I found a minor bug:
rmdir does not work. Here are patches supposed to fix the problem.

*** pgsqlcmd.c.orig    2004-09-17 20:15:23.000000000 +0900
--- pgsqlcmd.c    2004-09-17 20:15:37.000000000 +0900
***************
*** 499,505 ****
      string_conc_l(str, dir_number);
      string_concat(str, ", '");
      string_concat(str, es);
!     string_concat(str, "', ");
      string_conc_l(str, file_number);
      string_concat(str, "')");

--- 499,505 ----
      string_conc_l(str, dir_number);
      string_concat(str, ", '");
      string_concat(str, es);
!     string_concat(str, "', '");
      string_conc_l(str, file_number);
      string_concat(str, "')");

Re: PSQLFS - PostgreSQL File System

From
Eddy Macnaghten
Date:
Thanks

(Sorry about the delay)

I have put the patch in and it is at http://www.edlsystems.com/psqlfs

Yours

Eddy


On Fri, 2004-09-17 at 12:32, Tatsuo Ishii wrote:
> > If this is not the right list for this please forgive me, and point me
> > to the right one.
> >
> > For a bit of fun I have created a file system, that looks like a normal
> > mounted file tree to the user, but who's data is stored on a PostgreSQL
> > database server.  It uses LUFS to do it.
> >
> > Like LUFS - it is released under the GPL.
> >
> > For those interested it can be got from http://www.edlsystems.com/psqlfs
>
> Nice work!
>
> I'm writing an article and am evaluating psqlfs. I found a minor bug:
> rmdir does not work. Here are patches supposed to fix the problem.
>
> *** pgsqlcmd.c.orig    2004-09-17 20:15:23.000000000 +0900
> --- pgsqlcmd.c    2004-09-17 20:15:37.000000000 +0900
> ***************
> *** 499,505 ****
>       string_conc_l(str, dir_number);
>       string_concat(str, ", '");
>       string_concat(str, es);
> !     string_concat(str, "', ");
>       string_conc_l(str, file_number);
>       string_concat(str, "')");
>
> --- 499,505 ----
>       string_conc_l(str, dir_number);
>       string_concat(str, ", '");
>       string_concat(str, es);
> !     string_concat(str, "', '");
>       string_conc_l(str, file_number);
>       string_concat(str, "')");
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
--
Edward A. Macnaghten
http://www.edlsystems.com

Re: PSQLFS - PostgreSQL File System

From
Edward Macnaghten
Date:
Thanks

(Sorry about the delay getting back... )

I have put this in and it is on my server
(http://www.edlsystems.com/psqlfs)

Eddy

On Fri, 2004-09-17 at 12:32, Tatsuo Ishii wrote:
> > If this is not the right list for this please forgive me, and point me
> > to the right one.
> >
> > For a bit of fun I have created a file system, that looks like a normal
> > mounted file tree to the user, but who's data is stored on a PostgreSQL
> > database server.  It uses LUFS to do it.
> >
> > Like LUFS - it is released under the GPL.
> >
> > For those interested it can be got from http://www.edlsystems.com/psqlfs
>
> Nice work!
>
> I'm writing an article and am evaluating psqlfs. I found a minor bug:
> rmdir does not work. Here are patches supposed to fix the problem.
>
> *** pgsqlcmd.c.orig    2004-09-17 20:15:23.000000000 +0900
> --- pgsqlcmd.c    2004-09-17 20:15:37.000000000 +0900
> ***************
> *** 499,505 ****
>       string_conc_l(str, dir_number);
>       string_concat(str, ", '");
>       string_concat(str, es);
> !     string_concat(str, "', ");
>       string_conc_l(str, file_number);
>       string_concat(str, "')");
>
> --- 499,505 ----
>       string_conc_l(str, dir_number);
>       string_concat(str, ", '");
>       string_concat(str, es);
> !     string_concat(str, "', '");
>       string_conc_l(str, file_number);
>       string_concat(str, "')");
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
--
Edward macnaghten <eddy@eddy.me.uk>
http://www.eddy.me.uk