When traffic goes up, my webserver creates multiple instances of
postgresql.exe. At some basic level, aren't they similar to Oracle's RAC
"clusters", except that they are not aware of each other? Does this mean
that if I were to create copies of postgresql.exe beforehand and somehow
split traffic t
On Tue, Mar 25, 2008 at 2:24 PM, Thomas Kellerer <[EMAIL PROTECTED]> wrote:
> Bill Wordsworth wrote on 25.03.2008 19:16:
> > When traffic goes up, my webserver creates multiple instances of
> > postgresql.exe. At some basic level, aren't they similar to Oracle's
...resending, email didn't go through.
On Tue, Jul 22, 2008 at 1:02 PM, Bill Wordsworth
<[EMAIL PROTECTED]> wrote:
> Is this recommended?
>
> pg_query("begin transaction read write;", $connection);
> if(pg_transaction_status($connection) == 2) {
>
Is this recommended?
pg_query("begin transaction read write;", $connection);
if(pg_transaction_status($connection) == 2) {
pg_query("insert...;", $connection);
pg_query("insert...;", $connection);
pg_query("insert...;", $connection);
}
pg_query("commit transaction;", $conne
Thanks Chris and Karsten. I still don't quite understand why invalid
state/record-mismatch would also not trigger auto rollback. How can I
even include something *outside* a transaction *inside* it- shouldn't
everything between "begin" and "end" be subject to auto rollback no
matter what?
Also wha
Obviously he is a newbie out of the woods- couldn't make a connection
and print results something that the rest of us have been doing for
years. It is newbies like him and fan-boys of Ruby/Python/Perl who
give PHP a bad name. But I fail to understand the little animosity
within some PostgreSQL user
On Fri, Jul 25, 2008 at 4:29 PM, Bill Wordsworth
<[EMAIL PROTECTED]> wrote:
> years. It is newbies like him and fan-boys of Ruby/Python/Perl who
> give PHP a bad name. But I fail to understand the little animosity
> within some PostgreSQL users to PHP- is it the LAMP stack?
On Fr
Is there any GUI for master-slave (I prefer CLI too)?
Are there any PostgreSQL-specific detailed videos that clearly
illustrate replication, PITR, failover, load-balance, backup etc (I
need it for a pitch)?
Any recommended commercial off-the-shelf/plug-and-play type products
or (hosted? (SimpleDB
Since it supports master-slave with Slony, has anyone had good
experience using phpPgAdmin for master-slave? Not much in docs...
On Wed, Aug 6, 2008 at 2:59 PM, Bill Wordsworth
<[EMAIL PROTECTED]> wrote:
> Is there any GUI for master-slave (I prefer CLI too)?
>
> Are there any Post
