Re: [ADMIN] increased load on server

2011-02-13 Thread Shrirang Chitnis
Hi, I had encountered this problem when there were a large number of writes on the disk (the operation involved bulk imports - read and writes) and disk configuration at that point of time showed latency in write operations - and inturn slowing down the reads. The problem was resolved with

Re: [ADMIN] how do you manage postgres 9's postgres process's memory

2011-02-13 Thread Keith Gabryelski
On Sun, Feb 13, 2011 at 9:57 AM, Kevin Grittner kevin.gritt...@wicourts.gov wrote: Keith Gabryelski ke...@fluentmobile.com wrote: here is an example of one process's growth over time -- USER PID %CPU %MEMVSZ RSS postgres 20533 0.0 0.3 647388 52216 [...] postgres 20533

Re: [ADMIN] how do you manage postgres 9's postgres process's memory

2011-02-13 Thread Benjamin Krajmalnik
Keith, there are 2 excellent books. I purchased them a few weeks ago as I was about to migrate all of my infrastructure to new hardware, and they have been invaluable. Simon, Hannu, and Greg did an awesome job. I ordered some massive servers, and in the course of benchmarking them following

Re: [ADMIN] Cascading Recovery

2011-02-13 Thread Scott Mead
On Sun, Feb 13, 2011 at 10:35 AM, Selva manickaraja mavle...@gmail.comwrote: Any updates? You can't use any wal based replication like that. When a node is in recovery mode, it doesn't log. --Scottie -- Forwarded message -- From: Selva manickaraja mavle...@gmail.com

Re: [ADMIN] Cascading Recovery

2011-02-13 Thread Selva manickaraja
Thank you for the info. On Mon, Feb 14, 2011 at 5:53 AM, Scott Mead sco...@openscg.com wrote: On Sun, Feb 13, 2011 at 10:35 AM, Selva manickaraja mavle...@gmail.comwrote: Any updates? You can't use any wal based replication like that. When a node is in recovery mode, it doesn't log.

Re: [ADMIN] how do you manage postgres 9's postgres process's memory

2011-02-13 Thread Greg Smith
Benjamin Krajmalnik wrote: I ordered some massive servers, and in the course of benchmarking them following their instructions it exposed apparent hardware issues -- so the 2 massive servers as well as one of the smaller ones got shipped back to the supplier for them to check it out. Had I

[ADMIN] Delaying Recovery

2011-02-13 Thread Selva manickaraja
Dear All, We had managed to setup and test the Continous Recovery of a secondary machine. What we need to achieve is for it to recover as primary in the event that primary fails. We know that we can use the trigger_file setting to fail over. However we understand that sometimes network connection

Re: [ADMIN] Delaying Recovery

2011-02-13 Thread Scott Mead
On Sun, Feb 13, 2011 at 10:19 PM, Selva manickaraja mavle...@gmail.comwrote: Dear All, We had managed to setup and test the Continous Recovery of a secondary machine. What we need to achieve is for it to recover as primary in the event that primary fails. We know that we can use the

[ADMIN] How to uninstall Postgres_Plus_Standard_Server?

2011-02-13 Thread Guenther Boelter
Hello! I few month ago I have tried the Postgres Plus Standard Server 8.4 (downloaded from http://www.enterprisedb.com/) on a Fedora 13 machine. It's not bad, but in my obinion there are to many 'toys' included. Means, I'm back to my PostgreSQL Standard edition now, available from Fedora. My

[ADMIN] Postgresql 9.0 (pgxs.mk)

2011-02-13 Thread Jayaraj Nagaraj
Hi, I have installed Posgresql 9.0 onto my Ubuntu 10.04 system, and runs perfectly. I installed it via the Ubutu repo (apt-get install). However, I am trying to get the PgPool working as well. I am trying 'make' one of the component from the PgPool package, and it returned me this error:-