On Mar 6, 2014, at 10:03 AM, Adrian Klaver <adrian.kla...@aklaver.com> wrote:
> On 03/06/2014 10:43 AM, Israel Brewster wrote: >> On Mar 6, 2014, at 9:03 AM, Adrian Klaver <adrian.kla...@aklaver.com> wrote: >> > >>> >>> Well something is happening. See my notes on logging below to help track >>> down the cause. >> >> Yep. >> > >>> >>> Might be good to explain your archive setup. >> >> Ok, here goes: We have the primary system which receives the data and >> handles all requests for said data. There is also a hot standby server keep >> in sync with streaming replication. The WALs are archived to a NFS share on >> this machine. >> >> Once an hour a python script runs that a) Selects all unsynced records from >> the postgresql db, b) stores a subset of them in our permanent archive, and >> c) marks the previously selected records as synced (UPDATE data SET >> syncd=true WHERE id in (...) ) >> >> Additionally, I have a) a script that runs at 8:00pm every evening that uses >> pg_dump to dump the contents of the database to a backup file, and b) a >> script that runs at 8:00 each morning that rsync's various config files and >> scripts (such as my data retrieval scripts) from the primary machine to a >> backup location on the secondary machine. >> >> None of the scripts run anywhere near the apparent 4:40ish cutoff time for >> my data > > Are all the scripts running from one machine? > If so, have you checked that the times are set correctly on the various > machines? Three different machines (due to OS requirements), but yeah the times all appear to be correct. > > >> >> Make sense? Probably not the best setup, but then that's what happens when >> you figure out stuff for yourself rather than having formal training :-) I'm >> DEFINITELY open to suggestions :-) > > 'Makes sense' is context sensitive. It really depends on what you want to > achieve. My procedure is to define the end result first and then work > backwards from there. Good point. However, I was asking more in the general "did I explain it well enough to be understood" rather than in the "is it a sensible setup" aspect. The rest of the sentence was just me being insecure :-D > >> >>> > >> >> I'll get those in the config, and we'll see what happens tomorrow morning. >> Hopefully that will give more information. Thanks for the link and >> information! >> >> > ----------------------------------------------- Israel Brewster Computer Support Technician II Era Alaska 5245 Airport Industrial Rd Fairbanks, AK 99709 (907) 450-7250 x7293 -----------------------------------------------
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
-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
