On Sun, Aug 26, 2012 at 10:25 PM, David Pinkerton
> 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
> So far so good.
> My question(s)...
> 1) how do I force the replication an existing database? (preference is zero
> 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
> 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.
In response to
- pgpool at 2012-08-27 03:25:05 from David Pinkerton
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2012-08-28 16:24:42|
|Subject: Re: using index "pg_toast_..." despite IgnoreSystemIndexes|
|Previous:||From: lsq||Date: 2012-08-28 10:57:18|
|Subject: using index "pg_toast_..." despite IgnoreSystemIndexes|