Re: [ADMIN] Load Balancing/Multiple Postgres Machines

2004-11-29 Thread Iain
Hi, I have been considering this in my spare time for a little while too. Joshua already mentioned slony and pgpool, and you may want to look at heartbeat too, though I don't know if it is strictly neccessary in a slony/pgpoos installation. My focus is more on replication for high availability a

Re: [ADMIN] Load Balancing/Multiple Postgres Machines

2004-11-29 Thread Darcy Buskermolen
On November 29, 2004 11:30 am, Joshua D. Drake wrote: > Adile Abbadi wrote: > > Hi all, > > > > Not sure if this has been asked before - it probably has been - but I > > figure its probably just easier if I ask so my question is this: > > > > How easy is it - or rather is it possible to create mult

Re: [ADMIN] Load Balancing/Multiple Postgres Machines

2004-11-29 Thread Joshua D. Drake
Adile Abbadi wrote: Hi all, Not sure if this has been asked before - it probably has been - but I figure its probably just easier if I ask so my question is this: How easy is it - or rather is it possible to create multiple instances of the same db on multiple machines? We are currently running a v

[ADMIN] Load Balancing/Multiple Postgres Machines

2004-11-29 Thread Adile Abbadi
Hi all,   Not sure if this has been asked before - it probably has been - but I figure its probably just easier if I ask so my question is this:   How easy is it - or rather is it possible to create multiple instances of the same db on multiple machines?   We are currently running a very h

[ADMIN] Create and execute a Pass through Query

2004-11-29 Thread EXT-Ross, Norman
Hi, I have a requirement to demonstrate a simple Pass Through Query in PostgreSQL. This might be to a database on the same server, or to a database on a different server. I am not finding information to create and process Pass Through Queries using PostgreSQL. Any help will be appreciated. Th