Re: [HACKERS] 7.4 hot backup capabilities?

2003-11-12 Thread Shridhar Daithankar
Austin Gonyou wrote: What facilities are/will be available for hot(online) backups with the 7.4 release? PITR, something else? TIA. pg_dump? Did you mean hot failover or hot backup? Postgresql does hot backup for a long time. Bye Shridhar ---(end of

Re: [HACKERS] CVS with tag REL7_4_STABLE don't compile

2003-11-12 Thread Michael Meskes
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) My fault. extern.h wasn't committed and I didn't notice. Sorry. It should be fixed now. Michael -- Michael Meskes Email: Michael at Fam-Meskes dot De ICQ:

Re: [HACKERS] 7.4 hot backup capabilities?

2003-11-12 Thread Austin Gonyou
On Wed, 2003-11-12 at 01:00, Shridhar Daithankar wrote: Austin Gonyou wrote: What facilities are/will be available for hot(online) backups with the 7.4 release? PITR, something else? TIA. pg_dump? Did you mean hot failover or hot backup? Postgresql does hot backup for a long time. I

Re: [HACKERS] 7.4 hot backup capabilities?

2003-11-12 Thread Shridhar Daithankar
Austin Gonyou wrote: On Wed, 2003-11-12 at 01:00, Shridhar Daithankar wrote: Austin Gonyou wrote: What facilities are/will be available for hot(online) backups with the 7.4 release? PITR, something else? TIA. pg_dump? Did you mean hot failover or hot backup? Postgresql does hot backup for a

Re: [HACKERS] NetBSD/acorn32

2003-11-12 Thread Patrick Welche
On Sun, Nov 09, 2003 at 09:51:31PM +0100, Peter Eisentraut wrote: Patrick Welche writes: PostgreSQL 7.5devel on arm-unknown-netbsdelf1.6ZE, compiled by GCC gcc (GCC) 3.3.2-nb1 Can you test 7.4? Several days of compiling later.. All 93 tests passed. with 7.4rc2 on

[HACKERS] rpm support for 7.4 and beyond

2003-11-12 Thread Robert Treat
I haven't seen any discussion on the topic, so thought I might start one. We currently provide rpms for Red Hat 7.x, 8.x, and 9, and I'm assuming that we'll have rpms for all of those for 7.4 once release time rolls around. However, given that Red Hat is dropping support for 7.x and 8.x version on

Re: [HACKERS] 7.4 hot backup capabilities?

2003-11-12 Thread Jan Wieck
Austin Gonyou wrote: On Wed, 2003-11-12 at 01:00, Shridhar Daithankar wrote: Austin Gonyou wrote: What facilities are/will be available for hot(online) backups with the 7.4 release? PITR, something else? TIA. pg_dump? Did you mean hot failover or hot backup? Postgresql does hot backup for a

Re: [HACKERS] rpm support for 7.4 and beyond

2003-11-12 Thread Tom Lane
Robert Treat [EMAIL PROTECTED] writes: Also (and maybe someone from Red Hat can weigh in here) are there any plans from Red Hat to release RHEL rpms for postgresql in the future, I can tell you that Red Hat is getting beat up regularly for having omitted Postgres (and MySQL!) from RHEL 3. If

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

2003-11-12 Thread Zeugswetter Andreas SB SD
LOG: could not bind socket for statistics collector: Cannot assign requested address Hmm ... that's sure the problem, but what can we do about it? ISTM that any non-broken system ought to be able to resolve localhost. Actually it's worse than that: your system resolved localhost and

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

2003-11-12 Thread Tom Lane
Zeugswetter Andreas SB SD [EMAIL PROTECTED] writes: Are we using an api that only returns nslookup responses and not /etc/hosts entries ? At least on AIX it looks like it. We use getaddrinfo(), or if that doesn't exist gethostbyname(). If there's a problem of that ilk then it's those library

Re: [HACKERS] rpm support for 7.4 and beyond

