Sergey Konoplev wrote:
> On Mon, Dec 30, 2013 at 12:27 AM, Albe Laurenz
> wrote:
>> Joe Van Dyk wrote:
>>> If I run "COPY (select * from complicate_view) to stdout" on the standby,
>>> I've noticed that sometimes
>>> halts replication updates to the slave.
>>>
>>> For example, that's happening r
On Mon, Dec 30, 2013 at 10:05 PM, Joe Van Dyk wrote:
>> I meant all the replication settings, see [1]. And pg_stat_statements
>> when there is a problem, preferable the error, because when everything
>> is okay it is not very useful actually.
>
> I don't understand, how is pg_stat_statements helpf
On Mon, Dec 30, 2013 at 9:11 PM, Sergey Konoplev wrote:
> On Mon, Dec 30, 2013 at 8:56 PM, Joe Van Dyk wrote:
> > On Mon, Dec 30, 2013 at 10:27 AM, Sergey Konoplev
> wrote:
> >> On Mon, Dec 30, 2013 at 12:02 AM, Joe Van Dyk wrote:
> >> > On Sun, Dec 29, 2013 at 10:52 PM, Sergey Konoplev
> >>
On Wed, Dec 18, 2013 at 1:51 PM, Adrian Klaver wrote:
> On 12/18/2013 12:15 PM, Joe Van Dyk wrote:
>>
>> A possibly related question:
>>
>> I've set wal_keep_segments to 10,000 and also have archive_command
>> running wal-e. I'm seeing my wal files disappear from pg_xlog after 30
>> minutes. Is th
On Mon, Dec 30, 2013 at 8:56 PM, Joe Van Dyk wrote:
> On Mon, Dec 30, 2013 at 10:27 AM, Sergey Konoplev wrote:
>> On Mon, Dec 30, 2013 at 12:02 AM, Joe Van Dyk wrote:
>> > On Sun, Dec 29, 2013 at 10:52 PM, Sergey Konoplev
>> > wrote:
>> >> On Sun, Dec 29, 2013 at 9:56 PM, Joe Van Dyk wrote:
>>
On Mon, Dec 30, 2013 at 10:27 AM, Sergey Konoplev wrote:
> On Mon, Dec 30, 2013 at 12:02 AM, Joe Van Dyk wrote:
> > On Sun, Dec 29, 2013 at 10:52 PM, Sergey Konoplev
> wrote:
> >> On Sun, Dec 29, 2013 at 9:56 PM, Joe Van Dyk wrote:
> >> > On Wed, Dec 18, 2013 at 3:39 PM, Sergey Konoplev
> >>
On Mon, Dec 30, 2013 at 12:27 AM, Albe Laurenz wrote:
> Joe Van Dyk wrote:
>> If I run "COPY (select * from complicate_view) to stdout" on the standby,
>> I've noticed that sometimes
>> halts replication updates to the slave.
>>
>> For example, that's happening right now and "now() -
>> pg_last_
Joe Van Dyk wrote:
> If I run "COPY (select * from complicate_view) to stdout" on the standby,
> I've noticed that sometimes
> halts replication updates to the slave.
>
> For example, that's happening right now and "now() -
> pg_last_xact_replay_timestamp()" is 22 minutes.
> There's many transac
On Sun, Dec 29, 2013 at 9:56 PM, Joe Van Dyk wrote:
> On Wed, Dec 18, 2013 at 3:39 PM, Sergey Konoplev wrote:
>>
>> On Wed, Dec 18, 2013 at 11:26 AM, Joe Van Dyk wrote:
>> > I'm running Postgresql 9.3. I have a streaming replication server.
>> > Someone
>> > was running a long COPY query (8 hour
On Wed, Dec 18, 2013 at 3:39 PM, Sergey Konoplev wrote:
> On Wed, Dec 18, 2013 at 11:26 AM, Joe Van Dyk wrote:
> > I'm running Postgresql 9.3. I have a streaming replication server.
> Someone
> > was running a long COPY query (8 hours) on the standby which halted
> > replication. The replication
On Wed, Dec 18, 2013 at 11:26 AM, Joe Van Dyk wrote:
> I'm running Postgresql 9.3. I have a streaming replication server. Someone
> was running a long COPY query (8 hours) on the standby which halted
> replication. The replication stopped at 3:30 am. I canceled the long-running
> query at 9:30 am
On 12/18/2013 12:15 PM, Joe Van Dyk wrote:
A possibly related question:
I've set wal_keep_segments to 10,000 and also have archive_command
running wal-e. I'm seeing my wal files disappear from pg_xlog after 30
minutes. Is that expected? Is there a way around that?
Well a WAL segment is 16MB in
Joe Van Dyk writes:
> I'm running Postgresql 9.3. I have a streaming replication server. Someone
> was running a long COPY query (8 hours) on the standby which halted
> replication. The
> replication stopped at 3:30 am. I canceled the long-running query at 9:30 am
> and replication data starte
A possibly related question:
I've set wal_keep_segments to 10,000 and also have archive_command running
wal-e. I'm seeing my wal files disappear from pg_xlog after 30 minutes. Is
that expected? Is there a way around that?
(I want to use streaming replication and wal-e for PITR restores)
On Wed,
I'm running Postgresql 9.3. I have a streaming replication server. Someone
was running a long COPY query (8 hours) on the standby which halted
replication. The replication stopped at 3:30 am. I canceled the
long-running query at 9:30 am and replication data started catching up.
The data up until 1
15 matches
Mail list logo