Hello
Can anyone suggest me tools for monitoring postgresql server. ?
--
View this message in context:
http://www.nabble.com/Monitoring-tools-for-Postgresql-tp24713155p24713155.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list
Tim Landscheidt wrote:
b) Restore the backup to an SQL file, load it into a suit-
able editor, change (very carefully) over to the new
attribute name and restore that file to a new server.
Thats what I had hoped to be able to do (I've got to search several
backups for the one with the
On Tue, 28 Jul 2009, mukeshp wrote:
Can anyone suggest me tools for monitoring postgresql server. ?
An idea what operating system you're running the server on would help
here.
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing
On Jul 28, 2009, at 11:24 PM, mukeshp wrote:
Can anyone suggest me tools for monitoring postgresql server. ?
As it happens, there was a talk about that very topic on PG day:
Check Please! What Your Postgres Databases Wishes You Would Monitor /
Robert Treat / OmniTI
On Tuesday 28 July 2009 04:38:03 Jeff Davis wrote:
On Mon, 2009-07-27 at 21:05 -0400, Robert James wrote:
1) Introduction to Database Systems
http://www.amazon.com/Introduction-Database-Systems-Kannan-Swamynathan/dp
/B001BVYKY4/ref=sr_1_5?ie=UTF8s=booksqid=1248742811sr=1-5
and
2)
On Tuesday 28 July 2009 02:53:19 Christophe Pettus wrote:
I'm moving from a long time in BSD-land to using Linux. I've always
been in the habit of building PostgreSQL from the source tarballs. On
Linux, is there an advantage either way to using the RPMs as opposed
to building from source?
Robert James wrote:
Is there no way to have the OS interrupt the postgres process
when a TCP/IP disconnect happens? Or is the OS also in the
dark that the TCP/IP connection was dropped? I believe that
there is a way to monitor this using TCP/IP keep alives.
Or perhaps Postgres could check
David Fetter schrieb:
Just a quick question. Wouldn't it be better to provide the videos in flv
format in a player in this page. Since I have a MAC, I have no problems
viewing the videos. But with my Linux box and FF 3.5 I can't.
You can use xine on your Linux box :)
Cheers,
David.
David,
Robert James wrote:
I see - thanks, Tom, for the informative explanation.
In my experience admining high volume servers, I found this to a major
failure pattern: Client tries query which seems to go on forever (either
do to contention or resource exhaustion or some other problem), client
Brendan Hill wrote:
Hi Tom,
Given it's on Windows, any suggestion for how I would get hold of this?
(Process Monitor tool perhaps?)
I think you can get stack traces from Process Monitor using Tools -
Stack Summary. I find it a bit hard to interpret this data, though, and
I'm not sure how
Craig Ringer wrote:
Brendan Hill wrote:
Hi Tom,
Given it's on Windows, any suggestion for how I would get hold of this?
(Process Monitor tool perhaps?)
I think you can get stack traces from Process Monitor using Tools -
Stack Summary. I find it a bit hard to interpret this data, though, and
On Wed, Jul 29, 2009 at 12:08, Craig Ringercr...@postnewspapers.com.au wrote:
Craig Ringer wrote:
Brendan Hill wrote:
Hi Tom,
Given it's on Windows, any suggestion for how I would get hold of this?
(Process Monitor tool perhaps?)
I think you can get stack traces from Process Monitor
Hi
I've started on a wiki article on reporting problems / bugs with
PostgreSQL. It focuses mainly on collecting enough information for it to
be possible to answer questions reasonably.
I'd really like edits / comments / suggestions.
In response to Craig Ringer :
Hi
I've started on a wiki article on reporting problems / bugs with
PostgreSQL. It focuses mainly on collecting enough information for it to
be possible to answer questions reasonably.
I'd really like edits / comments / suggestions.
the error-message as
Hi,
I'm trying to optimise a query at the moment, I've added some new
indexes to stop seq scans, but I'm now trying to work out if I can
stop a join using external sort to speed up the query. I've included
an explain analyze below and would appreciate any pointers to gaps in
my understanding.
In response to Jake Stride :
Hi,
I'm trying to optimise a query at the moment, I've added some new
indexes to stop seq scans, but I'm now trying to work out if I can
stop a join using external sort to speed up the query. I've included
Increase work_mem to force sort in memory.
Andreas
--
Hello,
Le 29/07/09 13:46, Jake Stride a écrit :
Hi,
I'm trying to optimise a query at the moment, I've added some new
indexes to stop seq scans, but I'm now trying to work out if I can
stop a join using external sort to speed up the query. I've included
an explain analyze below and would
2009/7/29 A. Kretschmer andreas.kretsch...@schollglas.com:
In response to Jake Stride :
Hi,
I'm trying to optimise a query at the moment, I've added some new
indexes to stop seq scans, but I'm now trying to work out if I can
stop a join using external sort to speed up the query. I've
Hello,
In our customer site, the following error occurred. I tried to find some
indication what this means. Is this log file used for the roll back
purpose? In what scenario that one gets such fatal error?
Please help!!!
Mzhang
Caused by: org.jboss.resource.JBossResourceException:
On Wed, Jul 29, 2009 at 3:27 AM, Peter Eisentraut pete...@gmx.net wrote:
On Tuesday 28 July 2009 02:53:19 Christophe Pettus wrote:
I'm moving from a long time in BSD-land to using Linux. I've always
been in the habit of building PostgreSQL from the source tarballs. On
Linux, is there an
On 2009-07-28, Tom Lane t...@sss.pgh.pa.us wrote:
Robert James srobertja...@gmail.com writes:
Hi. I noticed that when clients (both psql and pgAdmin) disconnect or
cancel, queries are often still running on the server. A few questions:
1) Is there a way to reconnect and get the results?
On 2009-07-27, Bob Gobeille bob.gobei...@hp.com wrote:
I would like to combine multiple databases (same schema) into one
master db. Does anyone know how I can reconcile all my primary and
foreign keys to maintain referential integrity.
prefix them all with something that's unique to
In our customer site, the following error occurred. I tried to find some
indication what this means. Is this log file used for the roll back
purpose? In what scenario that one gets such fatal error?
Please help!!!
Mzhang
Caused by: org.jboss.resource.JBossResourceException: SQLException; -
On 2009-07-23, Sam Mason s...@samason.me.uk wrote:
On Thu, Jul 23, 2009 at 01:45:36PM +0200, Pavel Stehule wrote:
http://www.postgres.cz/index.php/PostgreSQL_SQL_Tricks
Just had a quick flick through your list and one of the early ones stuck
out:
On 2009-07-25, Dennis Gearon gear...@sbcglobal.net wrote:
If I receive a form via POST or PUT with with mulitple variables, files,
application/json, others, is there anywhere in the environment to test he
mime type of each variable?
POST /en/html/dummy.php HTTP/1.1
looks like a PHP
On Wed, Jul 29, 2009 at 09:05:37AM -0400, mzh...@ilww.com wrote:
Caused by: org.postgresql.util.PSQLException: PANIC: could not write to
log file 6, segment 176 at offset 14991360, length 8192: Read-only file
system
You need the sysadmin to examine the OS status. It's possible the system
On Wed, Jul 29, 2009 at 01:15:27PM +, Jasen Betts wrote:
On 2009-07-23, Sam Mason s...@samason.me.uk wrote:
http://www.postgres.cz/index.php/PostgreSQL_SQL_Tricks#Attention_on_IS_NULL_and_IS_NOT_NULL_operators_for_composite_types
is scary; even worse is that it was changed to be
On Wed, Jul 29, 2009 at 1:58 PM, Jasen Bettsja...@xnet.co.nz wrote:
can't coerce a signal from the network stack? the linux socket(2)
manpage is full of promise (SIGPIPE, SIGURG, SIGIO)
[please don't quote the entire message back, just the part you're responding to]
Well SIGPIPE is no help
On Mon, Jul 27, 2009 at 09:49:04PM -0400, Tom Lane wrote:
It does not spend cycles looking aside to see if the
connection has dropped when it is doing something that doesn't involve
output to the client.
Is this ever an interesting case? It would seem possible for something
to test the client
Greg Stark gsst...@mit.edu writes:
On Wed, Jul 29, 2009 at 1:58 PM, Jasen Bettsja...@xnet.co.nz wrote:
can't coerce a signal from the network stack? the linux socket(2)
manpage is full of promise (SIGPIPE, SIGURG, SIGIO)
SIGIO on the other hand looks like exactly what we would need. I'm not
HI all,
I trying to compile several contribs in Osol. I had in result some
problems to take them work.
/opt/SUNWspro/bin/cc -Xa -xO3 -xarch=native -xspace -W0,-Lt
-W2,-Rcond_elim -Xa -xildoff -xc99=none -xCC -KPIC -I.
-I../../src/include -c -o xpath.o xpath.c
Putting child 0x080a3290 (xpath.o)
On Jul 29, 2009, at 7:02 AM, Jasen Betts wrote:
On 2009-07-27, Bob Gobeille bob.gobei...@hp.com wrote:
I would like to combine multiple databases (same schema) into one
master db. Does anyone know how I can reconcile all my primary and
foreign keys to maintain referential integrity.
Hello,
Le 29/07/09 15:02, Jasen Betts a écrit :
On 2009-07-27, Bob Gobeille bob.gobei...@hp.com wrote:
I would like to combine multiple databases (same schema) into one
master db. Does anyone know how I can reconcile all my primary and
foreign keys to maintain referential integrity.
Hi,
I've got a problem with a PG client that I'm not sure how to fix.
Essentially, I have two processes connecting to a single PG database
and simultaneously issuing the following statements:
BEGIN;
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
DELETE FROM licence_properties WHERE key = xxx;
On Jul 29, 2009, at 8:26 AM, nha wrote:
Hello,
Le 29/07/09 15:02, Jasen Betts a écrit :
On 2009-07-27, Bob Gobeille bob.gobei...@hp.com wrote:
I would like to combine multiple databases (same schema) into one
master db. Does anyone know how I can reconcile all my primary and
foreign keys
Hello,
is there in the roadmap of postgre integration of fulltext searching in
documents saved in blobs (bytea)?
For example linux antiword can export fine text output that can be inserted
into
varchar field.
Would be very very nice (postgre users can be proud to be first) to save
documents
It is posible to access to the row OID of the row which fired a pl/perl
trigger?
If I try to access to $_TD-{new}{oid} or $_TD-{old}{oid} I have no
result.
Thanks in advance!
--
Antonio José García Lagar anto...@c17.net
Compact Software International SA
http://www.c17.net
--
Sent via
I am running postgresql server on RHEL 5 system.
Greg Smith-12 wrote:
On Tue, 28 Jul 2009, mukeshp wrote:
Can anyone suggest me tools for monitoring postgresql server. ?
An idea what operating system you're running the server on would help
here.
--
* Greg Smith
Brodie Thiesfield brofield+pg...@gmail.com writes:
Essentially, I have two processes connecting to a single PG database
and simultaneously issuing the following statements:
BEGIN;
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
DELETE FROM licence_properties WHERE key = xxx;
INSERT INTO
On Wed, Jul 29, 2009 at 04:46:43PM +0200, Radek Novotnnn wrote:
is there in the roadmap of postgre integration of fulltext searching in
documents saved in blobs (bytea)?
Do you mean bytea or large-objects?
Would be very very nice (postgre users can be proud to be first) to save
documents
Antonio =?ISO-8859-1?Q?Jos=E9_Garc=EDa?= Lagar anto...@c17.net writes:
It is posible to access to the row OID of the row which fired a pl/perl
trigger?
If I try to access to $_TD-{new}{oid} or $_TD-{old}{oid} I have no
result.
It looks to me like plperl_hash_from_tuple considers only user
Hello
Dne 29. červenec 2009 16:46 Radek Novotný radek.novo...@mediawork.cz
napsal(a):
Hello,
is there in the roadmap of postgre integration of fulltext searching in
documents saved in blobs (bytea)?
What I know, no. PostgreSQL doesn't know about others binary formats,
so it cannot do it.
I have been using Windows before and that was just an installer. How can I
install and run something similar on Ubuntu ?
Thanks / Jen
On Wed, 2009-07-29 at 10:19 +0300, Peter Eisentraut wrote:
Is it weird that Database in Depth is shorter and easier than Introduction
to Database Systems? And they're by the same author, too.
I agree that it's a little strange. The former is more conceptual and
starts off assuming that you
Hello,
Le 29/07/09 16:44, Bob Gobeille a écrit :
On Jul 29, 2009, at 8:26 AM, nha wrote:
Hello,
Le 29/07/09 15:02, Jasen Betts a écrit :
On 2009-07-27, Bob Gobeille bob.gobei...@hp.com wrote:
I would like to combine multiple databases (same schema) into one
master db. Does anyone
On Wed, Jul 29, 2009 at 3:17 PM, Tom Lanet...@sss.pgh.pa.us wrote:
Greg Stark gsst...@mit.edu writes:
On Wed, Jul 29, 2009 at 1:58 PM, Jasen Bettsja...@xnet.co.nz wrote:
can't coerce a signal from the network stack? the linux socket(2)
manpage is full of promise (SIGPIPE, SIGURG, SIGIO)
And
Is this it?
http://pgfoundry.org/projects/pgtune
I thought it was EnterpriseDB. Perhaps that's only for windows?
Thanks / Jen
Greg Stark gsst...@mit.edu writes:
That is a question. But actually I think sigio might be fairly
portable -- at least the first hit I found was for someone complaining
that it wasn't working on Linux (due to a bug) and this broke their
app which worked everywhere else.
In any case this
On Wed, Jul 29, 2009 at 9:40 AM, Sam Masons...@samason.me.uk wrote:
On Wed, Jul 29, 2009 at 01:15:27PM +, Jasen Betts wrote:
On 2009-07-23, Sam Mason s...@samason.me.uk wrote:
On 07/29/2009 09:46 PM, Jennifer Trey wrote:
Is this it?
http://pgfoundry.org/projects/pgtune
I thought it was EnterpriseDB. Perhaps that's only for windows?
Thanks / Jen
You can have TuningWizard (EnterpriseDB's) for linux also available
through StackBuilder.
--
Regards,
Sachin Srivastava
Hi,
I have 2 databases running on the same server. One is a dump of the
other, however the query plans for the same query on the same tables
in each database is wildly different and I cannot work out why.
The first result below is for the dump of the database and executes in
a reasonable time.
Thanks I'll take a look into it - they query you provide seems to take
longer in the query plan but I can see where you are coming from and
it's good base to work from.
Jake
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On Wed, Jul 29, 2009 at 8:01 PM, Jake Stridej...@omelett.es wrote:
Hi,
I have 2 databases running on the same server. One is a dump of the
other, however the query plans for the same query on the same tables
in each database is wildly different and I cannot work out why.
It is posible to access to the row OID of the row which fired a pl/perl
trigger?
If I try to access to $_TD-{new}{oid} or $_TD-{old}{oid} I have no
result.
It looks to me like plperl_hash_from_tuple considers only user
attributes. Not sure if this would be worth changing.
I am trying to monitor my replication lag with pg_controldata and it's
driving me nuts.
If I run pg_controldata from the command line as user postgres or root
I get the following line
Time of latest checkpoint:Thu 30 Jul 2009 00:36:12 NZST
If I run it from the crontab I get this
On Wednesday 29 July 2009, Tim Uckun wrote:
What is the issue here? Some sort of a timezone problem? How do I tell
it what time zone to use?
Thanks.
cron runs programs in a very limited environment. Things like TZ etc. are
usually not set. To see what your cron sets, just run a shell
Bob Gobeille wrote:
On Jul 29, 2009, at 8:26 AM, nha wrote:
Hello,
Le 29/07/09 15:02, Jasen Betts a écrit :
On 2009-07-27, Bob Gobeille bob.gobei...@hp.com wrote:
I would like to combine multiple databases (same schema) into one
master db. Does anyone know how I can reconcile all my
Chris wrote:
Bob Gobeille wrote:
On Jul 29, 2009, at 8:26 AM, nha wrote:
Hello,
Le 29/07/09 15:02, Jasen Betts a écrit :
On 2009-07-27, Bob Gobeille bob.gobei...@hp.com wrote:
I would like to combine multiple databases (same schema) into one
master db. Does anyone know how I can
Hi All,
I was wondering if anyone has had this problem and knows an answer. This is
the first time I have used postgres so I am at a loss after trying many
things as to how to solve the problem.
I've unremmed the line hba_file = 'ConfigDir/pg_hba.conf' in the
postgresql.conf file as I want to
Alan Deane wrote:
Hi All,
I was wondering if anyone has had this problem and knows an answer. This
is the first time I have used postgres so I am at a loss after trying
many things as to how to solve the problem.
I've unremmed the line hba_file = 'ConfigDir/pg_hba.conf' in the
Hi Chris,
Thanks for your reply.
Maybe I should have reworded it slightly better or fuller. I assumed that
having ConfigDir/pg_hba.conf line in postgresql.conf would look for the hba
file in the directory relative to where postgres is installed. I.e. the data
directory and given that the service
Alan Deane wrote:
Hi Chris,
Thanks for your reply.
Maybe I should have reworded it slightly better or fuller. I assumed that
having ConfigDir/pg_hba.conf line in postgresql.conf would look for the hba
file in the directory relative to where postgres is installed. I.e. the data
directory and
Re-REM (called commenting for us non-windows geeks :-) the line
Look in your data directory, the file exists and is used automatically, you
don't need to point the postgresql.conf file to it explicitly.
Look at:
http://www.postgresql.org/docs/8.3/interactive/client-authentication.html
For
Ah, OK.
So what you are saying is that I don't need the 'ConfigDir/pg_hba.conf' in
postgresql.conf . I guess that makes sense as well because you would only
need that if it wasn't located in the data directory.
Although having said that, I think I uncommented it because I was having
Sorry, yes the error, Doh!.
Standard Server doesn't Listen (sounds like my ex :))
Here it is in full.
Server doesn't listen
could not connect to server; Connection timed out (0x274C/10060) Is the
server running on host 192.168.2.99 and accepting TCP/IP connection on port
5432?
As you say,
Alan Deane wrote:
Sorry, yes the error, Doh!.
Standard Server doesn't Listen (sounds like my ex :))
Here it is in full.
Server doesn't listen
could not connect to server; Connection timed out (0x274C/10060) Is the
server running on host 192.168.2.99 and accepting TCP/IP connection on
On Wed, Jul 29, 2009 at 9:14 PM, Alan Deane a...@anitltd.co.uk wrote:
Sorry, yes the error, Doh!.
Standard Server doesn't Listen (sounds like my ex :))
Here it is in full.
Server doesn't listen
could not connect to server; Connection timed out (0x274C/10060) Is the
server running on
O
cron runs programs in a very limited environment. Things like TZ etc. are
usually not set. To see what your cron sets, just run a shell script with
something like
#!/bin/sh
env
and look at the email you get with the output.
Read the cron/crontab manpage. It tells you how to set
On Thu, Jul 30, 2009 at 12:23 AM, Tom Lanet...@sss.pgh.pa.us wrote:
Brodie Thiesfield brofield+pg...@gmail.com writes:
Essentially, I have two processes connecting to a single PG database
and simultaneously issuing the following statements:
BEGIN;
SET TRANSACTION ISOLATION LEVEL
Hi Chris,
I can connect to the server locally with PgAdmin using
localhost: 5432
192.168.2.99: 5432
127.0.0.1 : 5432
As for the Windows event logs they are all fine.
The server logs. Look OK except for
%LOG: invalid length of startup packet which could have been when I was
trying to telnet
Hi Scott,
Yep, already have that set.
Thanks anyway.
Alan
_
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Scott Mead
Sent: 30 July 2009 02:45
To: a...@anitltd.co.uk
Cc: Chris; pgsql-general@postgresql.org
Subject: Re:
Ok,
I have just had a look at the firewall network monitor (Open Ports) and the
following is showing.
5432TCP POSTGRES.EXE-D G:/PROGRAM FILES/POSTGRESQL/8.3/DATA
127.0.0.1 02:11:46
4141UDP POSTGRES.EXE-D G:/PROGRAM FILES/POSTGRESQL/8.3/DATA
127.0.0.1 02:12:56
Emanuel Calvo Franco escribió:
HI all,
I trying to compile several contribs in Osol. I had in result some
problems to take them work.
/opt/SUNWspro/bin/cc -Xa -xO3 -xarch=native -xspace -W0,-Lt
-W2,-Rcond_elim -Xa -xildoff -xc99=none -xCC -KPIC -I.
-I../../src/include -c -o xpath.o
I have now isolated the problem to the firewall as suspected.
I found that when I disabled Kaspersky firewall the bloody Windows firewall
would kick in unbeknown to me.
Once that was disabled as well then I could connect from another machine on
the LAN.
So the next step is easy, configure
On Wed, Jul 29, 2009 at 9:14 PM, Alan Deane a...@anitltd.co.uk wrote:
Sorry, yes the error, Doh!.
Standard Server doesn't Listen (sounds like my ex :))
Here it is in full.
Server doesn't listen
could not connect to server; Connection timed out (0x274C/10060) Is the
server running on
I know quite a number of people here, like myself, are intrigued by the
prospect of running PostgreSQL on Amazon's EC. I thought this blog post on the
performance of EBS was interesting, so I figure I'd share it with everybody.
http://orion.heroku.com/past/2009/7/29/io_performance_on_ebs/
John Cheng jlch...@ymail.com writes:
I know quite a number of people here, like myself, are intrigued by the
prospect of running PostgreSQL on Amazon's EC. I thought this blog post on
the performance of EBS was interesting, so I figure I'd share it with
everybody.
On Wed, Jul 29, 2009 at 19:53, Brodie
Thiesfieldbrofield+pg...@gmail.com wrote:
On further investigation, since the logic requires the delete to be
made first to get rid of other possible rows, so I'll go with:
DELETE
(if supported) INSERT OR REPLACE
(otherwise) INSERT, if
78 matches
Mail list logo