Skip site navigation (1) Skip section navigation (2)

Re: pgpool

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: David Pinkerton <david(dot)pinkerton(at)betteroff(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: pgpool
Date: 2012-08-28 13:51:41
Message-ID: CAHyXU0xHe_SKS2FNarwQzB07pDQ=0aq1nqiqrHjPs5en6XKGhQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Sun, Aug 26, 2012 at 10:25 PM, David Pinkerton
<david(dot)pinkerton(at)betteroff(dot)net> wrote:
>
> First let me prefix this with "I'm not a DBA, I am a Linux Sys Admin"
>
> Could someone provide a simple overview for me.
>
> We have a postgres 9.0 server which is about to run out of diskspace.  I
> have built a new server and and set up a play virtual server so I can
> experiment with pgpool.
> I can create a db on the new server and populate it.  Data appears on the
> virtual.
>
> So far so good.
>
> My question(s)...
>
> 1) how do I force the replication an existing database?  (preference is zero
> downtime)
> 2) where do i install pg-pool if I want to rebuild the original server and
> then have load balancing across the 2 physical servers?
> 3) do i need to change all my scripts to talk on the pg-pool (ie. 9999 )
> port instead of postgres (5432) or do I make postgres listen on loopback and
> have pg-pool bind to the external ip (assuming its installed on the same
> server)?
>
>
>
> The documents on the wiki seem to jump from the one line descriptions of
> what the software can do, straight into configuration.
>
> Is there a scenario documents anywhere, that can show pro's and con's of
> each setup mode and is written in non-dba speak.

For emergency low-downtime switch of database from one server to
another, I'm wondering why you didn't explore the PITR route --
capturing a file system backup and grabbing the logs.  You can go even
further and do HS/SR for the replica.  pgpool (which i'm not very
familiar with) might also be a great tool for doing that -- I'm just
wondering what your thought process was.

merlin


In response to

  • pgpool at 2012-08-27 03:25:05 from David Pinkerton

pgsql-novice by date

Next:From: Tom LaneDate: 2012-08-28 16:24:42
Subject: Re: using index "pg_toast_..." despite IgnoreSystemIndexes
Previous:From: lsqDate: 2012-08-28 10:57:18
Subject: using index "pg_toast_..." despite IgnoreSystemIndexes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group