2003-11-12 Thread Andrew Dunstan
Tom Lane wrote: Robert Treat [EMAIL PROTECTED] writes: Also (and maybe someone from Red Hat can weigh in here) are there any plans from Red Hat to release RHEL rpms for postgresql in the future, I can tell you that Red Hat is getting beat up regularly for having omitted Postgres (and

Re: [HACKERS] rpm support for 7.4 and beyond

2003-11-12 Thread Robert Treat
On Wed, 2003-11-12 at 10:23, Tom Lane wrote: Robert Treat [EMAIL PROTECTED] writes: Also (and maybe someone from Red Hat can weigh in here) are there any plans from Red Hat to release RHEL rpms for postgresql in the future, I can tell you that Red Hat is getting beat up regularly for

Re: [HACKERS] rpm support for 7.4 and beyond

2003-11-12 Thread Andrew Dunstan
I wrote: I just spent 15 minutes searching on the RH web site trying to locate a complete list of packages in the various RHEL personalities, with conspicuous lack of success. How anyone can make decisions about it without knowing exactly what is in it is beyond me. However, you can see a

[HACKERS] Successful proting report for 7.4beta4 on Irix and Altix

2003-11-12 Thread Robert E. Bruccoleri
Dear All, I have compiled and tested Postgresql-7.4beta4 on SGI Irix 6.5.20 using the MIPS Pro 7.4 compilers and on SGI Altix using the gcc 2.96 compilers and both ports passed all tests within the limits of numerical accuracy. What is the URL for reporting successful ports? --Bob

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

2003-11-12 Thread Kurt Roeckx
On Wed, Nov 12, 2003 at 10:32:38AM -0500, Tom Lane wrote: Zeugswetter Andreas SB SD [EMAIL PROTECTED] writes: Are we using an api that only returns nslookup responses and not /etc/hosts entries ? At least on AIX it looks like it. We use getaddrinfo(), or if that doesn't exist

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

2003-11-12 Thread Tom Lane
Kurt Roeckx [EMAIL PROTECTED] writes: It's always a good idea to put localhost into dns too. Yeah, but localhost *is* resolving as something on Kiyoshi's machine, else a different error message would have appeared. I'm wondering just what it resolved to though --- maybe we should have made the

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

2003-11-12 Thread Jan Wieck
Hans-Jürgen Schönig wrote: Jan, First of all we really appreciate that this is going to be an Open Source project. There is something I wanted to add from a marketing point of view: I have done many public talks in the 2 years or so. There is one question people keep asking me: How about the

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

2003-11-12 Thread Jordan Henderson
Jan, I am wondering if you are familar with the work covered in 'Recovery in Parallel Database Systems' by Svein-Olaf Hvasshovd (Vieweg) ? The book is an excellent detailed description covering high availablility DB implementations. I think your right on by not thinking smaller!! Jordan

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

2003-11-12 Thread Hans-Jürgen Schönig
Jan, This is EXACTLY what we have been waiting for (years) :) :) :). If you need somebody for testing or documentation just drop me a line. Cheers, Hans Jan Wieck wrote: Hans-Jürgen Schönig wrote: Jan, First of all we really appreciate that this is going to be an Open Source project.

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

2003-11-12 Thread Jan Wieck
Jordan Henderson wrote: Jan, I am wondering if you are familar with the work covered in 'Recovery in Parallel Database Systems' by Svein-Olaf Hvasshovd (Vieweg) ? The book is an excellent detailed description covering high availablility DB implementations. No, but it sounds like something I

Re: [HACKERS] New approach to ye olde cross-datatype indexing problem

2003-11-12 Thread Tom Lane
I wrote: What if we attack the problem head on --- make indexes able to handle cross-datatype comparison operators directly? That would solve the problem without *any* semantic side-effects. AFAIR we've never seriously considered doing that; I guess anyone who thought of it dismissed it as

[HACKERS] ARC buffer strategy committed

2003-11-12 Thread Jan Wieck
I have just committed the implementation of ARC into the 7.5devel tree. This doesn't contain the vacuum page delay, or the test implementation of the background writer based on the checkpoint process. These two need some more discussion and bouncing around. Jan --

Re: [HACKERS] ARC buffer strategy committed

