Re: [GENERAL] WAL File archive time
On Tue, Dec 6, 2016 at 7:24 AM, Israel Brewsterwrote: > Simple question: are WAL files archived when full, or when recycled? When full. > That is, are the WAL archive files "up-to-date" other than the current WAL > file, > or will the archives always be wal_keep_segments behind? WAL archives are kept up to date, meaning that all the segments older than the one being written are archived (well perhaps not if the archiver lags behind). wal_keep_segments numbers the number of segments kept in pg_xlog past the last completed checkpoint. -- Michael -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] WAL File archive time
Simple question: are WAL files archived when full, or when recycled? That is, are the WAL archive files "up-to-date" other than the current WAL file, or will the archives always be wal_keep_segments behind?---Israel BrewsterSystems Analyst IIRavn Alaska5245 Airport Industrial RdFairbanks, AK 99709(907) 450-7293---BEGIN:VCARD VERSION:3.0 N:Brewster;Israel;;; FN:Israel Brewster ORG:Frontier Flying Service;MIS TITLE:PC Support Tech II EMAIL;type=INTERNET;type=WORK;type=pref:isr...@frontierflying.com TEL;type=WORK;type=pref:907-450-7293 item1.ADR;type=WORK;type=pref:;;5245 Airport Industrial Wy;Fairbanks;AK;99701; item1.X-ABADR:us CATEGORIES:General X-ABUID:36305438-95EA-4410-91AB-45D16CABCDDC\:ABPerson END:VCARD