Re: [ADMIN] warm standby

2008-11-28 Thread Tom Lane
"Mark Steben" <[EMAIL PROTECTED]> writes: > I'm attempting a warm standby setup. I'm running Postgres 8.3 on both > master and slave. > Unfortunately the master is a 32 bit machine and the slave is a 64 bit > machine. You do need the same architecture on both ends. You might be able to run a 32

[ADMIN] warm standby

2008-11-28 Thread Mark Steben
I'm attempting a warm standby setup. I'm running Postgres 8.3 on both master and slave. Unfortunately the master is a 32 bit machine and the slave is a 64 bit machine. Both running Linux Redhat. After I bring in the master base file copy into the slave and attempt to Start postgres I get an '

Re: [ADMIN] PgAgent Job Scehduler is NOT running

2008-11-28 Thread Vishal Arora
Its located in Application Data folder. Date: Thu, 27 Nov 2008 21:12:23 -0800From: [EMAIL PROTECTED]: Re: [ADMIN] PgAgent Job Scehduler is NOT runningTo: [EMAIL PROTECTED]; [EMAIL PROTECTED]: [EMAIL PROTECTED] I searched but didn't find any pgpass.conf file. From: Vishal Arora <[EMAIL PR

Re: [ADMIN] NUMA architecture and PostgreSQL

2008-11-28 Thread lst_hoe02
Zitat von Fabricio <[EMAIL PROTECTED]>: Hi... I have an IBM server with NUMA architecture, two nodes with 4 CPU quad core and 64 GB of RAM each, and PostgrSQL 8.3.5. Is there any way to avoid the performance degradation when the load goes up and used the two nodes? I understand this per

Re: [ADMIN] PgAgent Job Scehduler is NOT running

2008-11-28 Thread Abdul Rahman
That's it! Arora your document (http://wiki.postgresql.org/wiki/Image:PgAgent_for_windows.doc) is better than the best. The error was of postgress user rights and nothing else. After granting rights to postgres Its really running well. Thanks. From: Vishal A