Thanks Craig for making me look like an idiot. I feel bad now.

When I posted I suspected that what you have just replied with was the
case.

I have some leaning to do on this.

Jeff

J Ottery wrote:
> Thanks Craig for making me look like an idiot. I feel bad now.
>
That wasn't my intent, so I'm sorry for making you feel bad about it. I
was just trying to stress the importance of only ever having one pg
instance using a data directory. If you're used to shared-access systems
it's a natural question, and the documentation:

http://www.postgresql.org/docs/8.3/s...g-cluster.html

doesn't explicitly spell out that it's a bad idea to have multiple Pg
servers accessing a database cluster.

--
Craig Ringer

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

On 11/04/2008 09:58, J Ottery wrote:
> Thanks Craig for making me look like an idiot. I feel bad now.
>
> When I posted I suspected that what you have just replied with was the
> case.

I'm sure that wasn't Craig's intent. I'd hazard a guess that you've been
using Access or a similar single-file-based DB where the you simply
point the front-end at the data file, and the front-end looks after
locking and concurrency (I think - I may be way off on this). PostgreSQL
and other "heavyweight" DBMSs require a different mind-set - think of
the server as a black box at which you fire off your SQL and get back
the results.

HTH,

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

J Ottery wrote:
> Thanks Craig for making me look like an idiot. I feel bad now.

You don't look like an idiot, you look like someone who has just learned
something. If we don't learn from our mistakes, then we are idiots...

--
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general