pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Warm/hot backup server question
5+ messages / 4 participants
[nested] [flat]

* Warm/hot backup server question
@ 2007-10-07 20:22  Faber J. Fedor <faber@linuxnj.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Faber J. Fedor @ 2007-10-07 20:22 UTC (permalink / raw)
  To: pgsql-admin

Hi,

I've been given the job of creating a hot/warm backup server
for a live Postgresql server.  The problem is two-fold: 1) it's version
7.4.9 and an upgrade is not feasible at this time and b) there are
multiple instances of postgresql running on the box; not multiple
databases, multiple *servers*, each listening on a different port (it
was a business requirement from what I've been told).

I plan on using heartbeat and mon to monitor the primary server for
non-availability and fail over.

I thought about DRBD, but that would require repartitioning the live
server and I want to touch it as little as possible.

I've read the docs for WAL and the 8.2 version sounds perfect for what
I want but, as I said, an upgrade is out of the question for now.  I
see that 7.4 has WAL, but I didn't see mention of the warm backups as
mentioned in the 8.2 docs.  Can 7.4 do the same magic as 8.2 wrt to
WAL?

Is SLONY/replication my only choice?  Remember, I can't/don't want to
rebuild the existing servers.

TIA!

-- 
 
Regards,
 
Faber Fedor
President
Linux New Jersey, Inc.
908-320-0357
800-706-0701

http://www.linuxnj.com




-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Warm/hot backup server question
@ 2007-10-08 01:42  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Faber J. Fedor <faber@linuxnj.com>
  0 siblings, 2 replies; 5+ messages in thread

From: Tom Lane @ 2007-10-08 01:42 UTC (permalink / raw)
  To: Faber J. Fedor <faber@linuxnj.com>; +Cc: pgsql-admin

"Faber J. Fedor" <faber@linuxnj.com> writes:
> I've been given the job of creating a hot/warm backup server
> for a live Postgresql server.  The problem is two-fold: 1) it's version
> 7.4.9 and an upgrade is not feasible at this time and b) there are
> multiple instances of postgresql running on the box; not multiple
> databases, multiple *servers*, each listening on a different port (it
> was a business requirement from what I've been told).

If they won't let you update to 7.4.18 (the current release in that
branch), you would be best advised to resign at once, before you get
blamed for the train wreck that is inevitably in this system's future.
7.4.9 is two years old, and I count at least six fixes since then for
data-loss bugs of the *will*-bite-you-eventually type; plus a couple
more that you might be at risk for depending on which features you use.
Also, the choice to run separate servers sounds a whole lot like they
are serving clients that they don't trust 100%, which means there are
also half a dozen security fixes that they should be worried about.

> Can 7.4 do the same magic as 8.2 wrt to WAL?

No.  Slony is your best bet --- not least because it may simplify a live
upgrade to a newer version.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Warm/hot backup server question
@ 2007-10-08 03:07  Scott Marlowe <scott.marlowe@gmail.com>
  parent: Tom Lane <tgl@sss.pgh.pa.us>
  1 sibling, 0 replies; 5+ messages in thread

From: Scott Marlowe @ 2007-10-08 03:07 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Faber J. Fedor <faber@linuxnj.com>; pgsql-admin

On 10/7/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Faber J. Fedor" <faber@linuxnj.com> writes:
> > I've been given the job of creating a hot/warm backup server
> > for a live Postgresql server.  The problem is two-fold: 1) it's version
> > 7.4.9 and an upgrade is not feasible at this time and b) there are
> > multiple instances of postgresql running on the box; not multiple
> > databases, multiple *servers*, each listening on a different port (it
> > was a business requirement from what I've been told).
>
> If they won't let you update to 7.4.18 (the current release in that
> branch), you would be best advised to resign at once, before you get
> blamed for the train wreck that is inevitably in this system's future.
> 7.4.9 is two years old, and I count at least six fixes since then for
> data-loss bugs of the *will*-bite-you-eventually type; plus a couple
> more that you might be at risk for depending on which features you use.

I agree.  Although I'd set up your new job first if possible.

I also agree that Slony is your best bet.  Note only the older
versions of slony run on 7.4, so make sure you download the version of
slony that works with 7.4.  I think it's 1.0, could be 1.1 or so.



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Warm/hot backup server question
@ 2007-10-09 01:34  Faber J. Fedor <faber@linuxnj.com>
  parent: Tom Lane <tgl@sss.pgh.pa.us>
  1 sibling, 1 reply; 5+ messages in thread

From: Faber J. Fedor @ 2007-10-09 01:34 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin

On 07/10/07 21:42 -0400, Tom Lane wrote:
> If they won't let you update to 7.4.18 (the current release in that
> branch), you would be best advised to resign at once, before you get
> blamed for the train wreck that is inevitably in this system's future.

Done.

Now, how are you on giving advice to improve my love life? :-)

-- 
 
Regards,
 
Faber Fedor
President
Linux New Jersey, Inc.
908-320-0357
800-706-0701

http://www.linuxnj.com




-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Warm/hot backup server question
@ 2007-10-09 01:38  Joshua D. Drake <jd@commandprompt.com>
  parent: Faber J. Fedor <faber@linuxnj.com>
  0 siblings, 0 replies; 5+ messages in thread

From: Joshua D. Drake @ 2007-10-09 01:38 UTC (permalink / raw)
  To: Faber J. Fedor <faber@linuxnj.com>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; pgsql-admin

On Mon, 8 Oct 2007 21:34:10 -0400
"Faber J. Fedor" <faber@linuxnj.com> wrote:

> On 07/10/07 21:42 -0400, Tom Lane wrote:
> > If they won't let you update to 7.4.18 (the current release in that
> > branch), you would be best advised to resign at once, before you get
> > blamed for the train wreck that is inevitably in this system's
> > future.
> 
> Done.
> 
> Now, how are you on giving advice to improve my love life? :-)

Don't spend your time reading and replying to open source mailing lists?
;)

Joshua D. Drake


> 


-- 

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997  http://www.commandprompt.com/
			UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

Attachments:

  signature.asc (application/pgp-signature, 188B) download

^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2007-10-09 01:38 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-10-07 20:22 Warm/hot backup server question Faber J. Fedor <faber@linuxnj.com>
2007-10-08 01:42 ` Tom Lane <tgl@sss.pgh.pa.us>
2007-10-08 03:07   ` Scott Marlowe <scott.marlowe@gmail.com>
2007-10-09 01:34   ` Faber J. Fedor <faber@linuxnj.com>
2007-10-09 01:38     ` Joshua D. Drake <jd@commandprompt.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox