Re: [ADMIN] Best option for expanding beyond 1 pg server in this situation

2008-11-25 Thread Scott Marlowe
On Tue, Nov 25, 2008 at 8:48 PM, Jamie Tufnell <[EMAIL PROTECTED]> wrote: > Hi, > > We have been wanting to HA our pgsql server for some time now. We're > actually reaching the limits of our current server now, so there is a > pressing need to do something to ease the load too. > > There are sever

[ADMIN] Best option for expanding beyond 1 pg server in this situation

2008-11-25 Thread Jamie Tufnell
Hi, We have been wanting to HA our pgsql server for some time now. We're actually reaching the limits of our current server now, so there is a pressing need to do something to ease the load too. There are several individual solutions to both of these problems. I was hoping I could get some advi

Re: [ADMIN] Separate Sessions?? (View data <-> Query tool)

2008-11-25 Thread Csaba Együd
""Scott Marlowe"" <[EMAIL PROTECTED]> a következoket írta üzenetében news:[EMAIL PROTECTED] 2008/11/25 Csaba Együd <[EMAIL PROTECTED]>: When I log in with PgAdmin I have to create the temp table manually. It's ok, and if I use the query tool i cansee query the views after creating the temp tabl

Re: [ADMIN] Separate Sessions?? (View data <-> Query tool)

2008-11-25 Thread Scott Marlowe
2008/11/25 Csaba Együd <[EMAIL PROTECTED]>: > Hi, > I'm administering a Pg8.3 database with PgAdmin3. > > The users need views "pre" filtered on a session based vairable wich is > stored in a temporary table. Immediately after logging into the database the > client software creates a temporary tabl

[ADMIN] Separate Sessions?? (View data <-> Query tool)

2008-11-25 Thread Csaba Együd
Hi, I'm administering a Pg8.3 database with PgAdmin3. The users need views "pre" filtered on a session based vairable wich is stored in a temporary table. Immediately after logging into the database the client software creates a temporary table and stores an idin that. The users query views wh

Re: [ADMIN] PgAgent Job Scehduler is NOT running

2008-11-25 Thread Abdul Rahman
Service is running. After getting frustrated I dropped the pgagent schema and reworked. But the result is same. ???. Even entries in the concerned pga_tables is also very clear. Perhaps the trigger is not working . From: Vishal Arora <[EMAIL PROTECTED]> To: [E