Hi,

After reading an article about pgfs:
http://www.linuxjournal.com/article.php?sid=1383
I can't find pgfs, and it seems the author had not maintain it for a
long time. Would anyone know any other project do the same thing?
Thanks.

- Kevin


24 Apr 2003 18:18:27 +0800
Kevin Lo <kevlo@kevlo.org>
Postgresql Filesystem
Kevin Lo wrote:
> After reading an article about pgfs:
> http://www.linuxjournal.com/article.php?sid=1383
> I can't find pgfs, and it seems the author had not maintain it for a
> long time. Would anyone know any other project do the same thing?

With *somewhat* different intent are:
  http://sourceforge.net/projects/sqlfs/
  http://www.relex.ru/~yarick/

They are trying to provide a mapping of a DBMS onto a filesystem which
is a neat-but-weird idea...

Intentionally similar:
  http://www.netcraft.com.au/geoffrey/katie/

Katie is consciously reminiscent of Clearcase, mounting a development
repository via NFS, storing things in a PostgreSQL database.
--
output = reverse("moc.enworbbc@" "enworbbc")
http://cbbrowne.com/info/textversion.html
"prepBut nI vrbLike adjHungarian! qWhat's artThe adjBig nProblem?"
-- Alec Flett


Thu, 24 Apr 2003 07:26:39 -0400
Christopher Browne <cbbrowne@cbbrowne.com>
Re: Postgresql Filesystem 
Please forgive an unrelated question.  It's totally a sign of respect 
for some gues who know something!

I'm looking for an OSS monitor watchdog program.  Watching 
servers/services for signes of life.  Emailing and sending pages when 
dead.  Prefereably with a module for checking PostgreSQL is up and 
serving queries...

If any members have experience of something compitent, I would be very 
greatful.

Thanks again,

Ben.


Thu, 24 Apr 2003 12:49:57 +0000
Ben Clewett <B.Clewett@roadrunner.uk.com>
Unrelated question
On Thu, Apr 24, 2003 at 12:49:57PM +0000, Ben Clewett wrote:
> 
> I'm looking for an OSS monitor watchdog program.  Watching 
> servers/services for signes of life.  Emailing and sending pages when 
> dead.  Prefereably with a module for checking PostgreSQL is up and 
> serving queries...

You could try Little Brother, which also happens to run on top of
postgres.  Checking a database server can be as easy as writing a
command line to execute: ssh mydbserver psql -c 'select 1'

Little Brother is available from sourceforge.


Jeroen


Thu, 24 Apr 2003 15:39:13 +0200
"Jeroen T. Vermeulen" <jtv@xs4all.nl>
Re: Unrelated question
Ben Clewett kirjutas N, 24.04.2003 kell 15:49:
> Please forgive an unrelated question.  It's totally a sign of respect 
> for some gues who know something!
> 
> I'm looking for an OSS monitor watchdog program.  Watching 
> servers/services for signes of life.  Emailing and sending pages when 
> dead.  Prefereably with a module for checking PostgreSQL is up and 
> serving queries...
> 
> If any members have experience of something compitent, I would be very 
> greatful.

High-Availability Linux Project at 

http://perens.com/Slides/HP-World-2001/HighAvailability/linux-ha.org/

has a section 'Monitoring and Administration Software for Linux'.

You could check there and report if some support PostgreSQL.

----------------
Hannu


24 Apr 2003 16:40:35 +0300
Hannu Krosing <hannu@tm.ee>
Re: Unrelated question
Christopher Browne wrote:
> Kevin Lo wrote:
> > After reading an article about pgfs:
> > http://www.linuxjournal.com/article.php?sid=1383
> > I can't find pgfs, and it seems the author had not maintain it for a
> > long time. Would anyone know any other project do the same thing?
> 
> With *somewhat* different intent are:
>   http://sourceforge.net/projects/sqlfs/
>   http://www.relex.ru/~yarick/
> 
> They are trying to provide a mapping of a DBMS onto a filesystem which
> is a neat-but-weird idea...

I've tried sqlfs, it doesn't compile. I checked web cvs of sqlfs, the
author hasn't commit any thing about ten months :-(

> Intentionally similar:
>   http://www.netcraft.com.au/geoffrey/katie/
> 
> Katie is consciously reminiscent of Clearcase, mounting a development
> repository via NFS, storing things in a PostgreSQL database.
> --
> output = reverse("moc.enworbbc@" "enworbbc")
> http://cbbrowne.com/info/textversion.html
> "prepBut nI vrbLike adjHungarian! qWhat's artThe adjBig nProblem?"
> -- Alec Flett

- Kevin


25 Apr 2003 10:01:51 +0800
Kevin Lo <kevlo@kevlo.org>
Re: Postgresql Filesystem