PSQLFS - PostgreSQL File System

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

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, "')");

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

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