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=UTF8&s=books&qid=1248742811&sr=1-5
> >
> > a
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 ch
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, t
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
gives
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, a
On Wed, Jul 29, 2009 at 12:08, Craig Ringer 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 using "T
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.
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
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
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.
exp
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 wo
2009/7/29 A. Kretschmer :
> 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
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: SQLExcepti
On Wed, Jul 29, 2009 at 3:27 AM, Peter Eisentraut 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 advantage
On 2009-07-28, Tom Lane wrote:
> Robert James 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?
>
> No.
>
>> 2) Is there a way to tell
On 2009-07-27, Bob Gobeille 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 their source database
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; -
n
On 2009-07-23, Sam Mason 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:
>
>
> http://www.postgres.cz/index.php/PostgreSQL_SQL_Tr
On 2009-07-25, Dennis Gearon 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 question to me
http://nz2
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 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 like this in
On Wed, Jul 29, 2009 at 1:58 PM, Jasen Betts 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 since it would onl
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 clie
Greg Stark writes:
> On Wed, Jul 29, 2009 at 1:58 PM, Jasen Betts 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
> sure if it can be set to
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 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 some
Hello,
Le 29/07/09 15:02, Jasen Betts a écrit :
> On 2009-07-27, Bob Gobeille 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
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;
INS
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 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 referent
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 i
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
Compact Software International SA
http://www.c17.net
--
Sent via pgsql-general mailing
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 gsm...@g
Brodie Thiesfield 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 licence_properties ... v
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
> document
Antonio =?ISO-8859-1?Q?Jos=E9_Garc=EDa?= Lagar 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
attributes.
Hello
Dne 29. červenec 2009 16:46 Radek Novotný
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.
> For example linux antiw
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 y
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 wrote:
I would like to combine multiple databases (same schema) into one
master db. Does anyone kno
On Wed, Jul 29, 2009 at 3:17 PM, Tom Lane wrote:
> Greg Stark writes:
>> On Wed, Jul 29, 2009 at 1:58 PM, Jasen Betts wrote:
>>> can't coerce a signal from the network stack? the linux socket(2)
>>> manpage is full of promise (SIGPIPE, SIGURG, SIGIO)
>
>
> And the other question is how much of wha
Is this it?
http://pgfoundry.org/projects/pgtune
I thought it was EnterpriseDB. Perhaps that's only for windows?
Thanks / Jen
Greg Stark 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 would be a feat
On Wed, Jul 29, 2009 at 9:40 AM, Sam Mason wrote:
> On Wed, Jul 29, 2009 at 01:15:27PM +, Jasen Betts wrote:
>> On 2009-07-23, Sam Mason wrote:
>> >
>> > http://www.postgres.cz/index.php/PostgreSQL_SQL_Tricks#Attention_on_IS_NULL_and_IS_NOT_NULL_operators_for_composite_types
>> >
>> > is sc
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. Th
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:
http://www.pos
On Wed, Jul 29, 2009 at 8:01 PM, Jake Stride 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 changin
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 out
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 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
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 wrote:
I would like to combine multiple databases (same schema) into one
master db. Does anyone know how I can reconcile all my primary an
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
postgresql
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 giv
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 deta
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
troub
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 port
On Wed, Jul 29, 2009 at 9:14 PM, 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
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 Lane wrote:
> Brodie Thiesfield 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_properti
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 in.
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: [GENER
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:5
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 xpat
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 Kasper
On Wed, Jul 29, 2009 at 9:14 PM, 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
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 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.
> http://orion.heroku.com/past/2009/7/2
On Wed, Jul 29, 2009 at 19:53, Brodie
Thiesfield 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 duplicate key, UPDATE
>
Hi,
is there a reason why pg_stat_activity is not documented in the chapter "System Catalogs"?
Is this not a "offical" view?
Regards
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-ge
On Wed, 2009-07-29 at 14:56 +0100, Greg Stark wrote:
> SIGURG might be useful but it would be more complex to use and less
> widely useful since it would only work if the client disconnects
> gracefully (though it might be worth checking into as an alternative
> to our existing query cancel method
76 matches
Mail list logo
