Обсуждение: PSQLFS - PostgreSQL File System
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
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) 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
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