From: Jeroen T. Vermeulen <jtv@xs4all.nl>
To: Murray Cumming <murrayc@murrayc.com>
Cc: pgsql-interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: Embedding postgresql in my application
Date: Sat, 16 Dec 2006 18:55:51 +0700 (ICT)
Message-ID: <6147.125.24.243.222.1166270151.squirrel@webmail.xs4all.nl> (raw)
In-Reply-To: <1166269673.5923.17.camel@localhost.localdomain>
References: <1166225144.12609.2.camel@localhost.localdomain>
<20058.125.24.243.222.1166249768.squirrel@webmail.xs4all.nl>
<1166267606.5923.11.camel@localhost.localdomain>
<9856.125.24.243.222.1166268615.squirrel@webmail.xs4all.nl>
<1166269673.5923.17.camel@localhost.localdomain>
On Sat, December 16, 2006 18:47, Murray Cumming wrote:
> Well, I want multiple users, from multiple networked computers to be
> able to use the database simultaneously. TCP/IP seems the logical way to
> do this.
Ah--I had not understood that you wanted to access the database remotely.
But in that case, in what sense would the database be "embedded" in your
application!?
>> Yes. Except for the createuser: if user X owns these directories and
>> postgres is started under user identity X, then X is automatically
>> (well,
>> by default) the superuser for that database. No need to create it.
>
> Are we talking about a Linux user or Postgres user as "user X"? I
> thought they were separate lists of users.
They are. But if you're on a local connection, as I had been assuming,
you can couple them which is often both safe and convenient.
>> There's the configuration files, of course, in /etc/postgresql*. You'll
>> have to look up the necessary options to replace those with local
>> versions.
>
> Is there no way to put the configuration file in the directory too?
Certainly. You'll just have to look up the necessary options to replace
the default configuration files with your local versions.
Jeroen
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: jtv@xs4all.nl, murrayc@murrayc.com
Subject: Re: Embedding postgresql in my application
In-Reply-To: <6147.125.24.243.222.1166270151.squirrel@webmail.xs4all.nl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox