On Sat, Apr 5, 2014 at 8:47 AM, Andy Colson wrote:
> Hi All.
>
> I've started using replication, and I'd like to monitor my logs for any
> errors or problems. I don't want to do it manually, and I'm not interested
> in stats (a la PgBadger).
>
> What I'd like, is the instant PG logs: "FATAL: wal
On 04/05/2014 05:14 PM, Ben Hoyt wrote:
Thanks for the info, Francisco and Alban -- that looks useful.
Can you see a good way in the INSERT to combine VALUES with that
nextval() subquery? As there are some columns that are distinct for each
row, and some that are the same or programmatically gen
Thanks for the info, Francisco and Alban -- that looks useful.
Can you see a good way in the INSERT to combine VALUES with that nextval()
subquery? As there are some columns that are distinct for each row, and
some that are the same or programmatically generated for each row. For
instance, there's
On 4/5/2014 8:13 AM, David Boreham wrote:
On 4/4/2014 5:29 PM, Lists wrote:
So, spend the money and get the enterprise class SSDs. They have come
down considerably in price over the last year or so. Although on
paper the Intel Enterprise SSDs tend to trail the performance numbers
of the leadin
General thought:
It's entirely possible my current Postgres environment is missing
something (I'm an automation engineer, not a DBA - most of my postgres
knowledge has been learned on the job or from Google), but we actively
monitor the receive and replay lag (i.e. comparing
pg_current_xlog_lo
Hi All.
I've started using replication, and I'd like to monitor my logs for any errors
or problems. I don't want to do it manually, and I'm not interested in stats
(a la PgBadger).
What I'd like, is the instant PG logs: "FATAL: wal segment already removed" (or
some such bad thing), I'd like
On Sat, Apr 5, 2014 at 9:13 AM, David Boreham wrote:
> On 4/4/2014 5:29 PM, Lists wrote:
>>
>> So, spend the money and get the enterprise class SSDs. They have come down
>> considerably in price over the last year or so. Although on paper the Intel
>> Enterprise SSDs tend to trail the performance
On 4/4/2014 5:29 PM, Lists wrote:
So, spend the money and get the enterprise class SSDs. They have come
down considerably in price over the last year or so. Although on paper
the Intel Enterprise SSDs tend to trail the performance numbers of the
leading consumer drives, they have wear character
I have 2 postgres nodes setup in a replication and hot standby configuration. I
am using pgpool for automatic failover and load balancing the read queries.
I have setup scripts for automatic failover when the master node fails. I want
to understand how it would work in the following 2 scenarios.
