Обсуждение: PostgresSQL on a networked drive with multiple users
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/static/creating-cluster.html doesn't explicitly spell out that it's a bad idea to have multiple Pg servers accessing a database cluster. -- Craig Ringer
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 ------------------------------------------------------------------
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