Re: [GENERAL] Mysterious DB reset

2014-03-07 Thread Brent Wood
March 06, 2014 8:01 AM To: Israel Brewster Cc: PGSQL Mailing List Subject: Re: [GENERAL] Mysterious DB reset On 5 March 2014 18:22, Israel Brewster mailto:isr...@eraalaska.net>> wrote: I have a Postgresql 9.2.4 database containing real-time tracking data for our aircraft for the past week (the

Re: [GENERAL] Mysterious DB reset

2014-03-07 Thread Adrian Klaver
On 03/07/2014 03:10 PM, Israel Brewster wrote: /usr/local/pgsql/bin/pg_dump -h -U tracking -cs | /usr/local/pgsql/bin/psql -U postgres tracking It must have been left over from before I got streaming replication up and working, when this box was still the backup server and not primary -i.e.

Re: [GENERAL] Mysterious DB reset

2014-03-07 Thread Israel Brewster
--- 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:Frontie

Re: [GENERAL] Mysterious DB reset

2014-03-07 Thread Adrian Klaver
On 03/07/2014 11:08 AM, Israel Brewster wrote: On Mar 6, 2014, at 1:25 PM, Steve Crawford wrote: On 03/06/2014 09:33 AM, Israel Brewster wrote: For starters, this happened again this morning (no data prior to 4:45 am and sequence reset), so whatever is going on appears to be reoccurring. Al

Re: [GENERAL] Mysterious DB reset

2014-03-07 Thread Israel Brewster
On Mar 6, 2014, at 1:25 PM, Steve Crawford wrote: > On 03/06/2014 09:33 AM, Israel Brewster wrote: >> For starters, this happened again this morning (no data prior to 4:45 am and >> sequence reset), so whatever is going on appears to be reoccurring. Also, I >> forgot to mention if it is signif

Re: [GENERAL] Mysterious DB reset

2014-03-07 Thread Israel Brewster
So the logs have given me a partial answer, specifically WHO and WHAT. I still have to track down WHY: [unknown]-2014-03-07 04:40:02.407 AKST-0LOG: connection received: host=[local] postgres-2014-03-07 04:40:02.409 AKST-0LOG: connection authorized: user=postgres database=tracking postgres-2014

Re: [GENERAL] Mysterious DB reset

2014-03-06 Thread Steve Crawford
On 03/06/2014 09:33 AM, Israel Brewster wrote: For starters, this happened again this morning (no data prior to 4:45 am and sequence reset), so whatever is going on appears to be reoccurring. Also, I forgot to mention if it is significant: this is running on slackware liunux 14.0 Also odd is

Re: [GENERAL] Mysterious DB reset

2014-03-06 Thread David Johnston
Israel Brewster-2 wrote > So my question is, aside from someone going in and mucking about in the > wee hours of the morning, what could possibly cause this behavior? What > sort of event could cause all data to be deleted from the table, and the > sequence to be reset? Especially while there is an

Re: [GENERAL] Mysterious DB reset

2014-03-06 Thread Adrian Klaver
On 03/06/2014 11:09 AM, Israel Brewster wrote: On Mar 6, 2014, at 10:03 AM, Adrian Klaver wrote: 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

Re: [GENERAL] Mysterious DB reset

2014-03-06 Thread Israel Brewster
On Mar 6, 2014, at 10:03 AM, Adrian Klaver wrote: > On 03/06/2014 10:43 AM, Israel Brewster wrote: >> On Mar 6, 2014, at 9:03 AM, Adrian Klaver wrote: >> > >>> >>> Well something is happening. See my notes on logging below to help track >>> down the cause. >> >> Yep. >> > >>> >>> Might b

Re: [GENERAL] Mysterious DB reset

2014-03-06 Thread Adrian Klaver
On 03/06/2014 10:43 AM, Israel Brewster wrote: On Mar 6, 2014, at 9:03 AM, Adrian Klaver 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 whic

Re: [GENERAL] Mysterious DB reset

2014-03-06 Thread Israel Brewster
On Mar 6, 2014, at 9:03 AM, Adrian Klaver wrote: > On 03/06/2014 09:33 AM, Israel Brewster wrote: >> For starters, this happened again this morning (no data prior to 4:45 am and >> sequence reset), so whatever is going on appears to be reoccurring. Also, I >> forgot to mention if it is signific

Re: [GENERAL] Mysterious DB reset

2014-03-06 Thread Michael Nolan
On 3/6/14, Israel Brewster wrote: > LOG: received smart shutdown request > LOG: autovacuum launcher shutting down > LOG: shutting down > LOG: database system is shut down > > However, there are no timestamps on any of the entries (can I fix that?) Yes, change the log_line_prefix in the pos

Re: [GENERAL] Mysterious DB reset

2014-03-06 Thread Adrian Klaver
On 03/06/2014 09:33 AM, Israel Brewster wrote: For starters, this happened again this morning (no data prior to 4:45 am and sequence reset), so whatever is going on appears to be reoccurring. Also, I forgot to mention if it is significant: this is running on slackware liunux 14.0 On Mar 5, 201

Re: [GENERAL] Mysterious DB reset

2014-03-06 Thread Israel Brewster
On Mar 5, 2014, at 10:01 AM, Thom Brown wrote:On 5 March 2014 18:22, Israel Brewster wrote: I have a Postgresql 9.2.4 database containing real-time tracking data for our aircraft for the past week (theoretically). It is populated by two different processes:

Re: [GENERAL] Mysterious DB reset

2014-03-06 Thread Israel Brewster
On Mar 5, 2014, at 10:01 AM, Alvaro Herrera wrote: > Israel Brewster wrote: > >> So my question is, aside from someone going in and mucking about in the wee >> hours of the morning, what could possibly cause this behavior? What sort of >> event could cause all data to be deleted from the table

Re: [GENERAL] Mysterious DB reset

2014-03-06 Thread Israel Brewster
For starters, this happened again this morning (no data prior to 4:45 am and sequence reset), so whatever is going on appears to be reoccurring. Also, I forgot to mention if it is significant: this is running on slackware liunux 14.0 On Mar 5, 2014, at 1:00 PM, Adrian Klaver wrote: > On 03/05/

Re: [GENERAL] Mysterious DB reset

2014-03-05 Thread Adrian Klaver
On 03/05/2014 10:22 AM, Israel Brewster wrote: I have a Postgresql 9.2.4 database containing real-time tracking data for our aircraft for the past week (theoretically). It is populated by two different processes: one that runs every few minutes, retrieving data from a number of sources and storin

Re: [GENERAL] Mysterious DB reset

2014-03-05 Thread Thom Brown
On 5 March 2014 18:22, Israel Brewster wrote: > I have a Postgresql 9.2.4 database containing real-time tracking data for > our aircraft for the past week (theoretically). It is populated by two > different processes: one that runs every few minutes, retrieving data from > a number of sources and

Re: [GENERAL] Mysterious DB reset

2014-03-05 Thread Alvaro Herrera
Israel Brewster wrote: > So my question is, aside from someone going in and mucking about in the wee > hours of the morning, what could possibly cause this behavior? What sort of > event could cause all data to be deleted from the table, and the sequence to > be reset? Especially while there is

[GENERAL] Mysterious DB reset

2014-03-05 Thread Israel Brewster
I have a Postgresql 9.2.4 database containing real-time tracking data for our aircraft for the past week (theoretically). It is populated by two different processes: one that runs every few minutes, retrieving data from a number of sources and storing it in the DB, and one that has an "always on" c