Whit Armstrong wrote:
anyone know a way to get nagios to monitor the number of postgres connections?
Thanks,
Whit
Hello
We use this plugin. Save it under /etc/munin/plugins/pg_connections and
update the file /etc/munin/plugin-conf.d/postgres with:
---
[pg_connection]
Rafael Martinez wrote:
Whit Armstrong wrote:
anyone know a way to get nagios to monitor the number of postgres
connections?
Thanks,
Whit
Hello
We use this plugin. Save it under /etc/munin/plugins/pg_connections and
update the file /etc/munin/plugin-conf.d/postgres with:
And of
Hi ,
I am working on project which include merging of two databases within
postgresql on Linux. I have searched for s/w but didnt get any useful. So
if any one having any information about such s/w please help me out. This
s/w should have GPL. (Opensource s/w). I want to sync two database i.e.
subodh chaudhari wrote:
Hi ,
I am working on project which include merging of two databases within
postgresql on Linux. I have searched for s/w but didnt get any
useful. So if any one having any information about such s/w please
help me out. This s/w should have GPL. (Opensource s/w). I want
Your problem is currently sounding very much like an exam question; you
seem to be arbitrarily making decisions without showing any real data.
When you deal with real problems in the real world you're normally
making compromises when you model things and hence the decisions
wouldn't be as
Hi All,
I recently installed PostgreSQL 8.3.7 into my windows xp m/c.
When I start PostgreSQL server through
My computercontrol panelAdministrative toolsservicesPostgreSQL
serverstart
NOT STARTED and the following error mesage appeared:
some services started and stoped because of they have no
I'm trying to diagnose a problem that happened during vacuum full.
It is a programming problem triggered by some lock, delay whatever,
happening during vacuum.
Making large updates to a bunch of tables is a PITA just to obtain a
slow VACUUM FULL.
Restoring a fragmented DB doesn't look as a
Chandra Sekar R wrote:
I recently installed PostgreSQL 8.3.7 into my windows xp m/c.
When I start PostgreSQL server through
My computercontrol panelAdministrative toolsservicesPostgreSQL
serverstart
NOT STARTED and the following error mesage appeared:
some services started and stoped
I noticed in the temporal project they used reserved words for their
functions (union, intersect, etc)
But when I try to create a function like that I get an error and I have
to quote it both when creating the function and when calling it. The
only difference I can see is they their functions
subodh chaudhari, 17.06.2009 09:05:
Hi ,
I am working on project which include merging of two databases within
postgresql on Linux. I have searched for s/w but didnt get any useful.
So if any one having any information about such s/w please help me out.
This s/w should have GPL. (Opensource
In response to Ivan Sergio Borgonovo m...@webthatworks.it:
I'm trying to diagnose a problem that happened during vacuum full.
What _is_ the problem?
It is a programming problem triggered by some lock, delay whatever,
happening during vacuum.
The solution is to fix the lock, delay, or
Greetings. I am in the process of deciding my infrastruture for a web
based application dealing with audio, video and image files. In my
discussions with web developers PostgreSql came up as a candidate for my
database. This is my FIRST introduction to this database, although I've
heard of it - I
In response to Mike Kay mike...@channelk.ca:
Greetings. I am in the process of deciding my infrastruture for a web
based application dealing with audio, video and image files. In my
discussions with web developers PostgreSql came up as a candidate for my
database. This is my FIRST
I had a few queries that were fired from pgAdmin, but failed to stop
running after I killed the GUI.
I tried to stop the queries by killing the pid (of the process running
the query, not the pid of the server) from the linux command line, and
much to my surprise, the whole database went down and
We are testing full text searching on a small chunk of our data. We
have created an INDEX to make searching faster. From the PostgreSQL
8.3 docs, we are running 8.3.7, it seems we should be running GIN
indexes. The reason GIN on paper seems like the right INDEX:
* we have static data
* we have
On Wed, Jun 17, 2009 at 01:46:13AM -0700, Scott Bailey wrote:
I noticed in the temporal project they used reserved words for their
functions (union, intersect, etc)
But when I try to create a function like that I get an error and I have
to quote it both when creating the function and when
On Tue, Jun 16, 2009 at 10:06:54AM -0400, Tom Lane wrote:
Albe Laurenz laurenz.a...@wien.gv.at writes:
So it looks like the number of result rows is the least common
multiple of the cardinalities of all columns in the select list.
It's always been that way. The lack of any obviously-sane
David Fetter da...@fetter.org writes:
On Tue, Jun 16, 2009 at 10:06:54AM -0400, Tom Lane wrote:
It's always been that way. The lack of any obviously-sane way to
handle multiple SRFs in a targetlist is exactly why the feature is
looked on with disfavor.
I must be missing something obvious.
Hi,
First, the numbers:
PG VersionLoad time pg_database_size autovac
--
8.2.13179 min 92,807,992,820on
8.3.7 180 min 84,048,744,044on (defaults)
8.4b2 206 min
I am running postgres 8.3.7 on windows server 2008 SP1. But this error
alway occur : FATAL: could not reattach to shared memory (key=260,
addr=0240): 487
.Here is my log
2009-06-17 20:45:18 ICT LOG: database system was shut down at
2009-06-17 17:42:45 ICT
2009-06-17 20:45:22 ICT LOG:
Tom Lane wrote:
It's always been that way. The lack of any obviously-sane way to
handle multiple SRFs in a targetlist is exactly why the feature is
looked on with disfavor.
It is clear that there is no really good way to handle this.
How about my last example that involved aggregate
On Tue, Jun 16, 2009 at 12:50:28PM +0100, Greg Stark wrote:
On Mon, Jun 15, 2009 at 2:04 PM, Gnanamgna...@zoniac.com wrote:
I also read some article which talks about the type of patterns:
1. Meta-database
2. Mutating
3. Fixed
4. LOB
My question here is, what is the best approach
Scott Bailey arta...@comcast.net writes:
I noticed in the temporal project they used reserved words for their
functions (union, intersect, etc)
Uh, what project is that exactly, and was it even working within
Postgres?
But when I try to create a function like that I get an error and I have
Whit Armstrong armstrong.w...@gmail.com writes:
I had a few queries that were fired from pgAdmin, but failed to stop
running after I killed the GUI.
I tried to stop the queries by killing the pid (of the process running
the query, not the pid of the server) from the linux command line, and
Aaron aa...@chasingnuts.com writes:
CREATE INDEX profile_images_fulltext_gin ON profile_images_fulltext
USING gin(content);
CREATE INDEX profile_images_fulltext_gist ON profile_images_fulltext
USING gist(content);
What did you have maintenance_work_mem set to while you did this?
GIST doesn't
Now that's an interesting way of doing this I never thought about before.
Using a fileserver though, how would I categorize and index the files?
I was planning on using multiple databases to hold the data - one for each
client and a separate database for each file type. Yes, they would be
hosted
Thanks, Tom.
Lesson learned.
Are there any integrity checks I need to run on the db after this type
of crash and recovery, or is vacuum --all good enough?
-Whit
On Wed, Jun 17, 2009 at 11:19 AM, Tom Lanet...@sss.pgh.pa.us wrote:
Whit Armstrong armstrong.w...@gmail.com writes:
I had a few
Albe Laurenz laurenz.a...@wien.gv.at writes:
How about my last example that involved aggregate functions, where
I surprisingly got only one result row?
Oh, you're right, now that I look closer that one is a bug. Fixed.
regards, tom lane
--
Sent via pgsql-general
Whit Armstrong armstrong.w...@gmail.com writes:
Are there any integrity checks I need to run on the db after this type
of crash and recovery, or is vacuum --all good enough?
There isn't anything you need to do. Postgres crashes don't corrupt
on-disk data, as a general rule, and a SIGKILL crash
On Jun 17, 2009, at 8:43 AM, Mike Kay wrote:
Now that's an interesting way of doing this I never thought about
before.
Using a fileserver though, how would I categorize and index the files?
I was planning on using multiple databases to hold the data - one
for each
client and a separate
Thanks. That's a relief.
getting a few page xxx is uninitialized --- fixing warnings in the
vacuum output, but seems like this should be expected since I killed
an insert in progress.
can anyone confirm that these warnings are ok?
WARNING: relation balances_primary page 1883404 is
Tom,
Our maintenance_work_mem is 1024MB so there should have been plenty of
memory for INDEX creation. I happened to be watching top when we
created the GiN INDEX and the process used about 500MB of non-shared
memory.
Aaron Thul
http://www.chasingnuts.com
On Wed, Jun 17, 2009 at 11:30 AM,
Hi,
I'm trying to get lo size via libpq before starting reading it (postgres
server 8.3.5). lo_lseek always returns 4 (actual size is 1M).
I query table with select photo from employee where id=''. It returns
lo oid integer as expected. Then I use following code to obtain size of the
lo
Uh, what project is that exactly, and was it even working within Postgres?
The project is http://pgfoundry.org/projects/temporal/
But it looks like I'm just stupid or confused (or confused and stupid). I'm
working on porting temporal extensions I wrote originally for Oracle to
Postgres.
DB version: PostgreSQL 8.3.6 (under linux)
no server/db crashes happen before.
Server was slave in slony replication.
Now problem:
table was unsubscribed from replication (without any errors)
and then dropped from master without any errors
But when i try drop table from slave i got very
So, I threw this together last night. It's not pretty, it's not
perfect, but it works well enough. There are two files, attached,
mkstp and mktrig. Both are php programs. The first, mkstp makes
partitions. mkstp checks to see if a partition table already exists,
if it does it goes on to the
Aaron,
did you actually check performance of search in both cases ?
GiST index can be small but very inefficient, since top-level
signatures can be degenerated, so we just remove them. It's easy to
see that looking in explain analyze - see difference between number of
rows found by index and
I found the reason - it was bug in my code when inserting lo object. It's
size was actually 4.
Please ignore or delete my post.
On Wed, Jun 17, 2009 at 11:38 AM, Konstantin Izmailov
kizmai...@gmail.comwrote:
Hi,
I'm trying to get lo size via libpq before starting reading it (postgres
server
Out of curiosity, what if lo object has size 4GB, how lo_tell return its
size? Looks like this is an interface issue.
I found a post dated back to 1998, when somebody pointed it out and a
posgres developer promised to fix it.
Thank you all
On Wed, Jun 17, 2009 at 3:15 PM, Konstantin Izmailov
Whit Armstrong armstrong.w...@gmail.com writes:
getting a few page xxx is uninitialized --- fixing warnings in the
vacuum output, but seems like this should be expected since I killed
an insert in progress.
Yeah, that isn't too surprising. When a table runs out of space the
first thing we do
Maxim Boguk mbo...@masterhost.ru writes:
Server was slave in slony replication.
Now problem:
table was unsubscribed from replication (without any errors)
and then dropped from master without any errors
But when i try drop table from slave i got very strange error:
hh=# drop TABLE
Steve Atkins wrote:
On Jun 17, 2009, at 8:43 AM, Mike Kay wrote:
Now that's an interesting way of doing this I never thought about
before.
Using a fileserver though, how would I categorize and index the files?
I was planning on using multiple databases to hold the data - one for
each
Konstantin Izmailov pgf...@gmail.com writes:
Out of curiosity, what if lo object has size 4GB, how lo_tell return its
size? Looks like this is an interface issue.
That's simple: it can't have such a size.
Allowing LOs bigger than 2GB is on the TODO list, but don't hold your
breath. Most
2009/6/17 Maxim Boguk mbo...@masterhost.ru:
DB version: PostgreSQL 8.3.6 (under linux)
no server/db crashes happen before.
Server was slave in slony replication.
Now problem:
table was unsubscribed from replication (without any errors)
and then dropped from master without any errors
But
Scott Marlowe scott.marl...@gmail.com writes:
We've run into issues with drop table and slony as well. What version
of slony are you running? We're running 1.2.14. Latest version in
that branch in 1.2.16, but we haven't had cause to upgrade to it just
yet. I'll be looking at 2.0.latest and
It would be great to remove the limitation. I can image various
possibilities if Postgres can handle larger lo objects. For example, to
stream HD content from DB to a multimedia device for displaying.
Would that be technically hard to do? My impression is that lo has pretty
scalable
46 matches
Mail list logo