[HACKERS] 7.4 hot backup capabilities?

2003-11-11 Thread Austin Gonyou
What facilities are/will be available for hot(online) backups with the 7.4 release? PITR, something else? TIA. -- Austin Gonyou <[EMAIL PROTECTED]> Coremetrics, Inc. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ?

Re: [HACKERS] Experimental patch for inter-page delay in VACUUM

2003-11-11 Thread Shridhar Daithankar
Greg Stark wrote: Shridhar Daithankar <[EMAIL PROTECTED]> writes: If the parent postmaster mmaps anonymous memory segments and shares them with children, postgresql wouldn't be dependent upon any kernel resourse aka shared memory anymore. Anonymous memory mappings aren't shared, at least not

Re: [HACKERS] About the partial tarballs

2003-11-11 Thread Marc G. Fournier
On Wed, 12 Nov 2003, Christopher Kings-Lynne wrote: > > Even if they weren't useful for anything else, I think there's value in the > > developers having to consider what is optional and what is not. This need > > for constant review probably reduces the chance of bloat, over time even > > in th

Re: [HACKERS] 7.4RC2 regression failur and not running stats collector process on Solaris

2003-11-11 Thread Tom Lane
Kiyoshi Sawada <[EMAIL PROTECTED]> writes: > On Tue, 11 Nov 2003 09:18:48 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: >> So why not? Try looking in the postmaster log for errors related to >> stats collector startup. (pstat is irrelevant, btw.) > LOG: could not bind socket for statistics collect

Re: [HACKERS] About the partial tarballs

2003-11-11 Thread Christopher Kings-Lynne
Even if they weren't useful for anything else, I think there's value in the developers having to consider what is optional and what is not. This need for constant review probably reduces the chance of bloat, over time even in the full tarball. How about dropping the partial tarballs and using the s

Re: [HACKERS] Darwin Startup Script Patch

2003-11-11 Thread Bruce Momjian
Patch applied to HEAD and 7.4CVS. Thanks. --- David Wheeler wrote: > Clearly I can't spell. > > Regards, > > David > > --- postgresql-7.4RC1/contrib/start-scripts/PostgreSQL.darwin Mon Dec > 9 13:26:07 2002 > +++ /

Re: [HACKERS] bufmgr code question

2003-11-11 Thread Bruce Momjian
Is there a TODO here? --- Tom Lane wrote: > Neil Conway <[EMAIL PROTECTED]> writes: > > In the BufferDesc struct, there seem to be two ways to mark a buffer > > page as dirty: setting the BM_DIRTY bit mask in the 'flags' fie

Re: [HACKERS] About the partial tarballs

2003-11-11 Thread Marc G. Fournier
On Tue, 11 Nov 2003, Nigel J. Andrews wrote: > > On Tue, 11 Nov 2003, Marc G. Fournier wrote: > > ftp://ftp.postgresql.org/pub/README.dist-split > > > > to reduce the confusion, that would be great. I've just symlink'd it into > > the source directories as the .message, so that its displays whe

Re: [HACKERS] 7.4RC2 regression failur and not running stats collector process on Solaris

2003-11-11 Thread Kiyoshi Sawada
Dear Tom Lane. On Tue, 11 Nov 2003 09:18:48 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: > Kiyoshi Sawada <[EMAIL PROTECTED]> writes: > > 2. Regression Failur stats . FAILED . > > 3. Not running stats buffer process and stats collector process. > > So why not? Try looking in the postmaster l

Re: [HACKERS] About the partial tarballs

2003-11-11 Thread Nigel J. Andrews
On Tue, 11 Nov 2003, Marc G. Fournier wrote: > ftp://ftp.postgresql.org/pub/README.dist-split > > to reduce the confusion, that would be great. I've just symlink'd it into > the source directories as the .message, so that its displays when you > enter the directory ... Does anyone actually read

Re: [HACKERS] About the partial tarballs

2003-11-11 Thread Marc G. Fournier
On Wed, 12 Nov 2003, Marko Karppinen wrote: > I agree that the partial tarballs can confuse an ftp user, though. I > think a good solution to this would be to put them one level deeper, > into a subfolder. The full tarball would then be the only thing a casual > user would encounter, but the sou

Re: [HACKERS] About the partial tarballs

