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
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.
---
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
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
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
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
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
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
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
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
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
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
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
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
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:
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
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/
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
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
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
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
21 matches
Mail list logo