Re: [GENERAL] Clustering postgresql

2004-09-12 Thread Devrim GUNDUZ
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Mon, 6 Sep 2004, [ISO-8859-1] Björn Voigt wrote: has postgresql the functionality for clustering, load balancing and failover. I have to setup two redundant web-servers with and want run a dbms cluster on this machines. My webapps should only see

Re: [GENERAL] View efficiency questions

2004-09-12 Thread Tom Lane
Phil Endecott <[EMAIL PROTECTED]> writes: > Instead it looks as if the functions are applied to every row, i.e. V is > completely built, and then the one row is selected. This would depend very largely on the details of V and on the details of the calling query ... not to mention which Postgres v

[GENERAL] LOG: failed to commit transaction_isolation

2004-09-12 Thread Michael Fuhr
PostgreSQL 8.0.0beta2 (CVS) Solaris 9 I've noticed the following message in the server's logs: LOG: failed to commit transaction_isolation The log message appears if I issue a SET TRANSACTION ISOLATION LEVEL and later do a ROLLBACK. For example: BEGIN; SET TRANSACTION ISOLATION LEVEL SERIALIZA

[GENERAL] Fwd: Network problem

2004-09-12 Thread DU
OK, everyone who is beating their head against a wall and/or having a heart attack can stop now. I was editing backup copies I had made of the conf files. Sorry. It works once I do it right. -- Forwarded message -- From: DU <[EMAIL PROTECTED]> Date: Sun, 12 Sep 2004 10:13:46 -04