2003-11-11 Thread Marko Karppinen
On 11 Nov 2003, at 20:44, Peter Eisentraut wrote: Do we have any data on how many people download the partial tarballs (-base, -opt, etc.)? I have a feeling that more people are confused by them than use them. Even if they weren't useful for anything else, I think there's value in the developers

Re: [HACKERS] [GENERAL] Proposal for a cascaded master-slave replication system

2003-11-11 Thread Joe Conway
Jan Wieck wrote: If you mean to configure the system to replicate rows to different destinations (slaves) based on arbitrary qualifications, no. I had thought about it, but it does not really fit into the "datacenter and failover" picture, so it is not required to meet the goals and adds unnece

Re: [HACKERS] About the partial tarballs

2003-11-11 Thread Rod Taylor
On Tue, 2003-11-11 at 14:29, Peter Eisentraut wrote: > Marc G. Fournier writes: > > > > Do we have any data on how many people download the partial tarballs > > > (-base, -opt, etc.)? I have a feeling that more people are confused by > > > them than use them. > > > > on ftp.postgresql.org itself,

Re: [HACKERS] [GENERAL] Proposal for a cascaded master-slave replication system

2003-11-11 Thread Jan Wieck
Joe Conway wrote: Jan Wieck wrote: http://developer.postgresql.org/~wieck/slony1.html Very interesting read. Nice work! We want to build this system as a community project. The plan was from the beginning to release the product under the BSD license. And we think it is best to start it as such an

Re: [HACKERS] About the partial tarballs

2003-11-11 Thread Marc G. Fournier
On Tue, 11 Nov 2003, Peter Eisentraut wrote: > Marc G. Fournier writes: > > > > Do we have any data on how many people download the partial tarballs > > > (-base, -opt, etc.)? I have a feeling that more people are confused by > > > them than use them. > > > > on ftp.postgresql.org itself, since

Re: [HACKERS] About the partial tarballs

2003-11-11 Thread Peter Eisentraut
Marc G. Fournier writes: > > Do we have any data on how many people download the partial tarballs > > (-base, -opt, etc.)? I have a feeling that more people are confused by > > them than use them. > > on ftp.postgresql.org itself, since June 4th: Interesting. Note that in most cases people down

Re: [HACKERS] About the partial tarballs

2003-11-11 Thread Marc G. Fournier
On Tue, 11 Nov 2003, Peter Eisentraut wrote: > Do we have any data on how many people download the partial tarballs > (-base, -opt, etc.)? I have a feeling that more people are confused by > them than use them. on ftp.postgresql.org itself, since June 4th: 2812 /var/spool/ftp/pub/source/v7.3.

[HACKERS] About the partial tarballs

2003-11-11 Thread Peter Eisentraut
Do we have any data on how many people download the partial tarballs (-base, -opt, etc.)? I have a feeling that more people are confused by them than use them. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searc

Re: [HACKERS] Bogus bind() warnings

2003-11-11 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Tom Lane writes: >> Actually, I think that that may be expected behavior depending on the >> vintage of the kernel. Note the following comment in >> StreamServerPort(): > Can we make the warning less misleading if IPV6_V6ONLY does not exist? Possibl

Re: [HACKERS] Bogus bind() warnings

2003-11-11 Thread Peter Eisentraut
Tom Lane writes: > Actually, I think that that may be expected behavior depending on the > vintage of the kernel. Note the following comment in > StreamServerPort(): Can we make the warning less misleading if IPV6_V6ONLY does not exist? -- Peter Eisentraut [EMAIL PROTECTED] ---

[HACKERS] CVS with tag REL7_4_STABLE don't compile

2003-11-11 Thread snpe
Hello, I have a problem with compile PostgreSQL from cvs with tag REL7_4_STABLE Error is 'ECPG_ARRAY_NONE is not declared' (in execute.c) HEAD (7.5.devel) compile fine Please help Regards Haris Peco ---(end of broadcast)--- TIP 7: don't forget t

Re: [HACKERS] bugzilla (Was: What do you want me to do?)

2003-11-11 Thread Jan Wieck
Marc G. Fournier wrote: On Tue, 11 Nov 2003, Shridhar Daithankar wrote: --- Hello, My name is <> and I work with postgresql group. Recently we/postgresql advocay/general group have decided to form a group of people who would help other projects w.r.t postgresql. So feel free to ask me que

Re: [HACKERS] bug in 7.4 ...

2003-11-11 Thread William ZHANG
PostgreSQL seems to maintance the unique index when updating each row. If the insert sequence is 1, 2, 3, 4, 5, when doing UPDATE testtabelle SET c001 = c001 - 1 It happens to process rows 1, 2, 3, 4, 5 in the same order as you insert. Thus we see the UPDATE finished successfully. But, if we

Re: [HACKERS] [GENERAL] Proposal for a cascaded master-slave replication system

2003-11-11 Thread Andrew Rawnsley
On Nov 11, 2003, at 12:11 PM, Joe Conway wrote: Jan Wieck wrote: http://developer.postgresql.org/~wieck/slony1.html Very interesting read. Nice work! Ditto. I'll read it a bit closer later, but after a quick read it seems quite complete and well thought out. I especially like that sequences are

Re: [HACKERS] bugzilla (Was: What do you want me to do?)

2003-11-11 Thread Marc G. Fournier
On Tue, 11 Nov 2003, Shridhar Daithankar wrote: > --- > Hello, > > My name is <> and I work with postgresql group. Recently we/postgresql > advocay/general group have decided to form a group of people who would help > other projects w.r.t postgresql. > > So feel free to ask me questions.

Re: [HACKERS] Experimental patch for inter-page delay in VACUUM

2003-11-11 Thread Greg Stark
Shridhar Daithankar <[EMAIL PROTECTED]> writes: > If the parent postmaster mmaps anonymous memory segments and shares them with > children, postgresql wouldn't be dependent upon any kernel resourse aka > shared memory anymore. Anonymous memory mappings aren't shared, at least not unless you're

Re: [HACKERS] [GENERAL] Proposal for a cascaded master-slave replication system

2003-11-11 Thread Joe Conway
Jan Wieck wrote: http://developer.postgresql.org/~wieck/slony1.html Very interesting read. Nice work! We want to build this system as a community project. The plan was from the beginning to release the product under the BSD license. And we think it is best to start it as such and to ask for sugges

Re: [HACKERS] bugzilla (Was: What do you want me to do?)

2003-11-11 Thread Andrew Dunstan
Peter Eisentraut wrote: Andrew Dunstan writes: Your suggestion elsewhere of "pick your second favourite app" is likely to result in a more scattergun approach. Also, if it had the imprimatur of the PostgreSQL community to some extent appraoches to projects might be more welcome - "Dear open-so

Re: [HACKERS] bugzilla (Was: What do you want me to do?)

2003-11-11 Thread Peter Eisentraut
Andrew Dunstan writes: > Your suggestion elsewhere of "pick your second favourite app" is likely > to result in a more scattergun approach. Also, if it had the imprimatur > of the PostgreSQL community to some extent appraoches to projects might > be more welcome - "Dear open-source-project-manager

Re: [HACKERS] Experimental patch for inter-page delay in VACUUM

2003-11-11 Thread Jan Wieck
Shridhar Daithankar wrote: On Tuesday 11 November 2003 18:55, Jan Wieck wrote: And how does a newly mmap'ed segment propagate into a running backend? It wouldn't. Just like we allocate fixed amount of shared memory at startup now, we would do same for mmaped segments. Allocate maximum configured

Re: [HACKERS] bugzilla (Was: What do you want me to do?)

2003-11-11 Thread Matthew T. O'Connor
On Tue, 2003-11-11 at 09:42, Shridhar Daithankar wrote: > Peter Eisentraut wrote: > > Shridhar Daithankar writes: > >>I think so too.. I have been planning to do that for dbmail and egroupware > >>but haven't got around it.. > > When I said "I've been doing a bit of that", I meant "the developers

[HACKERS] Proposal for a cascaded master-slave replication system

2003-11-11 Thread Jan Wieck
Dear community, for some reason the post I sent yesterday night still did not show up on the mailing lists. I have set up some links on the developers side under http://developer.postgresql.org/~wieck/slony1.html The concept will be the base for some of my work as a Software Engineer here at Af

Re: [HACKERS] bugzilla (Was: What do you want me to do?)

2003-11-11 Thread Shridhar Daithankar
Peter Eisentraut wrote: Shridhar Daithankar writes: So forming a new group is quite beneficial? No, we don't need one group, we need many individuals (or possibly small groups) to get in contact with their second favorite projects and hang out there. I meant lets form a group within advocacy wh

Re: [HACKERS] bugzilla (Was: What do you want me to do?)

2003-11-11 Thread Andrew Dunstan
Peter Eisentraut wrote: Andrew Dunstan writes: Seriously, I have wondered if it might be a good idea to assemble a small "hit team" that would take some high profile open source projects and make sure they worked with Postgres. Bugzilla would be the most obvious candidate, but there are certai

Re: [HACKERS] bug in 7.4 ...

2003-11-11 Thread Tom Lane
=?ISO-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?= <[EMAIL PROTECTED]> writes: > I have seen that a bug related to duplicated keys is in 7.4rc2. As far > as I have seen a bug like that has already been discovered during the > 7.3 era. Is this bug going to be fixed? We do not have, and never have had, defe

Re: [HACKERS] 7.4RC2 regression failur and not running stats collector process on Solaris

2003-11-11 Thread Tom Lane
Kiyoshi Sawada <[EMAIL PROTECTED]> writes: > 2. Regression Failur stats . FAILED . > 3. Not running stats buffer process and stats collector process. So why not? Try looking in the postmaster log for errors related to stats collector startup. (pstat is irrelevant, btw.)

Re: [HACKERS] bugzilla (Was: What do you want me to do?)

2003-11-11 Thread Peter Eisentraut
Shridhar Daithankar writes: > So forming a new group is quite beneficial? No, we don't need one group, we need many individuals (or possibly small groups) to get in contact with their second favorite projects and hang out there. > I think so too.. I have been planning to do that for dbmail and

Re: [HACKERS] bugzilla (Was: What do you want me to do?)

2003-11-11 Thread Shridhar Daithankar
On Tuesday 11 November 2003 19:19, Peter Eisentraut wrote: > Andrew Dunstan writes: > > Seriously, I have wondered if it might be a good idea to assemble a > > small "hit team" that would take some high profile open source projects > > and make sure they worked with Postgres. Bugzilla would be the

Re: [HACKERS] bugzilla (Was: What do you want me to do?)

2003-11-11 Thread Peter Eisentraut
Andrew Dunstan writes: > Seriously, I have wondered if it might be a good idea to assemble a > small "hit team" that would take some high profile open source projects > and make sure they worked with Postgres. Bugzilla would be the most > obvious candidate, but there are certainly others. I suspec

Re: [HACKERS] Experimental patch for inter-page delay in VACUUM

2003-11-11 Thread Shridhar Daithankar
On Tuesday 11 November 2003 18:55, Jan Wieck wrote: > Shridhar Daithankar wrote: > > On Tuesday 11 November 2003 00:50, Neil Conway wrote: > >> Jan Wieck <[EMAIL PROTECTED]> writes: > >> > We can't resize shared memory because we allocate the whole thing in > >> > one big hump - which causes the sh

Re: [HACKERS] Experimental patch for inter-page delay in VACUUM

2003-11-11 Thread Jan Wieck
Shridhar Daithankar wrote: On Tuesday 11 November 2003 00:50, Neil Conway wrote: Jan Wieck <[EMAIL PROTECTED]> writes: > We can't resize shared memory because we allocate the whole thing in > one big hump - which causes the shmmax problem BTW. If we allocate > that in chunks of multiple blocks, we

Re: [HACKERS] bugzilla

2003-11-11 Thread Georges Martin
[EMAIL PROTECTED] wrote: Seriously, I have wondered if it might be a good idea to assemble a small "hit team" that would take some high profile open source projects and make sure they worked with Postgres. Bugzilla would be the most obvious candidate, but there are certainly others. I suspect

[HACKERS] bug in 7.4 ...

2003-11-11 Thread Hans-Jürgen Schönig
I have seen that a bug related to duplicated keys is in 7.4rc2. As far as I have seen a bug like that has already been discovered during the 7.3 era. Is this bug going to be fixed? Here s the description: DROP TABLE public.testtabelle; begin; CREATE TABLE public.testtabelle ( c000 varchar(2