2003-11-12 Thread Tom Lane
Jan Wieck [EMAIL PROTECTED] writes: I have just committed the implementation of ARC into the 7.5devel tree. I'm seeing a whole bunch of regression test failures that weren't there half an hour ago ... regards, tom lane ---(end of

Re: [HACKERS] ARC buffer strategy committed

2003-11-12 Thread Jan Wieck
Tom Lane wrote: Jan Wieck [EMAIL PROTECTED] writes: I have just committed the implementation of ARC into the 7.5devel tree. I'm seeing a whole bunch of regression test failures that weren't there half an hour ago ... regards, tom lane Oh ... hmmm ... will check Jan --

Re: [HACKERS] ARC buffer strategy committed

2003-11-12 Thread Jan Wieck
Jan Wieck wrote: Tom Lane wrote: Jan Wieck [EMAIL PROTECTED] writes: I have just committed the implementation of ARC into the 7.5devel tree. I'm seeing a whole bunch of regression test failures that weren't there half an hour ago ... regards, tom lane Oh ... hmmm ... will check That's

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

2003-11-12 Thread Kiyoshi Sawada
On Wed, 12 Nov 2003 13:46:52 -0500 Tom Lane [EMAIL PROTECTED] wrote: Kurt Roeckx [EMAIL PROTECTED] writes: It's always a good idea to put localhost into dns too. Yeah, but localhost *is* resolving as something on Kiyoshi's machine, else a different error message would have appeared.

Re: [HACKERS] ARC buffer strategy committed

2003-11-12 Thread Tom Lane
Jan Wieck [EMAIL PROTECTED] writes: That's strange, if I reverse apply my patch I have buffer leak's and all kinds of crap. Can't even initdb. Who else applied patches tonight? Well, there was my operator-class patch (which went nowhere near the buffer stuff) and also the initdb-in-C code (new

Re: [HACKERS] ARC buffer strategy committed

2003-11-12 Thread Tom Lane
Jan Wieck [EMAIL PROTECTED] writes: That's strange, if I reverse apply my patch I have buffer leak's and all kinds of crap. Can't even initdb. Who else applied patches tonight? FWIW, I can initdb --- that seems fine --- but the regression tests spew lots of small fragments. What I suspect is

Re: [HACKERS] ARC buffer strategy committed

2003-11-12 Thread Tom Lane
Jan Wieck [EMAIL PROTECTED] writes: Can't even initdb. Who else applied patches tonight? FWIW, I did make distclean, full rebuild, initdb on both HP and Linux machines. The HP passes both serial and parallel regression tests. The Linux machine initdb's, and simple manual queries seem to work,

Re: [HACKERS] Successful proting report for 7.4beta4 on Irix and Altix

2003-11-12 Thread Bruce Momjian
Robert E. Bruccoleri wrote: Dear All, I have compiled and tested Postgresql-7.4beta4 on SGI Irix 6.5.20 using the MIPS Pro 7.4 compilers and on SGI Altix using the gcc 2.96 compilers and both ports passed all tests within the limits of numerical accuracy. What is the URL for

Re: [HACKERS] rpm support for 7.4 and beyond

2003-11-12 Thread Lamar Owen
On Wednesday 12 November 2003 08:57 am, Robert Treat wrote: I haven't seen any discussion on the topic, so thought I might start one. We currently provide rpms for Red Hat 7.x, 8.x, and 9, and I'm assuming that we'll have rpms for all of those for 7.4 once release time rolls around. However,

Re: [HACKERS] rpm support for 7.4 and beyond

2003-11-12 Thread Marc G. Fournier
On Wed, 12 Nov 2003, Lamar Owen wrote: The biggest issue is going to be 'will it build' on those releases. The tcl version deal (with tcl prior to 8.1) Tom applied a patch so that the build will continue to work on 8.0.x ... or is this some other issue? ---(end of

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

2003-11-12 Thread Kiyoshi Sawada
On Thu, 13 Nov 2003 11:39:49 +0900 Kiyoshi Sawada [EMAIL PROTECTED] wrote: $ nslookup localhost Server: name.server.mydomain Address: xxx.xx.xx.xxx : : : (failed test) Is it necessary to start a DNS server to bind 'localhost' in Kiyoshi's machine? I got bind-9.2.2-sol8-intel-local

Re: [HACKERS] rpm support for 7.4 and beyond

2003-11-12 Thread Matthew T. O'Connor
On Wed, 2003-11-12 at 23:44, Lamar Owen wrote: My hands are somewhat tied at the present to only supporting what I actively run. That is currently RHL 8.0 and Fedora Core 1. (not 1.0, incidentally; there is no minor version). Have you tried mach?

Re: [HACKERS] ARC buffer strategy committed

2003-11-12 Thread Jan Wieck
Tom Lane wrote: Jan Wieck [EMAIL PROTECTED] writes: That's strange, if I reverse apply my patch I have buffer leak's and all kinds of crap. Can't even initdb. Who else applied patches tonight? FWIW, I can initdb --- that seems fine --- but the regression tests spew lots of small fragments. What

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

2003-11-12 Thread Andrew Sullivan
On Wed, Nov 12, 2003 at 02:08:23PM +0100, Hans-J?rgen Sch?nig wrote: an inferior product anyway. What I want to point out is that some people want an alternative Oracle's Real Application Cluster. They want load balancing and hot failover. Even data centers asking for replication did not

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

2003-11-12 Thread Bruce Momjian
Hans-Jürgen Schönig wrote: Meanwhile we seem to be in a situation where PostgreSQL is rather competing against Oracle than against MySQL. In our case there are more people asking for Oracle - Pg migration than for MySQL - Pg. MySQL does not seem to be the great enemy because most people