Re: serverless postgresql

From: Enrico Weigelt <weigelt(at)metux(dot)de>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: serverless postgresql
Date: 2004-01-13 22:17:13
Message-ID: 20040113221713.GA28559@nibiru.metux.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

* Jeff Bowden <jlb(at)houseofdistraction(dot)com> [2004-01-13 13:38:02 -0800]:

> For ease of configuration and other reasons, I would like for my
> single-user GUI app to be able to use postgresql in-process as a library
> accessing a database created in the users home directory. I think I
> could possibly get what I want by launching a captive copy of postmaster
> with appropriate args but it seems conceptually cleaner to not have a
> seperate process at all. Has anyone tried to do anything like this?

hmm, i've also played around a little bit w/ postgresql standalone.
you could also do nice things like calling postmaster from inetd ;-)

but I dont think you really wanna have the postmaster in the same
process w/ your application, since it relies on forks, signals,
mmap() and some other things which directly affect the process control -
this probably infers with your application. On the application side
you cant really control, what it does, so it sounds quite difficult.
Having the postmaster in a separate process connected by a socket or
pty seems to be the better solution.

cu
--
---------------------------------------------------------------------
Enrico Weigelt == metux IT services

phone: +49 36207 519931 www: http://www.metux.de/
fax: +49 36207 519932 email: contact(at)metux(dot)de
cellphone: +49 174 7066481
---------------------------------------------------------------------
Diese Mail wurde mit UUCP versandt. http://www.metux.de/uucp/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alex Satrapa 2004-01-13 22:25:50 Re: Drawbacks of using BYTEA for PK?
Previous Message Robert Treat 2004-01-13 21:46:52 Re: Nested transaction - I am a bank ??