Re: [GENERAL] PostgreSQL Required Monitoring

2017-04-28 Thread Igor Neyman
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Andrew Kerber Sent: Friday, April 28, 2017 12:58 PM To: Scott Marlowe Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] PostgreSQL Required Monitoring Attention: This email was sent from

Re: [GENERAL] PostgreSQL Required Monitoring

2017-04-28 Thread Andrew Kerber
Yes, that was the first item on my list (disk space)... On Fri, Apr 28, 2017 at 11:56 AM, Scott Marlowe wrote: > On Fri, Apr 28, 2017 at 8:39 AM, Andrew Kerber > wrote: > > I am a fairly experienced Oracle DBA, and we are starting to move in to > the > > PostgreSQL world. I would expect the st

Re: [GENERAL] PostgreSQL Required Monitoring

2017-04-28 Thread Scott Marlowe
On Fri, Apr 28, 2017 at 8:39 AM, Andrew Kerber wrote: > I am a fairly experienced Oracle DBA, and we are starting to move in to the > PostgreSQL world. I would expect the standard monitoring items are required > for mission critical postgres apps, Ie, disk space, wal log space, log > monitoring,

Re: [GENERAL] PostgreSQL Required Monitoring

2017-04-28 Thread Igor Neyman
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Andrew Kerber Sent: Friday, April 28, 2017 12:22 PM To: John R Pierce Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] PostgreSQL Required Monitoring Attention: This email was sent from

Re: [GENERAL] PostgreSQL Required Monitoring

2017-04-28 Thread Andrew Kerber
yes, replication monitoring is high on the oracle list also, just forgot to mention it. I ran into a similar transaction issue in Oracle when they were running queries across database links and not committing. Its a little known fact that any oracle query that runs across a database link starts a

Re: [GENERAL] PostgreSQL Required Monitoring

2017-04-28 Thread John R Pierce
On 4/28/2017 7:39 AM, Andrew Kerber wrote: I am a fairly experienced Oracle DBA, and we are starting to move in to the PostgreSQL world. I would expect the standard monitoring items are required for mission critical postgres apps, Ie, disk space, wal log space, log monitoring, process counts,s

Re: [GENERAL] PostgreSQL Required Monitoring

2017-04-28 Thread Jan Keirse
On Fri, Apr 28, 2017 at 4:39 PM, Andrew Kerber wrote: > I am a fairly experienced Oracle DBA, and we are starting to move in to > the PostgreSQL world. I would expect the standard monitoring items are > required for mission critical postgres apps, Ie, disk space, wal log space, > log monitoring,

Re: [GENERAL] PostgreSQL Required Monitoring

2017-04-28 Thread Melvin Davidson
On Fri, Apr 28, 2017 at 10:46 AM, Joshua D. Drake wrote: > On 04/28/2017 07:39 AM, Andrew Kerber wrote: > >> I am a fairly experienced Oracle DBA, and we are starting to move in to >> the PostgreSQL world. I would expect the standard monitoring items are >> required for mission critical postgres

Re: [GENERAL] PostgreSQL Required Monitoring

2017-04-28 Thread Joshua D. Drake
On 04/28/2017 07:39 AM, Andrew Kerber wrote: I am a fairly experienced Oracle DBA, and we are starting to move in to the PostgreSQL world. I would expect the standard monitoring items are required for mission critical postgres apps, Ie, disk space, wal log space, log monitoring, process counts,s