[ADMIN]

2011-05-20 Thread Alan Gutierrez
-- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] pg_archivecleanup with multiple slaves

2011-05-20 Thread Ben Lancaster
Hi, First post, forgive me if this is better suited to pgsql-general. I've got streaming replication set up with two slave servers (PostgreSQL 9.0 on Ubuntu 10.04 LTS). The master pushes the WAL to an NFS export, which is in turn mounted on and picked up by the two slaves. The problem I have i

Re: [ADMIN] pg_archivecleanup with multiple slaves

2011-05-20 Thread Tim
I think you are using Log-Shipping not Streaming-Replication http://www.postgresql.org/docs/9.0/static/different-replication-solutions.html I would just make 2 copies of the WAL file one for each slave in different folders. That way if one slave is offline for a period of time it can catch up when

[ADMIN] LDAP Authentication

2011-05-20 Thread Teguh R
Hi, My first post, new to postgresql, forgive me if this is better suited to other postgresql mailing list. I would like to ask about LDAP authentication configuration. It is said in documentation that first the installation compiled with LDAP option. I use installer from official postresql

Re: [ADMIN] LDAP Authentication

2011-05-20 Thread Raghavendra
Here is the setting information on pg_service.conf http://www.postgresql.org/docs/9.0/interactive/libpq-pgservice.html --- Best Regards, Raghavendra EnterpriseDB Corporation Blog: http://raghavt.blogspot.com/ On Fri, May 20, 2011 at 6:01 PM, Teguh R wrote: > Hi, > > My first post, new to pos

Re: [ADMIN] pg_archivecleanup with multiple slaves

2011-05-20 Thread Kevin Grittner
Tim wrote: > I would just make 2 copies of the WAL file one for each slave in > different folders. > That way if one slave is offline for a period of time it can > catch up when it comes back online. If you used hard links, that wouldn't even take any extra disk space (beyond the directory spa

Re: [ADMIN] LDAP Authentication

2011-05-20 Thread Mark Johnson
I too have been looking into this as a new user of PostgreSQL 9.0. 1. Before you install PostgreSQL you might want to verify the LDAP packages are installed. For example, on CentOS I might run "yum list openldap openldap-devel". 2. If you install PostgreSQL from source code, one of the steps is

Re: [ADMIN] pg_archivecleanup with multiple slaves

2011-05-20 Thread Ben Lancaster
On 20 May 2011, at 12:53, Tim wrote: > I think you are using Log-Shipping not Streaming-Replication > http://www.postgresql.org/docs/9.0/static/different-replication-solutions.html I'm using streaming replication with log shipping as a fallback as per walkthrough here: http://brandonkonkle.com/

Re: [ADMIN] pg_archivecleanup with multiple slaves

2011-05-20 Thread Fujii Masao
On Fri, May 20, 2011 at 7:59 PM, Ben Lancaster wrote: > The problem I have is that pg_archivecleanup (running on one of the slaves) > was removing WAL logs before the other slave had picked up the changes, thus > breaking replication for the second slave. As an interim fix, I simply > disabled

[ADMIN] Who is causing all this i/o?

2011-05-20 Thread Craig James
Our development server (PG 8.4.4 on Ubuntu server) is constantly doing something, and I can't figure out what. The two production servers, which are essentially identical, don't show these symptoms. In a nutshell, it's showing 10K blocks per second of data going out, all the time, and essenti

Re: [ADMIN] Who is causing all this i/o?

2011-05-20 Thread Joshua D. Drake
The other two servers are configured identically. If I diff the configuration files, the only difference is the IP addresses for the "listen" section. Can anyone tell me what's going on? Why is pgstat.stat being rewritten on this server constantly and not on the other two servers? Do you have

Re: [ADMIN] Who is causing all this i/o?

2011-05-20 Thread Craig James
On 5/20/11 3:38 PM, Joshua D. Drake wrote: The other two servers are configured identically. If I diff the configuration files, the only difference is the IP addresses for the "listen" section. Can anyone tell me what's going on? Why is pgstat.stat being rewritten on this server constantly and

Re: [ADMIN] Who is causing all this i/o?

2011-05-20 Thread Steve Crawford
On 05/20/2011 02:14 PM, Craig James wrote: Our development server (PG 8.4.4 on Ubuntu server) is constantly doing something, and I can't figure out what. The two production servers, which are essentially identical, don't show these symptoms. In a nutshell, it's showing 10K blocks per second o

Re: [ADMIN] Who is causing all this i/o?

2011-05-20 Thread Scott Marlowe
On Fri, May 20, 2011 at 3:14 PM, Craig James wrote: > Our development server (PG 8.4.4 on Ubuntu server) is constantly doing > something, and I can't figure out what.  The two production servers, which > are essentially identical, don't show these symptoms.  In a nutshell, it's > showing 10K block

Re: [ADMIN] Who is causing all this i/o?

2011-05-20 Thread Craig James
On 5/20/11 4:25 PM, Scott Marlowe wrote: On Fri, May 20, 2011 at 3:14 PM, Craig James wrote: Our development server (PG 8.4.4 on Ubuntu server) is constantly doing something, and I can't figure out what. The two production servers, which are essentially identical, don't show these symptoms. I

Re: [ADMIN] Who is causing all this i/o?

2011-05-20 Thread vequalsitimesz
I am tracking down possibly similar behavior on a production server and a colleague introduced me to Dstat. I am using it right now to try and track down the root of my problem. May or may not be helpful in figuring out exactly whats causing this and then on to figuring out to fix it. http: