On 9/22/11 6:59 PM, Euler Taveira de Oliveira eu...@timbira.com wrote:
If needed, I could do that, if I had the exact procedure... Currently,
during the start of the backup I take the following information:
Just show us the output of pg_start_backup and part of the standby log with
the
On 23.09.2011 11:02, Linas Virbalas wrote:
On 9/22/11 6:59 PM, Euler Taveira de Oliveiraeu...@timbira.com wrote:
If needed, I could do that, if I had the exact procedure... Currently,
during the start of the backup I take the following information:
Just show us the output of pg_start_backup
On Sep23, 2011, at 10:41 , Heikki Linnakangas wrote:
On 23.09.2011 11:02, Linas Virbalas wrote:
On 9/22/11 6:59 PM, Euler Taveira de Oliveiraeu...@timbira.com wrote:
If needed, I could do that, if I had the exact procedure... Currently,
during the start of the backup I take the following
On 23.09.2011 11:48, Florian Pflug wrote:
On Sep23, 2011, at 10:41 , Heikki Linnakangas wrote:
On 23.09.2011 11:02, Linas Virbalas wrote:
On 9/22/11 6:59 PM, Euler Taveira de Oliveiraeu...@timbira.com wrote:
If needed, I could do that, if I had the exact procedure... Currently,
during the
Hi, I think I have comprehended roughly around the constructs and
the concept underlying.
At Thu, 22 Sep 2011 12:35:56 -0400, Tom Lane t...@sss.pgh.pa.us wrote in
23159.1316709...@sss.pgh.pa.us
tgl Sure, if the increment the top byte strategy proves to not accomplish
tgl that effectively. But
On Wed, Aug 31, 2011 at 11:59, Srinivas Aji srinivas@emc.com wrote:
The following bug has been logged online:
Bug reference: 6189
Logged by: Srinivas Aji
Email address: srinivas@emc.com
PostgreSQL version: 9.0.4
Operating system: Linux
Description:
On Fri, Sep 23, 2011 at 12:26 AM, Pavel Stehule pavel.steh...@gmail.com wrote:
I fixed crash that described Tom. Do you know about other?
No, I just don't see a new version of the patch.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via
2011/9/23 Robert Haas robertmh...@gmail.com:
On Fri, Sep 23, 2011 at 12:26 AM, Pavel Stehule pavel.steh...@gmail.com
wrote:
I fixed crash that described Tom. Do you know about other?
No, I just don't see a new version of the patch.
sorry - my mistake - I sent it only to Tom
Regards
Pavel
Hello list,
I have a use case where an extension dependency can be satisfied by one
of five other extensions. Currently I'm unable to express that in the
extension control file, since the elements from 'requires' are currently
searched on exact name match. The attached patch changes this
On 23.09.2011 14:56, Yeb Havinga wrote:
I have a use case where an extension dependency can be satisfied by one
of five other extensions. Currently I'm unable to express that in the
extension control file, since the elements from 'requires' are currently
searched on exact name match. The
From: Magnus Hagander mag...@hagander.net
To: Srinivas Aji srinivas@emc.com
Cc: PostgreSQL-development pgsql-hackers@postgresql.org
Sent: Friday, September 23, 2011 7:28:09 AM
Subject: [HACKERS] Re: [BUGS] BUG #6189: libpq: sslmode=require verifies server
certificate if root.crt is
On Fri, Sep 23, 2011 at 14:35, Lou Picciano loupicci...@comcast.net wrote:
On Wed, Aug 31, 2011 at 11:59, Srinivas Aji srinivas@emc.com wrote:
The following bug has been logged online:
Bug reference: 6189
Logged by: Srinivas Aji
Email address: srinivas@emc.com
On Thu, Sep 22, 2011 at 10:36 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Anyway, I won't stand in the way of the patch as long as it's modified
to limit the number of values considered for any one character position
to something reasonably small.
I think that limit in both the old and new code is
On Fri, Sep 23, 2011 at 5:16 AM, Kyotaro HORIGUCHI
horiguchi.kyot...@oss.ntt.co.jp wrote:
Can I have another chance to show the another version of the
patch according to the above?
You can always post a new version of any patch.
I think what you need to focus on is cleaning up the coding style
On 9/23/11 12:05 PM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
It looks to me that pg_clog/0001 exists, but it shorter than recovery
expects. Which shouldn't happen, of course, because the start-backup
checkpoint should flush all the clog that's needed by recovery to disk
On Fri, Sep 23, 2011 at 8:38 AM, Magnus Hagander mag...@hagander.net wrote:
On Fri, Sep 23, 2011 at 14:35, Lou Picciano loupicci...@comcast.net wrote:
On Wed, Aug 31, 2011 at 11:59, Srinivas Aji srinivas@emc.com wrote:
The following bug has been logged online:
Bug reference: 6189
Robert Haas robertmh...@gmail.com writes:
On Thu, Sep 22, 2011 at 10:36 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Anyway, I won't stand in the way of the patch as long as it's modified
to limit the number of values considered for any one character position
to something reasonably small.
I think
On Fri, Sep 23, 2011 at 8:47 AM, Linas Virbalas
linas.virba...@continuent.com wrote:
But on the standby its size is the old one (thus, it seems, that the size
changed after the rsync transfer and before the pg_stop_backup() was
called):
Now that seems pretty weird - I don't think that file
Magnus Hagander mag...@hagander.net writes:
I looked at this again, and I'm pretty sure we did this intentionally.
Yeah, we did.
Or should we just update the documentation to mention how this works?
+1 for doc change only. I think the behavior was thought through
carefully, and the wording
From: Magnus Hagander mag...@hagander.net
To: Lou Picciano loupicci...@comcast.net
Cc: PostgreSQL-development pgsql-hackers@postgresql.org, Srinivas Aji
srinivas@emc.com
Sent: Friday, September 23, 2011 8:38:00 AM
Subject: Re: [HACKERS] Re: [BUGS] BUG #6189: libpq: sslmode=require
On Fri, Sep 23, 2011 at 8:51 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com writes:
On Thu, Sep 22, 2011 at 10:36 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Anyway, I won't stand in the way of the patch as long as it's modified
to limit the number of values considered for
On Thu, Sep 22, 2011 at 12:45 PM, Fujii Masao masao.fu...@gmail.com wrote:
Agreed. Attached is the updated version of the patch. It adds two options
--replication and --no-replication. If neither specified, neither REPLICATION
nor NOREPLICATION is specified in CREATE ROLE, i.e., in this case,
On 2011-09-23 14:19, Heikki Linnakangas wrote:
On 23.09.2011 14:56, Yeb Havinga wrote:
I have a use case where an extension dependency can be satisfied by one
of five other extensions. Currently I'm unable to express that in the
extension control file, since the elements from 'requires' are
On Thu, Sep 15, 2011 at 4:52 AM, Fujii Masao masao.fu...@gmail.com wrote:
Thanks for the review!
Koyotaro Horiguchi -
Are you going to re-review the latest version of this patch?
Thanks,
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via
On Fri, Sep 23, 2011 at 14:49, Robert Haas robertmh...@gmail.com wrote:
On Fri, Sep 23, 2011 at 8:38 AM, Magnus Hagander mag...@hagander.net wrote:
On Fri, Sep 23, 2011 at 14:35, Lou Picciano loupicci...@comcast.net wrote:
On Wed, Aug 31, 2011 at 11:59, Srinivas Aji srinivas@emc.com wrote:
On Wed, Sep 21, 2011 at 12:19 PM, Andres Freund and...@anarazel.de wrote:
/*
* We also disallow data-modifying WITH in a cursor. (This could be
* allowed, but the semantics of when the updates occur might be
* surprising.)
*/
if
2011/9/23 Robert Haas robertmh...@gmail.com:
On Thu, Sep 22, 2011 at 12:45 PM, Fujii Masao masao.fu...@gmail.com wrote:
Agreed. Attached is the updated version of the patch. It adds two options
--replication and --no-replication. If neither specified, neither REPLICATION
nor NOREPLICATION is
2011/9/23 Cédric Villemain cedric.villemain.deb...@gmail.com:
2011/9/23 Robert Haas robertmh...@gmail.com:
On Thu, Sep 22, 2011 at 12:45 PM, Fujii Masao masao.fu...@gmail.com wrote:
Agreed. Attached is the updated version of the patch. It adds two options
--replication and --no-replication. If
Excerpts from Magnus Hagander's message of vie sep 23 10:39:46 -0300 2011:
On Fri, Sep 23, 2011 at 14:49, Robert Haas robertmh...@gmail.com wrote:
On Fri, Sep 23, 2011 at 8:38 AM, Magnus Hagander mag...@hagander.net
wrote:
On Fri, Sep 23, 2011 at 14:35, Lou Picciano
[ moving to -hacker s]
On Thu, Sep 22, 2011 at 9:26 PM, Thom Brown t...@linux.com wrote:
On 22 September 2011 17:38, Josh Berkus j...@agliodbs.com wrote:
So are there any plans to allow swappable drive/volatile storage
unlogged tables?
Be our guest. ;-)
Oh it can't be that difficult. On
On Fri, Sep 23, 2011 at 15:55, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Excerpts from Magnus Hagander's message of vie sep 23 10:39:46 -0300 2011:
On Fri, Sep 23, 2011 at 14:49, Robert Haas robertmh...@gmail.com wrote:
On Fri, Sep 23, 2011 at 8:38 AM, Magnus Hagander
2011/8/16 Anssi Kääriäinen anssi.kaariai...@thl.fi:
On 08/14/2011 12:31 AM, Heikki Linnakangas wrote:
The same idea could of course be used to calculate the effective cache
hit ratio for each table. Cache hit ratio would have the problem of feedback
loops, though.
Yeah, I'm not excited
On 23 September 2011 15:12, Robert Haas robertmh...@gmail.com wrote:
[ moving to -hacker s]
On Thu, Sep 22, 2011 at 9:26 PM, Thom Brown t...@linux.com wrote:
On 22 September 2011 17:38, Josh Berkus j...@agliodbs.com wrote:
So are there any plans to allow swappable drive/volatile storage
Excerpts from Magnus Hagander's message of vie sep 23 11:31:37 -0300 2011:
On Fri, Sep 23, 2011 at 15:55, Alvaro Herrera
alvhe...@commandprompt.com wrote:
This seems strange to me. Why not have a second option to let the user
indicate the desired SSL verification?
On Fri, Sep 9, 2011 at 11:28 PM, Peter Geoghegan pe...@2ndquadrant.com wrote:
It's very difficult or impossible to anticipate how effective the tool
will be in practice, but when you consider that it works and does not
produce false positives for the first 3 real-world cases tested, it
seems
On Friday 23 Sep 2011 15:42:48 Robert Haas wrote:
On Wed, Sep 21, 2011 at 12:19 PM, Andres Freund and...@anarazel.de wrote:
/*
* We also disallow data-modifying WITH in a cursor. (This could
be * allowed, but the semantics of when the updates occur might be *
surprising.)
On Fri, Sep 23, 2011 at 10:37 AM, Thom Brown t...@linux.com wrote:
Couldn't this come under tablespace changes then? After all the
use-case stated would require a separate tablespace, and you could do
something like:
CREATE VOLATILE TABLESPACE drive_made_of_wax_left_in_the_sun LOCATION
On Fri, Sep 23, 2011 at 10:54 AM, Robert Haas robertmh...@gmail.com wrote:
CREATE TABLESPACE now_you_see_me_now_you_dont LOCATION
'/mnt/highly_reliable_san' VOLATILE LOCATION '/mnt/ramdisk';
All forks of temporary relations, and all non-_init forks of
non-temporary relations, could be stored
On Fri, Sep 23, 2011 at 10:53 AM, Andres Freund and...@anarazel.de wrote:
One could argue that its a easier to implement it using a wCTE because the
query will be simply materialize the query upfront.
That makes handling the case where somebody fetches 3 tuples from a query
updating 10 easier.
On Thu, Sep 22, 2011 at 10:45 PM, Jeff Davis pg...@j-davis.com wrote:
+ for (i = 0; i num_items; ++i)
+ /* do something with q-items[i] */
+
+This code turns out to be unsafe, because the writer might increment
+q-num_items before it finishes storing the new item into the
But on the standby its size is the old one (thus, it seems, that the size
changed after the rsync transfer and before the pg_stop_backup() was
called):
Now that seems pretty weird - I don't think that file should ever shrink.
It seems, I was not clear in my last example. The pg_clog file
On 23 September 2011 15:56, Robert Haas robertmh...@gmail.com wrote:
On Fri, Sep 23, 2011 at 10:54 AM, Robert Haas robertmh...@gmail.com wrote:
CREATE TABLESPACE now_you_see_me_now_you_dont LOCATION
'/mnt/highly_reliable_san' VOLATILE LOCATION '/mnt/ramdisk';
All forks of temporary relations,
On tis, 2011-09-20 at 16:38 -0400, Robert Haas wrote:
For now, I think we're best off not changing the terminology, and
confining the remit of this patch to (a) turning all of the existing
recovery.conf parameters into GUCs and (b) replacing recovery.conf
with a sentinel file a sentinel file
On Fri, Sep 23, 2011 at 4:41 AM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
Unfortunately, it's impossible, because the error message Could not read
from file pg_clog/0001 at offset 32768: Success is shown (and startup
aborted) before the turn for redo starts at message
Excerpts from Linas Virbalas's message of vie sep 23 09:47:20 -0300 2011:
On 9/23/11 12:05 PM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
But on the standby its size is the old one (thus, it seems, that the size
changed after the rsync transfer and before the
On Sep 23, 2011 5:59 PM, Alvaro Herrera alvhe...@commandprompt.com
wrote:
Excerpts from Linas Virbalas's message of vie sep 23 09:47:20 -0300 2011:
On 9/23/11 12:05 PM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
But on the standby its size is the old one (thus, it
Hi,
On Wednesday 21 Sep 2011 16:44:30 Linas Virbalas wrote:
2011-09-21 13:41:05 CEST DETAIL: Could not read from file pg_clog/0001
at offset 32768: Success.
Any chance you can attach gdb to the startup process and provide a backtrace
from the place where this message is printed?
Greetings,
On Tue, Sep 20, 2011 at 5:23 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Simon Riggs si...@2ndquadrant.com writes:
I sympathise with this view, to an extent.
If people want to put all parameters in one file, they can do so. So +1 to
that.
Should they be forced to adopt that new capability by us
On 09/20/2011 09:23 AM, Tom Lane wrote:
Simon Riggssi...@2ndquadrant.com writes:
I sympathise with this view, to an extent.
If we do an automatic include of recovery.conf first, then follow by
reading postgresql,conf then we will preserve the old as well as
allowing the new.
I don't
On Tue, Aug 30, 2011 at 6:38 AM, Pavan Deolasee
pavan.deola...@gmail.com wrote:
Yeah. If we don't know the status of the vacuum that collected the
line pointer and marked it vacuum-dead, the next vacuum will pick it
up again and stamp it with its own generation number.
I'm still not really
I'm OK with the proposed behavior change and I agree that it's
probably what people want, but I am awfully suspicious that those
extra casts are going to break something you haven't thought about.
It might be worth posting a rough version first just to see if I (or
someone else) can break it
On 23.09.2011 19:03, Magnus Hagander wrote:
On Sep 23, 2011 5:59 PM, Alvaro Herreraalvhe...@commandprompt.com
wrote:
Excerpts from Linas Virbalas's message of vie sep 23 09:47:20 -0300 2011:
On 9/23/11 12:05 PM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
But on the
On Fri, Sep 23, 2011 at 11:43 AM, Aidan Van Dyk ai...@highrise.ca wrote:
On Fri, Sep 23, 2011 at 4:41 AM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
Unfortunately, it's impossible, because the error message Could not read
from file pg_clog/0001 at offset 32768: Success is
On Sep23, 2011, at 18:03 , Magnus Hagander wrote:
On Sep 23, 2011 5:59 PM, Alvaro Herrera alvhe...@commandprompt.com wrote:
Sounds like rsync is caching the file size at the start of the run, and
then copying that many bytes, ignoring the growth that occurred after it
started.
That
On Sep23, 2011, at 18:45 , Robert Haas wrote:
Ah. I think you are right - Heikki made the same point. Maybe some
of the stuff that happens just after this comment:
/*
* Initialize for Hot Standby, if enabled. We won't let backends in
* yet, not until we've reached
Simon,
There are many. Tools I can name include pgpool, 2warm, PITRtools, but
there are also various tools from Sun, an IBM reseller I have
forgotten the name of, OmniTI and various other backup software
providers. Those are just the ones I can recall quickly. We've
encouraged people to
On 23.09.2011 19:49, Florian Pflug wrote:
On Sep23, 2011, at 18:45 , Robert Haas wrote:
Ah. I think you are right - Heikki made the same point. Maybe some
of the stuff that happens just after this comment:
/*
* Initialize for Hot Standby, if enabled. We won't let backends in
On Fri, Sep 23, 2011 at 12:37 PM, Josh Berkus j...@agliodbs.com wrote:
I'm OK with the proposed behavior change and I agree that it's
probably what people want, but I am awfully suspicious that those
extra casts are going to break something you haven't thought about.
It might be worth posting
On Fri, Sep 23, 2011 at 12:51 PM, Josh Berkus j...@agliodbs.com wrote:
I'm happy to make upgrades easier, but I want a path which eventually
ends in recovery.conf going away. It's a bad API, confuses our users,
and is difficult to support and maintain.
I agree.
GUC = Grand Unified
One idea:
col like 'foo%' could be translated to col = 'foo' and col = foo || 'zzz' ,
where 'z' is the largest possible character. This should be good enough for
calculating stats.
How to find such a character, i do not know.
--
Sent via pgsql-hackers mailing list
On Thu, Sep 1, 2011 at 12:18 PM, Josh Berkus j...@agliodbs.com wrote:
On 8/31/11 12:15 PM, Merlin Moncure wrote:
An out of process, autonomous transaction type implementation should
probably not sit under stored procedures for a number of reasons --
mainly that it's going to expose too many
On Fri, Sep 23, 2011 at 11:36 AM, Thom Brown t...@linux.com wrote:
On 23 September 2011 15:56, Robert Haas robertmh...@gmail.com wrote:
On Fri, Sep 23, 2011 at 10:54 AM, Robert Haas robertmh...@gmail.com wrote:
CREATE TABLESPACE now_you_see_me_now_you_dont LOCATION
'/mnt/highly_reliable_san'
On Fri, Sep 23, 2011 at 12:58 PM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
There are pretty clear rules on what state clog can be in. When you launch
postmaster in a standby:
* Any clog preceding the nextXid from the checkpoint record we start
recovery from, must either
On Mon, Sep 19, 2011 at 4:36 PM, Dan McGee d...@archlinux.org wrote:
[ patch ]
I suppose it's Tom who really needs to comment on this, but I'm not
too enthusiastic about this approach. Duplicating the Linux kernel
calculation into our code means that we could drift if the formula
changes again.
On 23 September 2011 15:46, Robert Haas robertmh...@gmail.com wrote:
I'm not opposed to adding something like this, but I think it needs to
either be tied into the actual running of the script, or have a lot
more documentation than it does now, or both. I am possibly stupid,
but I can't
On Mon, Sep 12, 2011 at 5:45 AM, Kohei KaiGai kai...@kaigai.gr.jp wrote:
The attached patch is a portion that we splitted off when we added
pg_shseclabel system catalog.
It enables the control/sepgsql to assign security label on pg_database
objects that are utilized as a basis to compute a
On Sep23, 2011, at 17:46 , Peter Eisentraut wrote:
On tis, 2011-09-20 at 16:38 -0400, Robert Haas wrote:
For now, I think we're best off not changing the terminology, and
confining the remit of this patch to (a) turning all of the existing
recovery.conf parameters into GUCs and (b) replacing
On Thu, Sep 22, 2011 at 11:31 AM, Robert Haas robertmh...@gmail.com wrote:
On Thu, Sep 22, 2011 at 11:25 AM, Thom Brown t...@linux.com wrote:
s/visca-versa/vice-versa/
s/laods/loads/
Fixed. v4 attached.
Since it seems like people are fairly happy with this now, I've gone
ahead and committed
On Mon, Sep 12, 2011 at 3:31 PM, Kohei KaiGai kai...@kaigai.gr.jp wrote:
I updated the patches of fix-leaky-view problem, according to the
previous discussion.
The NOLEAKY option was replaced by LEAKPROOF option, and several
regression
test cases were added. Rest of stuffs are unchanged.
Josh,
There are many. Tools I can name include pgpool, 2warm, PITRtools, but
there are also various tools from Sun, an IBM reseller I have
forgotten the name of, OmniTI and various other backup software
providers. Those are just the ones I can recall quickly. We've
encouraged people to write
I'm not sure what you mean by not deal with but part of pgpool-II's
functionality assumes that we can easily generate recovery.conf. If
reconf.conf is integrated into postgresql.conf, we need to edit
postgresql.conf, which is a little bit harder than generating
recovery.conf, I think.
Oh?
71 matches
Mail list logo