Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Do you want me to do the legwork for this to happen, or was your initial
> plan to do it yourself? Either way is OK with me ...
I'm working on it, should have it done in a day or so.
regards, tom lane
-
OK, I talked to Tom about this patch and I understand the issues now.
I think the best solution will be to have the postmaster start a child
process that can read the guc variables and create a log file based on
it contents. The child would be responsible to create a new log file
every X seconds
On Wed, Jul 14, 2004 at 03:11:54PM -0400, Tom Lane wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > On Tue, Jul 13, 2004 at 04:57:06PM -0400, Tom Lane wrote:
> >> I've been thinking about what to do with cursors in subtransactions.
>
> > So within this proposal, a query executed by normal m
Christopher Kings-Lynne wrote:
> > We can have a major feature deadline, then a minor feature deadline. I
> > particularly liked the idea of 1 July as the major feature deadline,
> > then 14 July as major-feature-tweak deadline. That funnels things better
> > to cater for the manpower available.
>
On Thu, 15 Jul 2004, Christopher Kings-Lynne wrote:
We can have a major feature deadline, then a minor feature deadline. I
particularly liked the idea of 1 July as the major feature deadline,
then 14 July as major-feature-tweak deadline. That funnels things better
to cater for the manpower availabl
I talked to Tom on the phone today and and I think we have a procedure
for doing backup/restore in a fairly foolproof way.
As outlined below, we need to record the start/stop and checkpoint WAL
file names and offsets, and somehow pass those on to restore. I think
any system that requires users t
Hi, folks.
My colleages and I are planning to test PITR after the 7.5 beta release.
Now we are desinging test items, but some specification are enough clear
(to us).
For example, we are not clear which resouce manager order to store log
records.
- some access method (like B-tree) require to log i
We can have a major feature deadline, then a minor feature deadline. I
particularly liked the idea of 1 July as the major feature deadline,
then 14 July as major-feature-tweak deadline. That funnels things better
to cater for the manpower available.
That being said, your PITR patch still hasn't bee
I noticed that compiling with 5_1 patch applied fails due to
XLOG_archive_dir being removed from xlog.c , but
src/backend/commands/tablecmds.c still uses it.
I did the following to tablecmds.c :
5408c5408
< extern char XLOG_archive_dir[];
---
> extern char *XLogArchiv
On Wed, 2004-07-14 at 21:02, Bruce Momjian wrote:
> Marc G. Fournier wrote:
> > The big problem that I see with how this feature freeze/beta/release has
> > gone down is that we have *alot* of big items that are/were being worked
> > on (ARC, BGWriter, auto_vacuum, PITR, Nested Xacts), and only s
Bruce Momjian wrote:
I was thinking of something much simpler where Jan would create an ARC
patch against 7.4.X and have it either in /contrib for 7.4.X or on our
ftp servers, or on a web site. I could create a mechanism so SELECT
version() would display Jan's add-on.
:-(
I was asking to add the v
On Tue, 2004-07-13 at 23:03, Marc G. Fournier wrote:
> As a community, I don't think we should be 'supporting' anything older
> then the last STABLE ...
>
I agree, but that message isn't clearly stated anywhere. The lists are
full of people running very old releases - and everybody keeps having
Hi Peter,
> Compile the attached test program and then run
>
It doesn't even compile in a OpenBSD box. The langinfo.h doesn't have 'CODESET' symbol.
> for x in `locale -a`; do LC_ALL=$x ./test; done | sort -u
>
OpenBSD doesn't support locale at all (correct me if I'm wrong).
> If you don't ha
Alvaro Herrera wrote:
On the other hand, some people supported the idea that v3 Bind portals
should behave nontransactionally, while DECLARE portals should behave
transactionally. Maybe we could make that a property of the portal, or
even a user-selectable property (where we would define a reasona
Josh Berkus wrote:
Tom,
As much as I can understand the arguments -- many of them performance-oriented
-- for handling Portals non-transactionally, I simply don't see how we can do
it and not create huge problems for anyone who uses both cursors and NTs
together ... as those who use either are l
On Wed, 2004-07-14 at 10:57, Zeugswetter Andreas SB SD wrote:
> > The recovery mechanism doesn't rely upon you knowing 1 or 3. The
> > recovery reads pg_control (from the backup) and then attempts to
> > de-archive the appropriate xlog segment file and then starts
> > rollforward
>
> Unfortunatel
Mike Rylander wrote:
> Tom Lane wrote:
>
>> Alvaro Herrera <[EMAIL PROTECTED]> writes:
>>> On Tue, Jul 13, 2004 at 04:57:06PM -0400, Tom Lane wrote:
I've been thinking about what to do with cursors in subtransactions.
>>
>>> So within this proposal, a query executed by normal means will get
Marc G. Fournier wrote:
> On Wed, 14 Jul 2004, Bruce Momjian wrote:
>
> > The community decides when to stop development. Neither Afilias nor any
> > other company has that control. If you want the development cycle cut
> > shorter, make your case to the community --- if you win, great, if not
Marc G. Fournier wrote:
> The big problem that I see with how this feature freeze/beta/release has
> gone down is that we have *alot* of big items that are/were being worked
> on (ARC, BGWriter, auto_vacuum, PITR, Nested Xacts), and only so much man
> power at the reviewer stage ... we *should*
Tom Lane wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
>> On Tue, Jul 13, 2004 at 04:57:06PM -0400, Tom Lane wrote:
>>> I've been thinking about what to do with cursors in subtransactions.
>
>> So within this proposal, a query executed by normal means will get its
>> resources saved in the
On Wed, 2004-07-14 at 16:55, [EMAIL PROTECTED] wrote:
> On 14 Jul, Simon Riggs wrote:
> > PITR Patch v5_1 just posted has Point in Time Recovery working
> >
> > Still some rough edgesbut we really need some testers now to give
> > this a try and let me know what you think.
> >
> > Klaus N
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> On Tue, Jul 13, 2004 at 04:57:06PM -0400, Tom Lane wrote:
>> I've been thinking about what to do with cursors in subtransactions.
> So within this proposal, a query executed by normal means will get its
> resources saved in the transaction ResourceOwner
On Wed, 14 Jul 2004, Bruce Momjian wrote:
The community decides when to stop development. Neither Afilias nor any
other company has that control. If you want the development cycle cut
shorter, make your case to the community --- if you win, great, if not,
don't gripe about it.
Core decides whe
On 7/14/2004 1:13 PM, Bruce Momjian wrote:
What are you talking about? Are you suggesting Fujitsu's features are
getting more attendtion than ARC for some political reason? You think
nested transactions and tablespaces are just press release features?
All those features are being developed by th
On Wed, 14 Jul 2004, Bruce Momjian wrote:
What are you talking about? Are you suggesting Fujitsu's features are
getting more attendtion than ARC for some political reason? You think
nested transactions and tablespaces are just press release features?
All those features are being developed by the
I wrote:
> I've worked out a scheme that should adequately detect encoding
> mismatches in initdb.
Done.
Karel pointed me to some other projects that are trying to do the same
thing, and they are no smarter than what we have now.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
-
Jan,
> What touches me here is the fact that the PostgreSQL Open Source Project
> under the BSD license seems starting to care a lot more about some press
> releases and silly news splashes, than to care about real features
> contributed under the terms and conditions of the BSD license by serious
Jan Wieck wrote:
> On 7/13/2004 10:23 PM, Christopher Kings-Lynne wrote:
>
> >> I was thinking of something much simpler where Jan would create an ARC
> >> patch against 7.4.X and have it either in /contrib for 7.4.X or on our
> >> ftp servers, or on a web site. I could create a mechanism so SELE
Jan Wieck wrote:
> On 7/14/2004 5:00 AM, Christopher Kings-Lynne wrote:
>
> > Yes, but it has been committed, it will be released - the only thing is
> > that people will have to wait a few more months for it. My point was
>
> Just a few more months? That is exactly what I was asking for, put
Tom,
As much as I can understand the arguments -- many of them performance-oriented
-- for handling Portals non-transactionally, I simply don't see how we can do
it and not create huge problems for anyone who uses both cursors and NTs
together ... as those who use either are liable to do.
> Wh
On Tue, Jul 13, 2004 at 04:57:06PM -0400, Tom Lane wrote:
> I've been thinking about what to do with cursors in subtransactions.
> The problem really includes both cursors (created with DECLARE CURSOR)
> and portals (created with the V3-protocol Bind message) since they are
> the same kind of anima
On 14 Jul, Simon Riggs wrote:
> PITR Patch v5_1 just posted has Point in Time Recovery working
>
> Still some rough edgesbut we really need some testers now to give
> this a try and let me know what you think.
>
> Klaus Naumann and Mark Wong are the only [non-committers] to have tried
> t
Jan Wieck wrote:
On 7/14/2004 5:00 AM, Christopher Kings-Lynne wrote:
Yes, but it has been committed, it will be released - the only thing
is that people will have to wait a few more months for it. My point was
Just a few more months? That is exactly what I was asking for, put some
of the stuf
My answers:
> Q1: Should Portals successfully created within the failed subxact
> be closed? Or should they remain open?
no for protocol level
I can understand a yes to this one for sql level, because it will be
hard to clean up by hand :-( But I like the analogy to hold cursors,
so I would a
Simon Riggs <[EMAIL PROTECTED]> writes:
> I've not done power off tests, yet. They need to be done just to
> check...actually you don't need to do this to test PITR...
I agree, power off is not really the point here. What we need to check
into is (a) the mechanics of archiving WAL segments and (b
> The recovery mechanism doesn't rely upon you knowing 1 or 3. The
> recovery reads pg_control (from the backup) and then attempts to
> de-archive the appropriate xlog segment file and then starts
> rollforward
Unfortunately this only works if pg_control was the first file to be
backed up (or b
On 7/14/2004 5:00 AM, Christopher Kings-Lynne wrote:
Yes, but it has been committed, it will be released - the only thing is
that people will have to wait a few more months for it. My point was
Just a few more months? That is exactly what I was asking for, put some
of the stuff into 7.6 so it w
To fill you in a little, I am the PostgreSQL CORE team member Jan Wieck,
who burned Afilias payroll hours to implement the ARC buffer replacement
strategy. The feature has been completed and fully contributed under the
BSD license way ahead of any possible release schedule. I have had
several r
On 7/13/2004 10:23 PM, Christopher Kings-Lynne wrote:
I was thinking of something much simpler where Jan would create an ARC
patch against 7.4.X and have it either in /contrib for 7.4.X or on our
ftp servers, or on a web site. I could create a mechanism so SELECT
version() would display Jan's add-
On Wed, 2004-07-14 at 05:08, Tom Lane wrote:
> Oliver Elphick <[EMAIL PROTECTED]> writes:
> > ...
> > The point of this explanation is that as Debian maintainer I would have
> > to disable any procedures that attempt to edit these conffiles, or at
> > least ensure that their operation is under pack
> Magnus Hagander wrote:
> > > not to mention the
> > >more basic problem that the comments will now be wrong.
> >
> > That, however, it is correct :-( Sloppy.
> >
> > How about a text along the line of:
> > CAUTION: Configuring the system for "trust" authentication
> allows any
> > local user
On Tue, Jul 13, 2004 at 06:29:51PM +0200, Peter Eisentraut wrote:
> Bruce Momjian wrote:
> > I am not sure what can be done to solve this in the future. There
> > are only a limited number of us who have the experience and time to
> > review and comment on very complex patches.
>
> The issue as I
On Wed, 2004-07-14 at 03:31, Christopher Kings-Lynne wrote:
> Can you give us some suggestions of what kind of stuff to test? Is
> there a way we can artificially kill the backend in all sorts of nasty
> spots to see if recovery works? Does kill -9 simulate a 'power off'?
>
I was hoping some
43 matches
Mail list logo
