On 7/05/2014, at 3:07 am, pgsql-general-ow...@postgresql.org wrote:
> I would just use check_postgres (perl) from your agent script...
Having downloaded and had a look at this script I would agree. I'll let
check_postgresl do the heavy lifting and just try and get a build an MP that
collects
On 6/05/2014, at 1:30 am, Magnus Hagander wrote:
> As long as you can run arbitrary SQL, you can get all the information out.
> Assuming it can do something with it rather than just run a plain query. If
> so, I suggest you take a look at the check_postgres nagios plugin or the
> munin plugin
On 5/05/2014, at 3:18 pm, Tatsuo Ishii wrote:
>> I am in the process of deploying Microsoft System Centre Operations Manager
>> and was hoping that somebody had either developed or knew of where I could
>> get hold of a management pack for PostgreSQL.
>>
>> I am not sure whether there is an i
On 5/05/2014, at 12:26 pm, Adrian Klaver wrote:
> On 05/04/2014 04:17 PM, Glen Eustace wrote:
>> I am in the process of deploying Microsoft System Centre Operations
>> Manager and was hoping that somebody had either developed or knew of
>> where I could get hold of
I am in the process of deploying Microsoft System Centre Operations Manager and
was hoping that somebody had either developed or knew of where I could get hold
of a management pack for PostgreSQL.
I am not sure whether there is an instrumentation interface into the DB so
haven't yet looked at r
Back in Dec 2012, I asked whether anyone had already updated mod_auth_pgsql to
work with the new authentication framework in Apache 2.3+ I didn't get any
replies so went ahead and made sufficient changes to get it working in our
environment.
I approached the maintainer/author about adding my p
Just wondering if anyone has had a go at updating the mod_auth_pgsql
authentication module to the new access/authentication provider framework ?
I have had a quick look and can't seem to decide which standard module I should
try to base the modifications on.
I appreciate that this is really an
The solution to my problems involved both of the issues Tom identified.
1. Proc::Daemon::Init() call closed the libpq connection in the parent.
Solution: deliberately close connection before call and open in the
child after the call.
2. The status updates were being written inside
Not on that much evidence; but trying to pass a libpq connection across
a fork is usually risky. The trouble is that both parent and child
processes now hold copies of the open socket connection, but only one of
them can safely work with it. It could be that you've closed the libpq
connection
Hi Tom,
On 08/09/2010 03:33 AM, Tom Lane wrote:
Your note is awfully short of concrete details, but I'm guessing the
basic reason why this wasn't working for you was you were doing all the
operations as a single transaction. The results of that transaction
wouldn't be visible to another one un
I am not sure where my issue lies - apache, perl or postgresql, but as
they say, one has to start somewhere.
My goal is to have a perl cgi script (that is accessed using AJAX)
perform some operations in a database using DBI. Some of the actions
are likely to take a while so my intent was to h
Generally speaking, virtualization allows you to take a bunch of low
powered servers and make them live in one big box saving money on
electricity and management. Generally speaking, database sers are big
powerful boxes with lots of hard disks and gigs upon gigs of ram to
handle terabytes of da
Hi all,
I was wondering whether anyone has had any experience running postgresql
in a vm under ESx. VMware provides significant HA/DR oppurtunities and
we would like to use it if we can. The DBase would be on a EMC SAN
hosted LUN and the ESx servers would be dual Quad CPU HP DL-380/G5s. At
Has anyone written or know of a zenoss plugin that can be used in the
same way as the mySQLMonitor ?
I can use the nagios one but was hoping to get some of the same sort of
performance metrics as the mysql one provides.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Tom Lane wrote:
Glen Eustace <[EMAIL PROTECTED]> writes:
My apologies, I shouldn't have used the generic socket error 'Connection
refused'. What I am getting are errors like
"Could not connect to database" from libnss-pgsql
This is the exact message from libn
Tom Lane wrote:
Glen Eustace <[EMAIL PROTECTED]> writes:
My apologies, I shouldn't have used the generic socket error 'Connection
refused'. What I am getting are errors like
"Could not connect to database" from libnss-pgsql
Please be *exact* rather than handwa
Tom Lane wrote:
"Connection refused" is a kernel-level rejection, and at least in theory
should have nothing to do with what Postgres is doing. Did you do a
kernel update at the same time?
regards, tom lane
My apologies, I shouldn't have used the generic socket error '
After an upgrade from 8.0.8 to 8.1.8, I am getting a number of our
scripts failing with 'connection refused' at around 4:00am, which seems
to be when the nightly database backup occurs.
I am using "/usr/bin/pg_dump -Fc -b -c -C" to do the deed.
Has there been a change in behavior, i.e. is the
Is there some way that one can determine whether a table has changed
i.e. an insert, delete, update, without having to resort to setting a
flag in another table using a triger or rule.
I was wondering whether one of the system relations keep track of
whether a table has been modifed.
---
> Offhand I'd expect the 'now' to be reduced to a timestamp constant
> at the time the view is created.
Hmmm, my assumption had been that the 'now' constant would be evaluated
everytime the underlying SELECT was build by the planner.
> although personally I'd not feel very comfortable with the id
Hi,
I am trying to setup rules on a view that will maintain an audit trail
of modifications in the real table. Things seem to be going ok but when
I EXPLAIN my queries, the literal 'now' is being given two different
values, one 2 days earlier. I am running 7.4.7
The view is defined to be;
CREATE
I am trying to setup slony-1 and need some off list assistance from
someone who has got things going ( or at least knows more than me :-).
I am running 7.4.6 on both master and slave but when I run the slonik
script, I get the error.
:5: Initializing the cluster
:7: PGRES_FATAL_ERROR create schem
On Mon, 2004-11-01 at 21:14, Sim Zacks wrote:
> I would check the template1 database to see if you had the functions
> defined there as well.
> Any functions/structures/data... in template1 will be moved to the new
> database. Then when you try to restore the old one it will conflict.
Thanks you.
I was a little surprised today when I tried to move a production
database on to my test server. The test server already had a copy of
the database so I did
psql -Uadmin template1
drop database admin;
create database admin;
When I tried to reload the production database dump, I got a series of
er
On Thu, 2004-10-07 at 03:06, Tom Lane wrote:
> Not sure if you are familiar with the Slony project, but that is
> probably your best bet for data propagation to a live slave at present
Hi Tom,
Thanks for the comment. I was aware of Slony but didn't want the
mirroring to require addition of trigg
On Wed, 2004-10-06 at 20:03, Shridhar Daithankar wrote:
> Well, you could start off with PITR capabilities of 8.0. But you may need to
> do quite a bit of customization and experimentation.
>
> Check http://developer.postgresql.org/docs/postgres/backup-online.html
>
> And we would be very eage
I thought I had seen something that indicated that v8 was going to
provide a means to mirror databases without needing all the triggers
etc. I downloaded beta 3 but couldn't see anything that would do this.
My goal is to mirror a database from one server to another, hopefully
from the logs so that
27 matches
Mail list logo
