Re: [HACKERS] Can we revisit the thought of PostgreSQL 7.2.4?
Josh Berkus wrote: Neil, Robert: As for the WAL recovery bug, AFAIK no such bug has been reported in the last few days. Exactly what issue are you referring to? That's my bug; I filed it on Wednesday. However, it is not 100%; that is: 1) While Tom and I are pretty sure that the issue *could* cause the behavior reported, we're not completely certain that it *did*; i.e. in the two reported cases, one actually turned out to be something else, and the other could possibly be something else as well. 2) Nobody has tested that switching the order of those 2 lines in 7.2.3 doesn't cause any problems, to date. I'm not saying that it's not potentially a patchable bug. We're just not ready to patch it yet. Ok, this might not be such an important fix after all then? The wording of it at the time did make it sound important, but if it somehow has bad interactions we would be shooting ourselves in the foot with it. Any guess-timates on it's safeness and whether it really would be beneficial? But I do vote for a 7.2.4 just because I can't upgrade a lot of my clients to 7.3.1 safely and there are a few easy patches for 7.2.3. Alternately, I would suggest an omnibus patch for the 7.2.3 source code so that we don't set a precedent for branching development. An interesting thought here is to know if Red Hat fixed *all* of the known PostgreSQL security flaws for 7.2.3 with their latest security release. It would be interesting to see their code if they did so, but from Tom's previous comments it would have meant a real lot of work. It's probably better to put out a 7.2.4 than an omnibus patch though, as it gives a better foundation for everyone working on 7.2.x to safely move to. From the viewpoint of it takes more skill to patch than to compile. Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Prepare enabled pgbench
Hi Curtis, Have you had time to get this done? :-) Regards and best wishes, Justin Clift Curtis Faith wrote: Tatsuo Ishii [EMAIL PROTECTED] writes: Thanks. I can commit it for 7.4. BTW, it would be nice if we could have a switch to turn on/off PREPARE/EXECUTE in pgbench so that we could see how PRPARE/EXECUTE could improve the performance... tom lane replies: That is a *must*. Otherwise, you've simply made an arbitrary change in the benchmark ... which is no benchmark at all. regards, tom lane I will add it as a switched option. It should be possible to keep most of the code common for the two cases. - Curtis ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] v7.3.1 psql against a v7.2.x database ...
Christopher Kings-Lynne wrote: With ever more larger businesses adopting PostgreSQL, and that leading on to more places having several versions of PostgreSQL in operation simultaneously (i.e. development vs production) we're probably going to need to give psql the ability to handle whichever version of the PG backend it happens to connect to. Marc's suggestion of breaking psql into it's own sub-project makes good sense from that point of view. Hey, good point. Giving psql the ability to handle multiple backend versions could be done in a number of ways. Subproject or not, why don't we just rearrange psql to dynamically load a library of functions, eg: libpsql72.so libpsql73.so etc... And in them you have functions like: printTableDef(); printViewDef(); etc... Is this very different from how it's done at present? :-) Regards and best wishes, Justin Clift Chris -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] v7.3.1 psql against a v7.2.x database ...
[EMAIL PROTECTED] wrote: snip I have strongly considered doing this, and even started on the project some time ago. (I've stopped now). At first I wanted to add 7.3 and 7.4 features to a 7.2 psql. Then I considered writing a master psql that could handle any backend. In the end, however, I realized that with 7.3 well out the door, it was better to encourage people to upgrade to 7.3 and spend my energies on other things. If there is still a strong interest however, I can easily help out and share what I have already done. With ever more larger businesses adopting PostgreSQL, and that leading on to more places having several versions of PostgreSQL in operation simultaneously (i.e. development vs production) we're probably going to need to give psql the ability to handle whichever version of the PG backend it happens to connect to. Marc's suggestion of breaking psql into it's own sub-project makes good sense from that point of view. So... this stuff is interesting Greg. :-) Regards and best wishes, Justin Clift -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200301161656 -BEGIN PGP SIGNATURE- Comment: http://www.turnstep.com/pgp.html iD8DBQE+JyrzvJuQZxSWSsgRAmdUAJ4upWRFGKi1K5WYAwCVf36w1V4aAQCgvuD3 kCy+Q6EE/pum7Sojim+TJdM= =Tvn6 -END PGP SIGNATURE- ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[HACKERS] PostgreSQL 7.4 and Microsoft's SMS
Hi guys, Just received a query through the Advocacy site's request form... Does anyone know if PostgreSQL 7.4's native windows version will/would be compatible with Microsoft's SMS (System Management Server)? Looks like some places will be considering it for Enterprise Deployment if it is. :-) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[HACKERS] Can we revisit the thought of PostgreSQL 7.2.4?
Hi everyone, Over the last few days we've had patches submitted for 7.2.3 that address a couple of things, both the WAL Recovery Bug that Tom has developed a patch for, and a couple of buffer overflows that have been widely reported. Although we haven't wanted to release a 7.2.4, and have instead encouraged people to upgrade to 7.3.x, there are places out there who's applications aren't compatible with 7.3.x and would also need to upgrade them as well. It might be a really good idea if we re-visit the thought of 7.2.4 and have something that people running the 7.2.x series can use safely until they are able to move to 7.3.x or above. What would it take, and apart from patches for the buffer overflows and the WAL recovery bug, should anything else be included to ensure safety and stability? :-) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[HACKERS] Translation of the PostgreSQL manuals to Spanish is under way
Hi everyone, Christian Kuroki [EMAIL PROTECTED] is a senior member of a team that is translating the PostgreSQL manuals to Spanish. There isn't a website for it yet (it will be created fairly soon) but the team is making good progress, and the manuals will be kept updated with the main PostgreSQL manuals. Does anyone out here who knows/writes Spanish have a bit of time to assist them with translation? These manuals will be available to all, just the same as with PostgreSQL itself, and will greatly assist in improving PostgreSQL for the Spanish Community. Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Anyone have a fresh Solaris 8 SPARC system to create
Mark Kirkwood wrote: snip I can get access to several boxes with Solaris 8 + gcc 2.95 ( maybe not right-up-to-the minute latest patches, but fairly recently patched). They are firewalled off from the internet with abolutely no chance of external access, but I can build whatever is required ( Pg 7.3.1 is already installed from source) and upload it to techdocs.postgresql.org (or similar). ...I've never tried to create a Solaris package so I will need answers to all the usual dumb questions - including what extra configure options are required as I've been building with *none* :-) That's cool. Making Solaris packages is pretty easy, and all of the files that might be tricky have already been created. The compilation notes taken whilst making the Solaris 8 Intel packages are at: http://techdocs.postgresql.org/guides/PackagingForSolaris It doesn't mention how to do the packaging bit, but it wouldn't be hard to create step by step instructions for you with minimal effort. :) Sound like a plan? Will also need someone else with a Solaris 8 SPARC system to try the packages out too, just in case there are weird library dependencies happening that might catch us out. Also, am wondering if learning how to do cross compiling instead might be worthwhile. Don't yet know anything about it, but it gets mentioned in a lot of documents. :-) Regards and best wishes, Justin Clift regards Mark -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Anyone have a fresh Solaris 8 SPARC system to create
Lamar Owen wrote: On Wednesday 15 January 2003 09:20, Justin Clift wrote: Sound like a plan? Will also need someone else with a Solaris 8 SPARC system to try the packages out too, just in case there are weird library dependencies happening that might catch us out. I have access to several (two dozen) currently unused Ultra30 systems. I can install Sol8 on one and Sol9 on another and provide ssh access (once I figure out how to get ssh working on Solaris) to you, once I know your static IP address or subnet range. It may be a few days to a week before I can do the actual installation, however. Wow, thanks Lamar. *That's* about as good an offer as I was hoping for. Mark, I can still teach you how to package stuff if you want. In this instance, having direct remote access to systems and being able to ensure things are 100% fresh and correct is that bit safer, as well as having other systems to test against. The easiest way to get OpenSSH up and running on a new Solaris box is to follow the instructions at: http://www.sunfreeware.com/openssh.html He provides packages there for just about everything, although you will need to download the official Solaris patch from the sunsolve.sun.com site that adds the /dev/random and urandom devices to the device tree. It's all pretty straightforward. :-) Can't wait! (But am going to have to). ;-) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[HACKERS] Anyone have a fresh Solaris 8 SPARC system to create a PG 7.3.1 packageon?
Hi guys, Have created a Solaris 8 Intel package for PostgreSQL 7.3.1, but don't have any SPARC boxes here any more. Does anyone have a SPARC box handy that would be available for compiling PostgreSQL 7.3.1 on? It would need to be Solaris 8 (or maybe 9), and have things like gcc 2.95.x and similar tools installed, as well as be patched with the latest recommended Solaris patches. Might be a huge ask, but am figuring it to be worth at least trying. :-) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[HACKERS] Anyone want to get involved in writing the the driver to connectStar/OpenOffice and PostgreSQL?
Hi guys, Have been discussing what it would take to write an SDBC driver for connecting StarOffice/OpenOffice to PostgreSQL with Frank Schönheit, a senior member of the Sun StarOffice/OpenOffice DBA team, and a few senior members of the OpenOffice project. SDBC is based largely on ODBC, so it might be more a matter of porting the existing ODBC stuff rather than a complete re-write. Frank reckons it would take about 2 man weeks of total effort if needed to be written from scratch, so it's probably not going to be too hard for an experienced C++ PostgreSQL coder. Would anyone be interested in getting involved in doing this? If anyone's up for it, the Sun StarOffice/OpenOffice DBA team in Hamburg Germany will be available for support etc. Getting an SDBC driver written to connect Star/OpenOffice and PostgreSQL is very good step towards integrating PostgreSQL support further into Star/OpenOffice. :-) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] psql and readline
Dan Langille wrote: snip As this is changing existing behaviour, I think adding an optional switch to revert to the old behaviour is a good idea. Two thoughts: a) Is it possible to change the behavior of the history as we're discussing? Haven't heard Peter's response to this. b) Do we really want to go to the effort of adding a switch to revert to previous behaviour for something like this? It's almost definitely a win to have \e commands appear in the history, and seems a bit to trivial for adding switches for. ? Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] psql and readline
Justin Clift wrote: b) Do we really want to go to the effort of adding a switch to revert to previous behaviour for something like this? It's almost definitely a win to have \e commands appear in the history, and seems a bit to trivial for adding switches for. Bad wording there... \e commands is meant to mean commands created through using \e -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] psql and readline
Bruce Momjian wrote: snip Let's suppose I am writing a query, and then I do \e to edit the query, and I exit the editor and return to psql. Suppose I decide I want to reedit, so I up arrow. I would expect to get \e, not the query I just edited, no? Wouldn't it depend on how this gets implemented? Maybe least negative impact approach (suggested already): If the large command that was edited is put in the command history before the \e, then both are available and there is no big change from expected behaviour. i.e. one up arrow get the previous \e, and a second up arrow would bring up the command that was worked upon. ? Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] psql and readline
Hi guys, As a curiosity thought, would it be possible to do something like: \ep Where this tells psql to get the query in the history prior to the \e, and edit it interactively? :-) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[HACKERS] Is the 7.3.1 geometry regression test supposed to pass perfectlyon Solaris 8 x86?
of compilation (trying to find the best ones): *** LD_OPTIONS=-L/opt/pgsql/lib -R$ORIGIN/../lib -R/opt/pgsql/lib -i -s -z origin MACHTYPE=i386-sun-solaris CPPFLAGS=-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -march=i586 -mcpu=i686 -funroll-loops -fexpensive-optimizations -I/opt/pgsql/include CFLAGS=-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -march=i586 -mcpu=i686 -funroll-loops -fexpensive-optimizations -I/opt/pgsql/include HOSTTYPE=i386 OSTYPE=solaris PATH=/usr/local/bin:/usr/bin:/usr/ccs/bin *** Compiled using ./configure --prefix=/opt/pgsql --with-openssl Is this stuff useful? :-) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[HACKERS] Next platform query: Alphaservers under VMS?
Hi guys, Also received a through the Advocacy website asking if anyone has ported PostgreSQL to the AlphaServers under VMS. Anyone know if we run on VMS? Last time I touched VMS (about 10 years ago) it wasn't all that Unix-like. :-) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] OS/400 support?
Hi guys, Have passed on the info everyone provided about ways of getting PostgreSQL working on the OS/400 on to the requestor. It would be interesting to see if they go with it. Thanks for the assistance... more stuff will keep on coming through of course. :-) Regards and best wishes, Justin Clift Tom Lane wrote: [EMAIL PROTECTED] writes: It was based on the CMU Hydra project, Really!? Small world ... I was part of the Hydra team, more years ago than I like to admit in public. Somehow, I'm not sure that PostgreSQL-on-OS/400 is likely to be more than a curiosity. Probably. But a lot of our ports are just curiosities, at least to them as aren't running that particular OS. My feeling is that Postgres on top of PASE might be reasonable to support; I doubt we'd want to mess with a native port. regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [webmaster] [HACKERS] New Portal in Place, DNS switched ...
Marc G. Fournier wrote: snip 'K, but that won't help the mirrors themselves ... what we need to do is pull the users-lounge over to the new VM next ... Do you have access to 64.49.215.8? .9 works for me, but .8 doesn't. :-( Regards and best wishes, Justin Clift ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[HACKERS] OS/400 support?
Hi everyone, We don't support OS/400 yet do we? :-) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] OS/400 support?
Tom Lane wrote: Justin Clift [EMAIL PROTECTED] writes: We don't support OS/400 yet do we? Never heard of it. Is it Unix-y? Do you have one available for testing? Oops, should have been clearer. OS/400 is the operating system on the IBM AS/400 series of midrange computers: Info: http://search400.techtarget.com/sDefinition/0,,sid3_gci331973,00.html IBM AS/400 page: http://www-132.ibm.com/content/home/store_IBMPublicUSA/en_US/eServer/iSeries/ Not sure if it's Unix-y or not. Just had the question come through the Advocacy site request form. Will see if anyone else has further info, and then ask the requestor for further details if not. :-) Regards and best wishes, Justin Clift regards, tom lane -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[HACKERS] Have people taken a look at pgdiff yet?
Hi everyone, Just found out that the pgdiff utility (the one for comparing two different PostgreSQL database's) was released and uploaded to SourceForge in November: http://sourceforge.net/projects/pgdiff Have people already looked at this? :-) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] New Portal in Place, DNS switched ...
Peter Mount wrote: On Sat, 4 Jan 2003, Marc G. Fournier wrote: I'm just announcing here, since I'd like to see some ppl testing this out and let us know if there are any problems ... DNS is going to take a little while to propogate, so the old site may still come up in the interium ... another reason not to announce it right away :) Looks pretty good here. However, the bugs link on the main page is currently broken (404: Page not found) http://www.postgresql.org/bugs/bugs.php link from the main page. Ouch, sorry about that. It's fixed now too. :-) Regards and best wishes, Justin Clift Peter -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] New Portal in Place, DNS switched ...
Marc G. Fournier wrote: On Sat, 4 Jan 2003, Tom Lane wrote: Marc G. Fournier [EMAIL PROTECTED] writes: the portal itself is not mirrored, butif you go to, for instance UsersLounge or Downloads, it then gives you the option of which mirror to go to ... Ah. But if I do either, I see Warning: pg_exec(): supplied argument is not a valid PostgreSQL link resource in /usr/local/www/www.postgresql.org/mirrors.php on line 28 and Couldn't query the mirrors table! Might just be a transient problem till DNS updates ... or not ... 'K, let's hope ... I tried it here and the flags all came up :( Dave/Justin? Ok, am online and DNS seems to be propagated out this way. Will take a look now. BTW - Should we do the redirects that the old postgresql.org used to do: i.e.: www.postgresql.org/doc - www.ca.postgresql.org/users-lounge/ and similar. :-) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] New Portal in Place, DNS switched ...
Hi Tom, Sorry about that. Was a combo of two simple problems. It's fixed now. :-) Regards and best wishes, Justin Clift Tom Lane wrote: Marc G. Fournier [EMAIL PROTECTED] writes: the portal itself is not mirrored, butif you go to, for instance UsersLounge or Downloads, it then gives you the option of which mirror to go to ... Ah. But if I do either, I see Warning: pg_exec(): supplied argument is not a valid PostgreSQL link resource in /usr/local/www/www.postgresql.org/mirrors.php on line 28 and Couldn't query the mirrors table! Might just be a transient problem till DNS updates ... or not ... regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] PostgreSQL Password Cracker
Dan Langille wrote: I'll do that. Justin: What's the URL for the .pgpass stuff? So far I see mention of using SSL. That's two items to cover. Anything else? Hi Dan, Very Cool. The URL for the .pgpass stuff is: http://developer.postgresql.org/docs/postgres/libpq-files.html :-) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] v7.3.1 tar ready ... please check it ...
scott.marlowe wrote: On Wed, 18 Dec 2002, Marc G. Fournier wrote: The problem is that there is nothing to announce ... Hi, we fixed some bugs? :) minor releases don't have any features added to them, so isn't really news worthy ... :( I don't know, if you're a postgresql user and you don't read these lists, you might find out about a bug in a release note and upgrade when you otherwise might not. www.linuxtoday.com has weekly updates from many gnu / OSS projects which are far less interesting than our 7.3.1 release is. I could see posting a minor upgrade release notice there and on other OSS news web site (freshmeat, slashdot, etc...) At the very least the PostgreSQL website team should be loudly notified so we can confirm the needed links have been updated prior to the release announcement. It probably wouldn't hurt to go through a proper release process, but determine which steps are optional or not needed for smaller releases. :-) Regards and best wishes, Justin clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Big 7.4 items
[EMAIL PROTECTED] wrote: It is asynchronous without the need of 2 phase commit. It is group communication based and requires the group communication system to guarantee total order. The tricky part is, that the local transaction must be on hold until the own commit message comes back without a prior No, It holds until it's own Writeset comes back. Commits and then send a commit message on the simple channel, so commits don't wait for ordered writesets. Remember total order guarantees if no changes in front of the local changes conflict, the local changes can commit. Do people have to be careful about how they use sequences, as they don't normally roll back? Regards and best wishes, Justin Clift snip Darren -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Big 7.4 items
Bruce Momjian wrote: Joe Conway wrote: snip Point-In-Time Recovery (PITR) J. R. Nield did a PITR patch late in 7.3 development, and Patrick MacDonald from Red Hat is working on merging it into CVS and adding any missing pieces. Patrick, do you have an ETA on that? As Hannu asked (and related to your question below), is there any thought of extending this to allow simple log based replication? In many important scenarios that would be more than adequate, and simpler to set up. snip For PITR-log-based-replication, how much data would be required to be pushed out to each slave system in order to bring it up to date? I'm having visions of a 16MB WAL file being pushed out to slave systems in order to update them with a few rows of data... :-/ Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] http://www.postgresql.org/idocs/ is down
Hi Dan, Thanks for pointing this out. The Admin guys are looking into it now. Hopefully it'll be fixed soon. :-/ Regards and best wishes, Justin Clift Dan Langille wrote: http://www.postgresql.org/idocs/ is down Warning: Unable to connect to PostgreSQL server: The Data Base System is shutting down in /usr/local/www/www/idocs/opendb.php on line 3 Unable to access database -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] http://www.postgresql.org/idocs/ is down
Hi Dan, The database for the postgresql.org sites is back up again now. Thanks for pointing it out. :-) Regards and best wishes, Justin Clift Justin Clift wrote: Hi Dan, Thanks for pointing this out. The Admin guys are looking into it now. Hopefully it'll be fixed soon. :-/ Regards and best wishes, Justin Clift Dan Langille wrote: http://www.postgresql.org/idocs/ is down Warning: Unable to connect to PostgreSQL server: The Data Base System is shutting down in /usr/local/www/www/idocs/opendb.php on line 3 Unable to access database -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group
Hi Tommi, Tommi Maekitalo wrote: snip Hi, there are lots of sites talking about postgresql. But if someone hear about postgresql he sure tries www.postgresql.org. There he just get a list of mirrors. Not really a good start. But worse: there is no links to gborg, advocacy, techdocs, ... Advocacy should be found at www.postgresql.org and have links to the other pages. I found gborg when reading the mailinglistst. It is something like a insidertip. There is a new front page for the www.postgresql.org site that was recently finished, and will be moved into the correct place soon. You can view it for now at wwwdevel.postgresql.org. The new front page has links to the other main websites, so it should help people find the information they need in a much easier way. :-) Hope that's helpful to know. :-) Regards and best wishes, Justin Clift snip Tommi -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Let's create a release team
Hi Dan, It's been mentioned a few times on the Advocacy and Marketing list that we should put together a process for ensuring that all the parts necessary for a release occur properly and smoothly. *** Source code - Initial packaging of the new releases' source code Docs - Confirm with Peter that the Docs are 100% correct in the new source archive RPM's SRPM's - Co-ordinate with Lamar to have these ready before the general announcement? Press Releases for the General Public (multiple languages) - Advocacy and Marketing guys should put together a Press Release intended for the General Public, and have it reviewed/confirmed by the Hackers before getting it ready - Robert (?) should arrange translation of this confirmed good Press Release into multiple languages Press Release for the Technically Minded (?) - Advocacy and Marketing guys (?) should put together a Press Release intended for the Hackers and other Technically Minded folk. Should definitely be reviewed for accuracy by the Hackers before releasing it Websites - Ensure all of the required documentation mentions, links, release info, etc is put in place on the website Mailout - Email the appropriate Press Releases to the General Public, and to the Technically Minded groups Feedback - Find out what could have been done better, and figure out how to make it so for the next one if appropriate *** That was just what came to mind and there's probably more. Each part should probably be something that can be broken down into the necessary parts so that everyone can take care of the bits they're into. I suppose it would be good to have this listed somewhere so that people can make suggestions. Just whipped up a page listing these main points here, and everyone has the ability to make suggestions/edits directly onto that page: http://advocacy.postgresql.org/documents/ReleaseProcess Hopefully that's helpful. :-) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group
Peter Eisentraut wrote: snip Press release: - Supports data in many international characters sets (UNICODE, EUC_JP, EUC_CN, EUC_KR, JOHAB, EUC_TW, ISO 8859-1 ECMA-94, KOI8, WIN1256, etc...) That is just plain wrong. Support for various character sets is years old. Sure is. Notice it didn't say just added or added with this release? It just says supports. It's to highlight the fact that it can be used for non-English character sets. Sure, a whole bunch of people know this, but the main target of the press release is people new to PostgreSQL that don't. :-) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group
Vince Vielhaber wrote: Because of this taken from the above quoted text: they were under constant assault from their clients to use oracle or db2 Last I looked neither Oracle or DB2 were open source, but they both just happen to be commercial and I don't see mysql mentioned. And ? Regards and best wishes, Justin Clift Anything else you don't understand about that? Vince. -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group
Vince Vielhaber wrote: On Mon, 9 Dec 2002, Justin Clift wrote: Vince Vielhaber wrote: Because of this taken from the above quoted text: they were under constant assault from their clients to use oracle or db2 Last I looked neither Oracle or DB2 were open source, but they both just happen to be commercial and I don't see mysql mentioned. And ? And what? If you can't understand the above you're in the wrong business. And ? Regards and best wishes, Justin Clift Vince. -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group
Vince Vielhaber wrote: That's what I thought. You have no argument so your just typing. Hi Vince, Was more hoping you'd care to share your basis for stating Robert's employers clients wanted a commercial database, after he mentioned specifically DB2 and Oracle. Knowing one of the obvious common factors they have and then stating it was definitely the reason - not having sought clarification nor confirmation from Robert - and then further stating that the PG Advocacy and Marketing group wouldn't be able to assist even if that were the case, is extremely bad form coming from anyone, let alone you. Please consider the statements you make by a more accurate approach in the future. Regards and best wishes, Justin Clift Vince. -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group
Vince Vielhaber wrote: On Thu, 5 Dec 2002, Robert Treat wrote: Well, my previous employer uses postgresql, but they were under constant assault from their clients to use oracle or db2. Technically there was no reason to switch, but if your choice is switch databases or go out of business, there really isn't much choice. That tells me their clients wanted a commercial database, not one that's open source. All the marketing in the world won't change that. Really? Why do you say that? :-) Regards and best wishes, Justin Clift Vince. -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] hardware needed ?
Hi Eric, We've already done a fair amount of testing of PostgreSQL on Sparc hardware and Solaris, so it's probably not all that interesting... :-/ However, about an hour after you sent through your message, we received this one from Myk Melez. He's asking us if there is a publically available PostgreSQL server, and there isn't yet, so I'm wondering if you'd be willing to setup a PostgreSQL server on your Sparccenter 2000 and let anyone anywhere connect to it, for a while at least. We wouldn't want it to be extremely long term, as you never know what un-cool things people could decide to store in there, but it might be useful for a week or two after Myk's article becomes available for readers. Would you be interested in this? :-) Regards and best wishes, Justin Clift Original Message Subject: [GENERAL] publicly available PostGreSQL server? Date: Fri, 06 Dec 2002 12:33:10 -0800 From: Myk Melez [EMAIL PROTECTED] Organization: mozilla.org To: [EMAIL PROTECTED] Is there a publicly available PostGreSQL server? I'm co-writing an article for an online journal that includes information about Mozilla's upcoming database support, and I'd like to point readers to a PostGreSQL installation where they can try out an example app without having to install their own server. More info about database support in Mozilla: http://bugzilla.mozilla.org/show_bug.cgi?id=81653 -myk Eric Gentilini wrote: Hi all, I didn't find any other list compatible with this post, I hope it is the right place. I got a sparccenter 2000 (sun4d) few weeks ago and I wondered if the postgresql team was interested in testing postgres on it. It has only 2 CPUs at this time but I may get more cpu and system boards in the next month. I thought it would have been interesting to test postgres on uch an architecture. Are you interested ? Would you be interested ? It runs solaris 8 and linux, but linux doesn't support smp on sun4d :/ ... and since the kernel team doesn't work on sparc32 anymore, I thought it could be used by user-land software projects. The machine is located on an dsl lins 128/512kbps. seeya a+ -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Shrinkwrap Windows Product, any issues? Anyone? (postmaster
Igor Georgiev wrote: snip I also be GLAD to read about plans for native windows port in 7.4. If anyone is interested i can post source code, or maybe this firrst steps can go to gborg as a separate project i'm not sure yet. Hi Igor, This would be a really good thing to get into GBorg as a project, so people could work on this through CVS. Would you like to register it as a project? Mark, do you feel it would be better to put your installer plus this together into one project on GBorg too? Not sure, it's just a thought. :-) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Shrinkwrap Windows Product, any issues? Anyone? (postmaster
mlw wrote: snip Once we do that, the we have the hook for more reliable and powerful systems. Yep, I pretty much agree. :-) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Shrinkwrap Windows Product, any issues? Anyone? (postmaster
Hi Mark, mlw wrote: Justin: Are you involved with gborg? Nope, that's Chris Ryan's area. :) I have been thinking about Igor's console and my installer. I think there is a good enough need to host a project that contains HOWTOs, scripts, and tools to make PostgreSQL easy for Windows deployment. It is good to keep all of the instructions+code together, or better to put the instructions somewhere (i.e. the Techdocs site) plus links to the Gborg project to get the code. Either way could work, etc. I am working on a HOWTO, a set of Windows batch files, and the install scripts I would be glad to post, and I would be very glad to include Igor's console in the install. Yep, he does seem to have created a pretty nifty console. It would make a cool offering. :-) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[HACKERS] A thank you from an end user
Hi everyone, We just received this message through the contact form on the Advocacy site. Thought it would be nice to hear. :-) (btw Ajay, you're probably best to upgrade to PostgreSQL 7.2.3 or 7.3 [just released], as 7.2.1 had a few nasty bugs in it) Regards and best wishes, Justin Clift Original Message Subject: A within the next day or two request for a PostgreSQL contact from advocacy.postgresql.org Date: Tue, 3 Dec 2002 08:50:32 -0500 (EST) From: Advocacy Website [EMAIL PROTECTED] Ajay Narke has requested to be contacted in regards to PostgreSQL. Email address : [EMAIL PROTECTED] Preferred language : English The nature of the request : I am a user of PostgreSQL 7.2.1. It's been a great experiance. PostgreSQL + RedHat Linux + Java Servlets + HTML make a very formidable combination. Congratulations to all those in development team. The region of the requester : INDIA The name of the requester's company : Narke Associates The number of people in the requester's company : 20 The urgency of the request is : 2 -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group Announces
Dave Page wrote: snip Strangely I was just thinking the same thing. If all the info is on advocacy, then what exactly will be left on the main site? Idocs? Good point, and worth thinking about then. I was sort of under the impression that the site reshuffle was happening in a top down manner anyway - start with the portal, then sort out the less-immediately-visible lower bits. I'll preempt the 'this was all discussed on -advocacy, you should have been there' response with yet another agreement with Vince :-) - I too am getting far too much mail these days and another list is the last thing I need. Ok then, what do you suggest? :-) Regards and best wishes, Justin Clift Regards, Dave. -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group Announces
Marc G. Fournier wrote: snip So as to not recreate the wheel, or, at least, get the wheel properly rolling, can we get that download page redirected to the one that does list the mirrors? :) Yep. Would the best way to do this be changing the wording to say something like: PostgreSQL can be downloaded as source code from any of the many mirror sites: With a link after it directing to somewhere that gives the list. The present www.postgresql.org with the list of mirrors would probably be adequate, but it'll need to be a different url than the straight www.postgresql.org as that's going to change as soon as the new portal is in place. Does this sound like a workable approach for now? Regards and best wishes, Justin Clift I liked Greg(?)'s ideas, but I don't see it as being implemented overnight :) -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: PostgreSQL in Universities (Was: Re: [HACKERS] 7.4 Wishlist)
Marc G. Fournier wrote: On Tue, 3 Dec 2002, Justin Clift wrote: Excellent. Are there any other people involved in PostgreSQL and universities or educational institutions? If so we could put something together about experiences for the advocacy Web site. Is this the kind of thing that the Techdocs Guides area would be good for? (http://techdocs.postgresql.org/guides) Seems that any discussions about experiences belongs on Advocacy, no? Good point. Have put a *really basic* Zwiki framework at: http://advocacy.postgresql.org/documents It's the same collaborative software used for the PostgreSQL Guides section, but without the look+feel added. If you want to start editing stuff right away, then feel free to use it. If you'd like it to look better first though, then it'll be a few days... :-) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: PostgreSQL in Universities (Was: Re: [HACKERS] 7.4 Wishlist)
Marc G. Fournier wrote: snip Actually, there are lines, Justin just occasionally appears to 'blur' them until I get a chance to refresh them ... eh Justin?:) [innocent whistle] + Justin ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group Announces
Dave Page wrote: snip I could have sworn we used to have a bunch of ftp mirrors for downloads. Come to think of it I rewrote/stole a load of Vince's PHP code to allow you to select one from the portal recently. Are we not using them anymore? Of course we are, it's just that we're also trying to direct people to the Advocacy site where there is a lot more info, in a lot more languages. The only reason for the download page not having a list of mirrors is due to not having done it yet. :-) Regards and best wishes, Justin Clift :-) Regards, Dave. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group Announces
Peter Eisentraut wrote: Marc G. Fournier writes: Yup, as with doing anything for the firs ttime, the press release itself had its 'bugs' ... considering how many times Josh asked for comments on it, I'm surprised that nobody picked up on it *shrug* And how should we have guessed that release management is now done by the advocacy group? While you're out advocating, don't forget the existing users. Sorry Peter. Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group Announces
Peter Eisentraut wrote: Justin Clift writes: Of course we are, it's just that we're also trying to direct people to the Advocacy site where there is a lot more info, in a lot more languages. Why don't we just shut down the regular web site. Clearly it's not considered adequate anymore. Well, qe're trying to move the new portal side of things into place (presently at wwwdevel.postgresql.org), so that all of the different PostgreSQL pieces are more easily accessible. Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: PostgreSQL in Universities (Was: Re: [HACKERS] 7.4 Wishlist)
Gavin Sherry wrote: On Mon, 2 Dec 2002, Christopher Kings-Lynne wrote: I've given a talk in the 2002 honours lecture series at UWA about Postgres and some of the things it can do. All of those guys were interested. Especially since the deptartment does a lot of work in genetic algoriithms. Excellent. Can you put that talk online somewhere? Tell me when you start working on a document - I'm happy to help. Since I'm only just out of Uni, I'd like to write a set of possible assignments and learning outcomes and how you can use postgres to support them. My girlfriend is a PhD student at UWA CS dept :) plus I won the honours scholarship there a year or two back, so I can get interest from the dept, including the databases lecturer. Might help for another point of view and feedback. Excellent. Are there any other people involved in PostgreSQL and universities or educational institutions? If so we could put something together about experiences for the advocacy Web site. Is this the kind of thing that the Techdocs Guides area would be good for? (http://techdocs.postgresql.org/guides) :-) Regards and best wishes, Justin Clift snip Gavin ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Does anyone know what embedded transactions are?
Joe Conway wrote: snip Has anyone from Compiere ever contacted this list to discuss their issues? It is an unbelievable shame that the most active open source ERP can't use an open source database. I think so, but not with zeal. :-/ Regards and best wishes, Justin Clift Joe -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Postgres 7.3 announcement on postgresql.org
Vince Vielhaber wrote: On Fri, 29 Nov 2002, Bruce Momjian wrote: FYI, Vince, I started reading all my email (using elm) in a special 120 column wide, 38 row xterm. There was just too much detail in those subjects i was missing. Doesn't do me much good if too often I don't have the luxury of a large screen 'cuze I'm reading from a remote site with horrible resolution or just an 80x25 screen. Would a better subject line, fitting in the smaller default width, have been something like: PostgreSQL 7.3 Released! by the PostgreSQL Global Development Group So hopefully it would look something like: 17096 Nov 28 PostgreSQL Public (6733) [GENERAL] PostgreSQL 7.3 Released! b Am thinking that regardless of the wording of the release, it doesn't hurt us to do simple things like re-arranging the Subject line to make things a bit more obvious. ? Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Postgres 7.3 announcement on postgresql.org
Vince Vielhaber wrote: snip Yes it would. But while on the subject, why did you only mention it's availability being on the advocacy site? *We* mentioned it's availability being on the Advocacy site, because it gives people a single place to go that has both PostgreSQL itself *and* a site that's dedicated to giving a clear list of features, advantages, case studies, etc. This Press Release was created to give a clear path to PostgreSQL usage for new users (i.e. initial interest - place to find out about it - advantages, cast studies, etc) Are the ftp and website mirrors now irrelevant to you? Not sure what you mean here. Regards and best wishes, Justin Clift Vince. -- http://www.meanstreamradio.com http://www.unknown-artists.com Internet radio: It's not file sharing, it's just radio. -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] Postgres Security Expert???
Hi Chris, Just received this from them. Look like he was trying to claim stuff that wasn't true. :-/ Thanks for pointing this out Chris. :) Regards and best wishes, Justin Clift *** Original Message Subject: Re: Demande de renseignements Defi SYSDOOR Date: Tue, 26 Nov 2002 11:04:47 +0100 From: Vergoz Michael (SYSDOOR) [EMAIL PROTECTED] To: [EMAIL PROTECTED] References: 200211260205.gAQ25GTK009595@jenna Dear Clift, Justin Clift PostgreSQL Global Development Group demande des informations son adresse : Son e-mail : [EMAIL PROTECTED] Son téléphone : +61.393631313 Son message : Hi, Just noticed your website mentioning that Michael Vergoz is well known to created security patches for PostgreSQL: http://kernel.sysdoor.com/eng/ Can you please point us in their direction, as we don't know him by name. Right, it's true that i never make _security_ patches for PostGreSQL... As a side thought, would you please be able to correct the spelling of PostgreSQL on the same page. Presently it's spelt PostGreSQL, which is incorrect. Better way, i'v remove postgresql name in the site, as i think you want. Regards and best wishes, Justin Clift -- - Source IP : 203.173.161.124 (p378-tnt1.mel.ihug.com.au) Secure ID : [EMAIL PROTECTED] -- - Best Regards, Vergoz Michael SYSDOOR Founder *** -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Postgres Security Expert???
Christopher Kings-Lynne wrote: Does anyone know who the Postgres security patcher mentioned in this article is: http://kernel.sysdoor.com/eng/ Is it that guy who found all the buffer overflows? Don't know. Just asked them through their online form. Let's hope they get back to us. :-) Regards and best wishes, Justin Clift Chris -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[HACKERS] Interesting thought from an article about Sun technologies
Hi everyone, Was just reading an article regarding Sun technologies on TheRegister: http://www.theregister.co.uk/content/53/28259.html *** The real problem with databases is administrative, he argued, where the DBA must do index rebuilds. Clustra had eliminated that problem because it was doing constant indexing. So the GUI has gone, along with the Rebuild button. *** Is Constant indexing something that sounds interesting for us to look at? :-) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] [GENERAL] Bug with sequence
Oliver Elphick wrote: On Wed, 2002-11-20 at 21:35, Robert Treat wrote: On Wed, 2002-11-20 at 03:53, Oliver Elphick wrote: On Mon, 2002-11-18 at 15:45, Thomas Aichinger wrote: Hi, I recently installed pg 7.2.3 on my linux box and discovered that there are some problems with datatype serial and sequence. 1.) If you create a table with a datatype serial, the corrsponding sequence will be created, but if you drop the table the sequence is not dropped. This is fixed in 7.3 out of curiosity, do you know the logic that implements this fix? I have a couple of tables that use the same sequence; I'm wondering if dropping one of the tables removes the sequence or if I have to drop all tables before the sequence is removed I just tried it. I created a sequence using SERIAL when I created a table. I used the same sequence for another table by setting a column default to nextval(sequence). I deleted the first table. The sequence was deleted too, leaving the default of the second table referring to a non-existent sequence. This sounds like a serious bug in our behaviour, and not something we'd like to release. Specifically in relation to people's existing scripts, and also to people who are doing dump/restore of specific tables (it'll kill the sequences that other tables depend on too!) No real issue with the nicety for newbies, but am very concerned about the lack of a dependancy check here. :-/ Regards and best wishes, Justin Clift Could this be a TODO item in 7.4, to add a dependency check when a sequence is set as the default without being created at the same time? -- Oliver Elphick[EMAIL PROTECTED] Isle of Wight, UK http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C If my people, which are called by my name, shall humble themselves, and pray, and seek my face, and turn from their wicked ways; then will I hear from heaven, and will forgive their sin, and will heal their land. II Chronicles 7:14 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] [GENERAL] Bug with sequence
Neil Conway wrote: Justin Clift [EMAIL PROTECTED] writes: This sounds like a serious bug in our behaviour, and not something we'd like to release. It's not ideal, I agree, but I *definately* don't think this is grounds for changing the release schedule. Hey, I'm no fan of slowing the release schedule either. Bug this is definitely sounding like a bug. No real issue with the nicety for newbies, but am very concerned about the lack of a dependancy check here. Well, how would you suggest we fix this? ISTM this is partially a result of the fact that we don't produce dependancy information for function bodies. While it might be possible to do so (in 7.4) for certain types of functions (e.g. for functions defined in SQL, PL/PgSQL, etc.), I can't see a general solution (e.g. for functions defined in C). Absolutely *no* idea. And adding random hacks to get specific functions (e.g. nextval()) to work does not strike me as a very good idea. Agreed. Random hacks aren't always a good approach. Regards and best wishes, Justin Clift Cheers, Neil -- Neil Conway [EMAIL PROTECTED] || PGP Key ID: DB3C29FC -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[HACKERS] Looking for a Linux on Playstation 2 person to compile PostgreSQL RPM's
Hi everyone, We know PostgreSQL will compile and run on the Sony Playstation 2, and we now have the opportunity to include pre-compiled PostgreSQL RPM's (for the Playstation 2 Linux kit) on the Sony site, as part of the Compiled For Your Convenience collection. Now, we just need someone with the Linux for Playstation 2 kit to compile the RPM's so they can be added. Does anyone already have a Linux for Playstation 2 kit and would be willing to compile them? :-) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Propose RC1 for Friday ...
Bruce Momjian wrote: Tom Lane wrote: snip Personally I think this is a low-risk patch and so choice 2 is appropriate. If this is the only change, then 2 does seem like the best mix of risk/progress. :-) Regards and best wishes, Justin Clift Sorry, I was vague. I think we should apply and go to RC1 tomorrow. There will always be tweaks and fixes. If we expect it to be perfect, we will never make a final release. We are 2.5 months into beta, and if we don't want +3 months beta, we should get going. We have to start taking some _reasonable_ risks to move this forward. Until we make a final, we will not increase our test pool, and at this point we are all sort of staring at each other. Let's go! snip -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] Time to move on...
Thomas Lockhart wrote: Just a quick note to mention that I've resigned from the PostgreSQL steering committee. Wow. That was totally unexpected. A sad day. :-/ It has been a lot of fun and very rewarding to participate in PostgreSQL development over the last six years, but it is time to take a break and to move on to other projects. Good luck Thomas. Truly hope you're going to have heaps of fun, enjoy yourself, and find the new projects rewarding too. Regards and best wishes, Justin Clift Thanks to Marc, Bruce, and Vadim for welcoming me many years ago. It has been great working with the group and I'm looking forward to seeing PostgreSQL achieve greater and greater success in the coming years. - Thomas -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[HACKERS] Does v7.2.x support AIX 5.1?
Hi guys, We received a query through the Advocacy site about whether we support AIX 5.1 or not, so am trying to find out. Just took a look at the Supported Platforms list, and the FAQ_AIX document (for 7.2.x) and it doesn't seem to mention specific versions of AIX that are supported. Does PostgreSQL 7.2.x (and also 7.3 when it's released) support AIX 5.1? :-) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] RC1?
Tom Lane wrote: snip Anyone care about the PlayStation 2 port ;=) ? I can get Permaine to retest if so. Slightly more seriously, we did see a recent report of trouble on S/390 Linux, but the complainant didn't follow up... Heh Heh Heh Tom, would you really be able to ask Permaine to retest 7.3? Have a feeling we might be able to leverage the PlayStation2 brand name here for the Advocacy project. :-) Regards and best wishes, Justin Clift regards, tom lane -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] 500 tpsQL + WAL log implementation
Bravo Curtis, This is all excellent research. :-) Regards and best wishes, Justin Clift Curtis Faith wrote: snip Disk space is much cheaper than CPU and memory so I think that a logging system that used as much as three or four times the space but is three or four times faster would be a worthwhile improvement for those systems where updates or insert volume are very heavy. Obviously, this needs to be an option, not the default configuration. - Curtis -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[HACKERS] Romanian version of the PostgreSQL Advocacy and Marketing site is ready
Hi everyone, Thanks to Adrian Maier [EMAIL PROTECTED], the Romanian translation of the PostgreSQL Advocacy and Marketing site is now completed and ready for public use: http://advocacy.postgresql.org/?lang=ro :-) Dutch is presently being worked upon, and will hopefully be ready soon. :) That'll make an even 10 languages! Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Win32 port
Peter Eisentraut wrote: Jan Wieck writes: To Hannu: the Windows port we did here depends on MS VC++ features like the ability to specify in the project to substitute header files. I don't know much about MingW and if you can do things like that with it. Before long someone will port the Windows port to MinGW, so we should resist attempts to use compiler-specific features in the same way that we tend not to use vendors specific features in other ports. Absolutely. With the present push by over 30 governments of countries, and other large institutions around the world for adopting Open Source software in significant ways, we'd be kind of short-sighted to do things in a way that mostly limits people to using M$ products. :-) Regards and best wishes, Justin Clift -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] Win32 port
Bruce Momjian wrote: snip What do others want, a regular 4-6 month cycle or a shorter one? Whilst having a regular 4-6 month cycle (er... when was the last time THAT happened?) is alright, we should get the *Windows* native version out to the world ASAP. This (and secondly PITR) will greatly enhance the number of users we have. It's important to do this because companies and governments are looking to Open Source software in serious ways *now* so we need to be in place to meet that need as it starts to kick in. :) Regards and best wishes, Justin Clift -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Win32 port
Bruce Momjian wrote: I have copies of Peer Direct's (Jan's company) port of PostgreSQL to Win32, and SRA's port to Win32, and permission to generate a merged patch that can be applied to 7.4. Now that 7.3 is almost complete, I am going to start work on that. I will post patches that deal with specific portability issues, like fork/exec and path separator handling, and once reviewed, apply them to the main CVS tree for 7.4. Whoo Hooo! :-) + Justin -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[HACKERS] PostgreSQL IRC Channel... who's the Admin?
Hi all, Who's an Admin for the PostgreSQL IRC Channel (#postgresql) on irc.openprojects.net? The topic there is advertising some items for some guy on eBay, claiming it supports the PostgreSQL channel, and no-one knows anything about it. There also doesn't appear to be any IRC Admin's about. So, does anyone know who the Admin's are, so we can get things fixed up? :-) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] PostgreSQL IRC Channel... who's the Admin?
Hi Neil, Cool. It's fixed now. We've just recreated the channel and started giving operator access to the right people. :-) Regards and best wishes, Justin Clift Neil Conway wrote: Justin Clift [EMAIL PROTECTED] writes: Hi all, Who's an Admin for the PostgreSQL IRC Channel (#postgresql) on irc.openprojects.net? The only person I've seen with ops is someone called 'raja', who is only rarely (i.e. once every couple months) in the channel. I talked to lilo about getting Bruce ops, and he talked to Bruce about it. Not sure what came out of that... Cheers, Neil -- Neil Conway [EMAIL PROTECTED] || PGP Key ID: DB3C29FC -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[HACKERS] Spanish version of the PostgreSQL Advocacy and Marketing site is ready
Hi everyone, Thanks to Alvaro Herrera [EMAIL PROTECTED], the Spanish translation of the PostgreSQL Advocacy and Marketing site is now completed and ready for public use: http://advocacy.postgresql.org/?lang=es :-) Anyone else want to translate it for other languages? :) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] [GENERAL] Database replication... - Mission Critical
Andrew Sullivan wrote: On Wed, Oct 30, 2002 at 10:18:47AM -0500, Robert Treat wrote: regarding replication, as well as a high availability how-to that would probably be worth reading. The high availability howto suggests using rsync to synchronise the data areas of two data servers. That is an _extremely bad_ idea. I've suggested before that the link be removed, because it recommends something almost guaranteed to introduce massive database corruption at some point. If there's no load and you have a fast network, you might get lucky. But it is an extremely dangerous plan. Ok, have just removed the link. Sorry for not getting around to it before Andrew. (Bruce pointed out your email, otherwise I would have missed it again too). :-/ Regards and best wishes, Justin Clift A -- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada [EMAIL PROTECTED] M2P 2A8 +1 416 646 3304 x110 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[HACKERS] Swedish version of the PostgreSQL Advocacy and Marketing site is ready
Hi everyone, Thanks to Henrik Edlund [EMAIL PROTECTED], the Swedish translation of the PostgreSQL Advocacy and Marketing site is now completed and ready for public use: http://advocacy.postgresql.org/?lang=sv :-) Spanish should available pretty soon too (next few days at least). Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[HACKERS] Brazilian Portuguese version of the PostgreSQL Advocacy and Marketing site is ready
Hi everyone, Thanks to Diogo Biazus [EMAIL PROTECTED], the Brazilian Portuguese translation of the PostgreSQL Advocacy and Marketing site is now completed and ready for public use: http://advocacy.postgresql.org/?lang=br :-) Wow, that's 6 languages already, and more are coming along. Am very, very proud of our community members. :-) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[HACKERS] German version of the PostgreSQL Advocacy and Marketing site is ready
Hi everyone, Thanks to Cornelia Boenigk [EMAIL PROTECTED] and Michael Paesold [EMAIL PROTECTED], the German translation of the PostgreSQL Advocacy and Marketing site, is now completed and ready for public use: http://advocacy.postgresql.org/?lang=de This makes 5 languages done, with Brazilian Portuguese and Spanish nearly ready too. :-) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] Postgresql and multithreading
Bruce Momjian wrote: Anuradha Ratnaweera wrote: snip Nope. To keep the `original' code licence as it is and to release the changes GPL? Is the question sane at first place? That would be a pretty big mess, I think. People would add your patch to our BSD code and it would be GPL. It could be done, of course. Don't think so. The patches would be derived code that only exist because of the BSD licensed PostgreSQL base. Being derived code they'd have to be released as BSD and GPL wouldn't enter the picture, regardless if they're released separately as add-on patches or not. :-) Regards and best wishes, Justin Clift -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[HACKERS] French version of the PostgreSQL Advocacy and Marketing site is ready
Hi everyone, Thanks to the French members of the PostgreSQL Community (mainly François Suter [EMAIL PROTECTED]), the French translation of the PostgreSQL Advocacy and Marketing site, is now complete and ready for public use: http://advocacy.postgresql.org/?lang=fr That's 4 completed languages at this point, with more coming along. Let's see how many more can be added... :) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Anyone want to assist with the translation of the Advocacy
Hi Adrian, Wow. That's pretty cool. :) No-one has offered to do Romanian yet, so you're very welcome to. First things first: - What is the two letter language identifier most often used for Romanian? i.e. fr = Franch, de = German, etc. ro? - What is the character set that should be used to send out Romanian pages? i.e. for English, French, German it's iso-8859-1, for Turkish it's iso-8859-9, Romanian = ? :-) Regards and best wishes, Justin Clift [EMAIL PROTECTED] wrote: Hello ! I'd like to translate the advocacy site to Romanian, as long as nobody else has already offered himself/herself to do it. Just tell me, please, what should i do. Adrian Maier ([EMAIL PROTECTED]) -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[HACKERS] Turkish version of the PostgreSQL Advocacy and Marketing site is ready
Hi everyone, The Turkish translation of the PostgreSQL Advocacy and Marketing site, done by Devrim GUNDUZ [EMAIL PROTECTED] is now complete and ready for public use: http://advocacy.postgresql.org/?lang=tr Pretty cool stuff. Thanks Devrim. :-) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Script to compute random page cost
Hi all, As an end result of all this, do we now have a decent utility by which end user admin's can run it against the same disk/array that their PostgreSQL installation is on, and get a reasonably accurate number for random page cost? ie: $ ./get_calc_cost Try using random_page_cost = foo $ :-) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] oid2name and relfilenode
Bruce Momjian wrote: Bruce Momjian wrote: Now that we are changing relfilenode in 7.3, I think we need to rename oid2name to relfilenode2name, and perhaps move it into the main tree. TODO item added: Rename oid2name to relfilenode2name and install by default Should it be renamed to pg_something for namespace consistency? :-) Regards and best wishes, Justin Clift Actually, to be accurate, I think databases are stored based on their oid and tables/indexes are stored based on their relfilenode. That is pretty confusing. Do we still do the renaming? -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] [GENERAL] Point in Time Recovery WAS: Hot Backup
Rod Taylor wrote: snip Oh, if thats your problem then use asynchronous replication instead. For specific info, the contrib/rserv package does master-slave asynchronous replication as Rod is suggesting. From memory it was having troubles working with PostgreSQL 7.2.x, but someone recently submitted patches that make it work. There's a HOW-TO guide that a community member wrote on setting up rserv with PostgreSQL 7.0.3, although it should be practically identical for PostgreSQL 7.2.x (when rserv is patched to make it work). http://techdocs.postgresql.org/techdocs/settinguprserv.php That could be the basis for your async replication solution. Hope that helps. :-) Regards and best wishes, Justin Clift It doesn't remove the slow time, but will distribute the slowness across every transaction rather than all at once (via creation of replication logs). Things won't degrade much during the snapshot transfer itself, as there isn't very much work involved (differences only). Now periodically backup the secondary box. Needs diskspace, but not very much power otherwise. #!/bin/sh while(true) do asynchreplicate.sh pg_dumpall `date`.bak done -Original Message- From: scott.marlowe [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 12:19 PM To: Sandeep Chadha Cc: Tom Lane; [EMAIL PROTECTED]; pgsql-general Subject: [GENERAL] Point in Time Recovery WAS: Hot Backup Hi Sandeep. What you were calling Hot Backup is really called Point in Time Recovery (PITR). Hot Backup means making a complete backup of the database while it is running, something Postgresql has supported for a very long time. On Mon, 7 Oct 2002, Sandeep Chadha wrote: Hello to all the Doers of Postgres!!! Last time I went through forums, people spoke highly about 7.3 and its capability to do hot backups. My problem is if the database goes down and I lose my main data store, then I will lose all transactions back to the time I did the pg_dump. Let's make it clear that this kind of failure is EXTREMELY rare on real database servers since they almost ALL run their data sets on RAID arrays. While it is possible to lost 1 drive at the same time and all your database, it is probably more likely to have a bad memory chip corrupt your data silently, or a bad query delete data it shouldn't. That said, there IS work ongoing to provide this facility for Postgresql, but I would much rather have work done on making large complex queries run faster, or fix the little issues with foreign keys cause deadlocks. Other databases (i e Oracle) solves this by retaining their archive logs in some physically separate storage. So, when you lose your data, you can restore the data from back-up, and then apply your archive log, and avoid losing any committed transactions. Postgresql has been lacking this all along. I've installed postgres 7.3b2 and still don't see any archive's flushed to any other place. Please let me know how is hot backup procedure implemented in current 7.3 beta(2) release. Again, you'll get better response to your questions if you call it point in time recovery or pitr. Hot backup is the wrong word, and something Postgresql DOES have. It also supports WALs, which stands for Write ahead logs. These files store what the database is about to do before it does it. Should the database crash with transactions pending, the server will come back up and process the pending transactions that are in the WAL files, ensuring the integrity of your database. Point in Time recovery is very nice, but it's the last step in many to ensure a stable, coherent database, and will probably be in 7.4 or somewhere around there. If you're running in a RAID array, then the loss of your datastore should be a very remote possibility. ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly -- Rod Taylor ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[HACKERS] Italian version of the PostgreSQL Advocacy and Marketing site is ready
Hi everyone, The Italian translation of the PostgreSQL Advocacy and Marketing site, done by Stefano Reksten [EMAIL PROTECTED] is now complete and ready for public use: http://advocacy.postgresql.org?lang=it Thanks heaps Stefano, you've put in a lot of effort and it's really going to help. :-) In addition to this, Stefano has also volunteered to be an Italian language contact for the PostgreSQL Advocacy and Marketing team. With luck we'll gain good PostgreSQL representatives for *all* of the major languages and get some nifty stuff happening. :-) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] Analysis of ganged WAL writes
Greg Copeland wrote: snip If so, I assume it would become a configure option (--with-aio)? Or maybe a GUC use_aio ? :-) Regards and best wishes, Justin Clift Regards, Greg Name: signature.asc signature.asc Type: application/pgp-signature Description: This is a digitally signed message part -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Threaded Sorting
Bruce Momjian wrote: scott.marlowe wrote: snip It seems like sometimes we consider these issues more from the one or two SCSI drives perspective insted of the big box o drives perspective. Yes, it is mostly for non-RAID drives, but also, sometimes single drives can be faster. When you have a drive array, it isn't as easy to hit each drive and keep it running sequentially. Of course, I don't have any hard numbers on that. ;-) Arrghh... please remember that big bunch of drives != all in one array. It's common to have a bunch of drives and allocate different ones for different tasks appropriately, whether in array sets, individually, mirrored, etc. 100% totally feasible to have a separate 15k SCSI drive or two just purely for doing sorts if it would assist in throughput. :-) Regards and best wishes, Justin Clift -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[HACKERS] OT: Looking to Open Source the Flash training material
Hi everyone, Have been thinking for a while now about viable ways to Open Source the Flash based training material that has been in development from last year. After discussing this with a number of people for suggestions, feedback, advise, etc, these are looking to be the general concepts that, as a whole, would likely work to greatest effect: *** - Create a new Open Source license specifically for this. The er... DDPL (?). Digital Distribution Public License. - Release the source code to all the Flashes developed thus far, through this license. The DDPL would go something like this: - People can use the source Flash files to create training content for any kind of software they so choose to. We of course heartily recommend Open Source Software. Everything released must also be under the DDPL. - All content must be released unrestricted, etc, and the Flash source files must be available for all. It's allowed to be included with paid for products. No restrictions, etc. - All content and Flash source files under the DDPL must also be submitted to us, so we can decide whether or not to include them the digitaldistribution.com site or not, etc. We can distribute through resellers, etc, and no royalties are applicable. Additionally: - We make a few points really clear and simple on the website. The primary reason for existence for the digitaldistribution.com site is to educate end users, and additionally to create a revenue stream that can be used to hire further developers for Open Source projects and be used to the benefit of the Open Source Community as need be (i.e. hire lawyers to fight against inappropriate patents, pay for advertisements and research studies, etc). - Open up the translation interface and mechanisms on the digitaldistribution.com site so that people can come along and do translations for their language as they feel like it. - Have a support mechanism (in a way that's fair) so that resellers of the tutorials are well funded to provide support for the communities of their native languages, etc. - Will probably work in something about Membership fees for the digitaldistribution.com site will be based upon the GDP for a nation, so that for example, a person coming from Thailand isn't charged anywhere near as much as a person in the US. Not sure how to make it workable, but it's the start for addressing an important issue. *** Please remember this is just a start and might totally change or be dropped entirely, depending on whether it looks to be workable and beneficial, etc. Now looking for thoughts and feedback on this from a wider audience, so hoping people have good ideas, beneficial directions, etc. If everything is looking good, then we'll look to ensuring this is a workable Open Source license, etc. (www.opensource.org) :-) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Anyone want to assist with the translation of the Advocacy
Thomas O'Connell wrote: Is anyone interested in translating the English version to other languages? I don't have time for the translation, unfortunately, but i would suggest changing worlds to world's on the main page. Um, doesn't world's mean world is ? That wouldn't make sense then though. ? Regards and best wishes, Justin Clift -tfo ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Anyone want to assist with the translation of the
Thomas F.O'Connell wrote: Um, doesn't world's mean world is ? In this situation, the 's denotes possession, as in the most advanced open source database of the world. worlds here is basically saying every world most advanced open source database and does not, in any case, connote possession. Ok, updating it now. Thanks heaps Thomas. :-) Regards and best wishes, Justin Clift -tfo -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] [GENERAL] Large databases, performance
Shridhar Daithankar wrote: snip Was the original posting on GENERAL or HACKERS. Is this moving the PERFORMANCE for follow-up? I'd like to follow this discussion and want to know if I should join another group? Shall I subscribe to performance? What's the exat list name? Benchmarks? I don't see anything as performance mailing list on this page.. http://developer.postgresql.org/mailsub.php?devlp It's a fairly new mailing list. :) [EMAIL PROTECTED] Easiest way to subscribe is by emailing [EMAIL PROTECTED] with: subscribe pgsql-performance as the message body. :-) Regards and best wishes, Justin Clift snip Bye Shridhar -- Clarke's Conclusion:Never let your sense of morals interfere with doing the right thing. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] [GENERAL] Anyone want to assist with the translation of theAdvocacy
Hi Tino, Tino Wildenhain wrote: Hi Justin, you want probably use the language-negotiation rather then a query variable :-) Um, language-negotiation in good in theory, but there are real world scenarios it doesn't take into account. :( However, the query variable is an override, and if one isn't present then the backend is supposed to use other means to determine the appropriate language, including the browsers preferred language. It's just that the code to do this bit hasn't been written yet. :-) If all else fails it falls back to a default language, English for this site. :-) Regards and best wishes, Justin Clift Regards Tino snip -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] [HACKERS] Anyone want to assist with the translationof the
Tino Wildenhain wrote: snip Haha cutpaste ;-) Ever heard of csv? :-)) However, I can also have a look at it, if desired. Heh Heh Heh Good point. For the moment we've whipped up that MS Excel document (created in OpenOffice of course) of all the English text strings in the site and emailed it to the volunteers. :) So far community members have volunteered for German, Turkish, French, Spanish, Brazilian Portuguese, and Polish. Cool. :) Want to co-ordinate with the other two German language volunteers? Regards and best wishes, Justin Clift Regards Tino -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Anyone want to assist with the translation of the Advocacy
[EMAIL PROTECTED] wrote: snip Cool. Could you deal with an OpenOffice Calc or M$ Excel file having the lines of English text in one column, and doing the German translation into a second column? Isn't this, um, the sort of thing you might want to put into, um, a, um, database? Sure is. Are there any good options apart from? a) Build an interface for people to translate through b) Allow selected people to connect directly to the database For the present b) is not an option as I don't have the needed access to the postgresql.org database server to be able to adjust the pg_hba.conf file, and a) Would take some decent time and effort to get up and running. A lot longer than cut and pasting into an Excel document then back out again. :-/ Regards and best wishes, Justin Clift -- (concatenate 'string aa454 @freenet.carleton.ca) http://cbbrowne.com/info/internet.html you can obvioulsy understand what i'm saying. you're just being pendantic. -- [EMAIL PROTECTED] -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] [GENERAL] New PostgreSQL Website : advocacy.postgresql.org
Hi Oleg, It's supposed to show roughly where everyone is. Based mostly on Vince's map from the developer site, but this one is really easy to update. If you're not located on the map correctly (probably hard to tell, but if you're wrong on Vince's map then you're wrong on this one) it can be updated pronto. :) Regards and best wishes, Justin Clift Oleg Bartunov wrote: Justin, what does world map with fuzzy points supposed to show ? Oleg On Wed, 2 Oct 2002, Justin Clift wrote: Hi all, Over the last few weeks we've put together a new Advocacy and Marketing website for PostgreSQL: http://advocacy.postgresql.org It's now ready for public release. It has the first few case studies, lists the major advantages to PostgreSQL, and provides a place you can point your CIO, CTO, and CEO's at, etc. :-) Regards and best wishes, Justin Clift Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Anyone want to assist with the translation of the Advocacy
Hi Michael, Michael Paesold wrote: snip Hi Justin, I am from Austria, and I would like to help. I could provide a German translation. The Babelfish's translation is really funny. Machine translation is readable, but it is no advocacy. ;-) I do not really nead an interface, but just tell me in what way you want the texts. Cool. Could you deal with an OpenOffice Calc or M$ Excel file having the lines of English text in one column, and doing the German translation into a second column? That might be easiest, and will allow a cut-n-paste of the German version straight into the database backend. Sound workable to you? :-) Regards and best wishes, Justin Clift Best Regards, Michael Paesold -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[HACKERS] Anyone want to assist with the translation of the Advocacy site?
Hi everyone, Have just put together a prototype page to show off the multi-lingual capabilities that the Advocacy sites' infrastructure has: http://advocacy.postgresql.org/?lang=de The text was translated to german via Altavista's Babelfish, so it's probably only about 80% accurate, but it conveys the concept. Is anyone interested in translating the English version to other languages? All Latin based languages should be fine (German, French, Italian, Spanish, Portuguese, Turkish, Greek, etc). If there's strong interest, then an interface to let volunteers translators do it easily can be constructed over the next fortnight or so. :-) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[HACKERS] New PostgreSQL Website : advocacy.postgresql.org
Hi all, Over the last few weeks we've put together a new Advocacy and Marketing website for PostgreSQL: http://advocacy.postgresql.org It's now ready for public release. It has the first few case studies, lists the major advantages to PostgreSQL, and provides a place you can point your CIO, CTO, and CEO's at, etc. :-) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Cause of missing pg_clog files
Bruce Momjian wrote: OK, we need a decision on whether we are going to do a 7.2,3 or just have it in beta3. If it is in 7.2.3, I would not mention it in the beta3 release notes. We definitely should have a 7.2.3. If we can release a 7.2.2 to fix bugs and a security flaw, then we should definitely have a 7.2.3 to ensure the usability of the 7.2.x series. Some places will still be using 7.2.x for 2 years to come, just because 7.2.x was what their projects started developing against, etc. :-) Regards and best wishes, Justin Clift --- Tom Lane wrote: Yesterday I reported a WAL problem that could lead to tuples not being marked as committed-good or committed-dead after we'd already removed the pg_clog segment that had their transaction's commit status. I wasn't completely satisfied with that, though, because on further reflection it seemed a very low-probability mechanism. I kept digging, and finally came to the kind of bug that qualifies as a big DOH :-( If you run a database-wide VACUUM (one with no specific target table mentioned) as a non-superuser, then the VACUUM doesn't process tables that don't belong to you. But it will advance pg_database.datvacuumxid anyway, which means that pg_clog could be truncated while old transaction references still remain unmarked in those other tables. In words of one syllable: running VACUUM as a non-superuser can cause irrecoverable data loss in any 7.2.* release. I think this qualifies as a must fix bug. I recommend we back-patch a fix for this into the REL7_2 branch and put out a 7.2.3 release. We should also fix the can't wait without a PROC bug that was solved a few days ago. regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: 7.2.3 fixes (was Re: [HACKERS] Cause of missing pg_clog files)
Tom Lane wrote: snip Any votes on whether to fix that or leave it alone in 7.2.3? I need some input in the next few hours ... Including it sounds like a good idea. 'Yes' from me. :) Regards and best wishes, Justin Clift regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] pg_config : postgresql.conf adjustments?
Peter Eisentraut wrote: Justin Clift writes: Would it be beneficial for us to extend pg_config to update the postgresql.conf file? That has nothing to do with pg_config's functions. At present, sure. Was thinking a tool for command line changes of postgresql.conf parameters would be useful, then thought about what such a tool would be named. pg_cfg was a thought, as was pg_config. However we already have a pg_config. At present it's purpose is in the realm of reporting the installation configuration of PostgreSQL. Was thinking that adding the ability to do more than report stuff, but also to make changes isn't that bad an idea. ? Regards and best wishes, Justin Clift -- Peter Eisentraut [EMAIL PROTECTED] -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])