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

Re: Simplifying replication

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: Greg Stark <gsstark(at)mit(dot)edu>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Simplifying replication
Date: 2010-10-22 00:22:08
Message-ID: 201010220022.o9M0M8Q29438@momjian.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Josh Berkus wrote:
> Greg,
> 
> > The way things stand you *always* need archived logs. Even if you have
> > streaming set up it might try to use archived logs if it falls too far
> > behind.
> 
> Actually, you don't.  If you're willing to accept possible
> desynchronization and recloning of the standbys, then you can skip the
> archive logs.

Agreed, but as a reality check:  when I proposed that wal_keep_segments
= -1 would keep all WAL segments (for use while the file system was
being backed up), I was told administrators shoud compute how much free
disk space they had.  Obviously easy of use is not our #1 priority.

-- 
  Bruce Momjian  <bruce(at)momjian(dot)us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +

In response to

Responses

pgsql-hackers by date

Next:From: Alvaro HerreraDate: 2010-10-22 00:26:01
Subject: Re: crash in plancache with subtransactions
Previous:From: Bruce MomjianDate: 2010-10-22 00:04:15
Subject: Re: Creation of temporary tables on read-only standby servers

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