[HACKERS] Re: [COMMITTERS] pgsql: Properly set relpersistence for fake relcache entries.
Hi, Does this mean we need to wrap new tarballs soon, because of the data loss bug? Regards, Devrim 14 Eylül 2012, Cuma, 4:42 pm tarihinde, Robert Haas yazmış: Properly set relpersistence for fake relcache entries. This can result in buffers failing to be properly flushed at checkpoint time, leading to data loss. Report, diagnosis, and patch by Jeff Davis. Branch -- REL9_1_STABLE Details --- http://git.postgresql.org/pg/commitdiff/fef2c17807e095a04441e4f1fe05f75d5578ead2 Modified Files -- src/backend/access/transam/xlogutils.c |5 + src/backend/storage/buffer/bufmgr.c|2 ++ 2 files changed, 7 insertions(+), 0 deletions(-) -- Sent via pgsql-committers mailing list (pgsql-committ...@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers -- Temporarily using a webmail program. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: ANNOUNCE list (was Re: [HACKERS] New PGXN Extension site)
I don't moderate -announce. -- Devrim GÜNDÜZ PostgreSQL DBA @ Akinon/Markafoni, Red Hat Certified Engineer devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz 17.Haz.2010 tarihinde 00:58 saatinde, Joshua D. Drake j...@commandprompt.com şunları yazdı: On Wed, 2010-06-16 at 10:34 -0700, Josh Berkus wrote: Why is there significant delay on important posts, yet some posts go almost straight though? Every time I use Announce my posts are delayed for about 4-5 days. Why do some posts jump the queue, appearing to imply the moderator is being selective in releasing some, yet not others? Do we need some more moderators? Yes. Currently the only moderators for -announce are Marc and Greg S-M. And me, and devrim and a number of others. Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [GENERAL] [HACKERS] urgent: upgraded to 8.2, getting kernel panics
Hi, On Mon, 2007-02-26 at 08:24 -0500, Merlin Moncure wrote: we tried update to the latest via yum update with no help. As Tom stated, FC4 is no more supported; therefore you won't be able to get newer kernel via yum. as promised, here is the best photo of the panic we could get: http://img144.imageshack.us/my.php?image=dumpic6.jpg ...bad locking... The picture reminded me a SCSI driver bug in older kernels -- I google'd again now and I saw a post that says native drivers are being used in FC5+ kernels. If this is the real case, you may hit the problem sometime later. Upgrading OS will probably solve your problem; since there is no way to upgrade FC4 kernel unless you want to compile kernel source on your system. Regards, -- Devrim GÜNDÜZ PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part
Re: [HACKERS] [GENERAL] urgent: upgraded to 8.2, getting kernel panics
On Fri, 2007-02-23 at 17:14 -0500, Merlin Moncure wrote: BUG: spinlock recursion CPU0 postmaster...not tainted. snip Has anybody seen any problem like this or have any suggestions about possible resolution...should I be posting to the LKML? AFAIR (+ some quick Googling), this is related to a problem in kernel. You may need to update to a newer Fedora release since FC4 is not supported anymore :(. Even if you report to LKML, they will probably suggest you using a newer kernel. However, I think system will not let you compile a new kernel and panic again during a high load... So... If you have a free space, install a newer Fedora release on this system, mount the existing $PGDATA and try if this fixes the problem... -- Devrim GÜNDÜZ PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part
[HACKERS] [Fwd: [COMMITTERS] pgsql: Fix for early log messages during postmaster startup getting lost]
Hi, It is very good to see Magnus among committers. Congrats Magnus! Cheers, Devrim Forwarded Message From: Magnus Hagander [EMAIL PROTECTED] To: pgsql-committers@postgresql.org Subject: [COMMITTERS] pgsql: Fix for early log messages during postmaster startup getting lost Date: Sun, 11 Feb 2007 07:59:26 -0400 (AST) Log Message: --- Fix for early log messages during postmaster startup getting lost when running as a service on Win32. Per report from Harald Armin Massa. Modified Files: -- pgsql/src/backend/postmaster: postmaster.c (r1.519 - r1.520) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/postmaster/postmaster.c.diff?r1=1.519r2=1.520) pgsql/src/backend/utils/error: elog.c (r1.181 - r1.182) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/error/elog.c.diff?r1=1.181r2=1.182) ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings -- Devrim GÜNDÜZ PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part
Re: [HACKERS] PostgreSQL 8.2 : regression failures on IA-64
Hi, On Tue, 2006-12-12 at 19:57 +0900, Tatsuhito Kasahara wrote: I think this was caused by a description mistake of postgresql-test.patch. Yeah, I just figured that while I was looking at what Tom did for FC-7 RPMs. I committed the new patch to CVS. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part
Re: [HACKERS] Giving up multiple postmaster + RPM issue
Hi, On Sun, 2006-11-12 at 01:27 -0800, Paul Lindner wrote: Everything goes into /usr/local/pg7.4 and /usr/local/pg8.1, init scripts are /etc/init.d/postgres8.1, /etc/init.d/postgres7.4 /usr/local is not the right place for a database server, per Linux FSH. spec file(s) available on request. I'll be happy if you send me the spec. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part
Re: [HACKERS] [pgsql-www] PGFoundry down?
Hi, On Sat, 2006-10-28 at 01:27 -0400, Jonah H. Harris wrote: PGFoundry is responding with: PgFoundry Could Not Connect to Database: Marc is already working on it. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part
Re: [HACKERS] Multiple postmaster + RPM + locale issues
Hi Markus, On Fri, 2006-10-20 at 15:19 +0200, Markus Schaber wrote: Did you look at how the debian guys handle this? No, but I believe what Peter wrote two days before was a solution of Debian guys. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part
Re: [HACKERS] Multiple postmaster + RPM + locale issues
Hi Peter, On Fri, 2006-10-20 at 15:37 +0200, Peter Eisentraut wrote: Did you look at how the debian guys handle this? [EMAIL PROTECTED]:~$ ls -1 /usr/share/locale/de/LC_MESSAGES/p* snip Quick question: Could you please point me a way to change the names of .mo files and make each PostgreSQL release see its own locale directory? Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part
Re: [HACKERS] Multiple postmaster + RPM + locale issues
Hi Alvaro, On Fri, 2006-10-20 at 10:53 -0300, Alvaro Herrera wrote: The package files are here: http://packages.debian.org/unstable/misc/postgresql-8.1 you can find the patch Debian applies following a link below (the diff.gz), on which you see the method for doing this. Thanks. Let me finish it this weekend. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part
Re: [HACKERS] Multiple postmaster + RPM + locale issues
Hi, On Fri, 2006-10-20 at 10:25 -0400, Tom Lane wrote: Egad. What an ugly, unmaintainable crock. I want to second this. I would not make this in RPM spec file. What about changing localedir='${prefix}/share/locale' line (in configure) to localedir='${prefix}/share/locale/pgsql/$PGMAJORVERSION' or so? Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part
[HACKERS] Multiple postmaster + RPM + locale issues
Hi, I have almost finished working on multiple rpm + postmaster issue today. The spec file and patches in pgsqlrpms cvs work almost as expected and does some preliminary work about multiple postmaster installation issue (we can build the rpms and they are installed correctly). I have a question about locale files. AFAICS, our configure script has hardcoded localedir value: # Note: share/locale is always the default, independent of $datadir localedir='${prefix}/share/locale' However, I think we need to install locale files of each major releases to different directory. I can patch the line above in spec file; however I'm not sure where to install those locale files. The question is: - Is it a good idea to add a new --localedir parameter to configure script so that the localedir will be configurable? - If not, where should I install locale specific files? - ... or should I do something different? Thanks. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part
Re: [HACKERS] New job
Hello, On Mon, 2006-09-11 at 13:11 -0500, Jim C. Nasby wrote: While I'm sitting here in New Jersey in a room with Bruce Momjian (aka Rock Star), I figured now would be a good time to announce my new employment. I'll be doing sales support/engineering from Austin. Congrats Jim. Cheers, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part
Re: [HACKERS] Open items for 8.2
Hello, On Wed, 2006-09-06 at 13:04 +0200, Peter Eisentraut wrote: http://momjian.postgresql.org/cgi-bin/pgopenitems This host seems to be offline. It is suffering from a DNS problem. What about using the wiki? Wiki has the same problem, too. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part
[HACKERS] Status on Fedora Core Extras packaging
Hello, Yesterday night, I was approved (sponsored) for Fedora Core packaging (please note that this is not something financial). For the beginning, I officially submitted python-psycopg2 to FC6. More are on the way; like pgpool, Slony-I, pgadmin3-adminpacks, phpPgAdmin, postgresql_autodoc, pgfouine. Also they are in the queue for FC5. I'm waiting for approval for them. More will be in FC Extras. Please let me know that if you want to see any PostgreSQL related software in the repository. I do have time to package all related stuff. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part
Re: [Pgsqlrpms-hackers] [HACKERS] Safer auto-initdb for RPM init
Hello, On Sat, 2006-08-26 at 19:16 -0400, Andrew Dunstan wrote: Well, in the case of RPMS built with the pgfoundry pgsqlrpms project init script, it looks to me like it is already disabled: see http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgsqlrpms/patches/8.2/postgresql.init?rev=1.2content-type=text/x-cvsweb-markup This is a pre-pre-alpha; and may be reverted in stable release. I'm just trying to find a better way for initdb troubles. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part
Re: [HACKERS] New beginings
Hello, On Mon, 2006-08-14 at 21:09 -0700, Darcy Buskermolen wrote: It is with great enthuasim I announce that I have accepted an offer from Joshua D. Drake of Command Prompt Inc, to join his team. As former Vice President of Software Development with Wavefire Technologies Corp, I endeavor to leverage over 10 years of technical expertise and 8 years of PostgreSQL background within my new team. Rest assured that I will continue my role within the Slony development group to bring additional features, robustness and usability to the project. It is really good to see you in Command Prompt. Welcome, and congrats. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part
Re: [HACKERS] new job
Hello Andrew, On Wed, 2006-08-09 at 12:25 -0400, Andrew Dunstan wrote: On August 1st I started work for Anchorage Capital LLC as a Senior Software Engineer. Congratulations for your new job. Cheers, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ signature.asc Description: This is a digitally signed message part
RPM packaging (was :Re: [HACKERS] Three weeks left until feature freeze)
Hi, On Thu, 2006-07-13 at 15:33 -0400, Chris Browne wrote: If we have an interestingly large set of packages at pgFoundry that are that RPMable, then they *will* come. Personally I am interested in building all RPMable PostgreSQL related projects. Currently I do packaging for PostgreSQL, pgadmin3, Slony-I, PostGIS, libpqxx, dbi-link, plphp, postgresql_autodoc, psycopg. I know that some projects at pgfoundry build their own RPM packages. If any of the maintainers need help in RPM packaging, please let me know. I'm pretty sure that our RPM packagers at pgsqlrpms project will help us, too. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ ---(end of broadcast)--- TIP 1: 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: Anyone still care about Cygwin? (was Re: [HACKERS] [CORE] GPL
Hi, On Mon, 2006-06-26 at 08:28 +0100, Dave Page wrote: Devrim was working with another potential contributor though, dunno how that's going. Ok, I talked with them now. They need the following information: - What type of hardware do we need? Is an Opteron enough? Memory? Disk? - Do we need a private box, or is a VM enough? - What is the average traffic of our web servers? Bandwith is not cheap in Turkey, so they are inclined to put that server somewhere outside Turkey. They are ready to proceed, they just want to learn the details. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] plperl's ppport.h out of date?
Hi, On Tue, 2006-05-30 at 08:29 -0400, Tom Lane wrote: ppport.h is throwing warnings when compiling on Fedora Core 5 (with perl-5.8.8-4). I gather from the comments in the head of that file that we ought to look for a newer version. I've informed Andrew about this, he sent me a patch a few days before, but I could not have time to test it. Let me test it soon. -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [HACKERS] anoncvs still slow
Hi, On Sun, 2006-05-28 at 21:25 +0200, Magnus Hagander wrote: For bittorrent, I propose we take it out. We've suggested it before, I don't recall receiving any real requests to keep it, and IMHO it's way much more pain than it's worth. Therefor, unless someone objects, I'll pull the bittorrent links from the website in a couple of days, and then we can just remove it from the server. Please go for it. -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ ---(end of broadcast)--- TIP 1: 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] Time for new releases?
Hi, It's been quite a long time since the latest dot releases. Do you think it is time for the new releases? There are several bugfixes since then. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/ ---(end of broadcast)--- TIP 1: 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] RH9 postgresql 8.0.7 rpm
Hi Gaetano, On Tue, 2006-04-11 at 18:31 +0200, Gaetano Mendola wrote: I'm trying to build the rpms for RH9, I downloaded the srpm for RH9 but I'm stuck on these errors: Attempt a: # rpmbuild --rebuild postgresql-8.0.7-1PGDG.src.rpm Installing postgresql-8.0.7-1PGDG.src.rpm error: Failed build dependencies: tcl-devel is needed by postgresql-8.0.7-1PGDG why tcl-devel on rh9 version? tcl-devel doesn't exist on rh9 ) We use only one spec file for all platforms. If you are using Red Hat 9, you should consider using the macros that are enabled for RH9 (build89 and/or build9 in the spec file). Attempt b: # rpmbuild --nodeps --rebuild postgresql-8.0.7-1PGDG.src.rpm checking krb5.h presence... no checking for krb5.h... no configure: error: header file krb5.h is required for Kerberos 5 error: Bad exit status from /var/tmp/rpm-tmp.73067 (%build) I think rebuilding with --define 'buildrhel3 1' will work here. ok no kerberos now: Attempt c: # rpmbuild --nodeps --rebuild --define 'kerberos 0' postgresql-8.0.7-1PGDG.src.rpm . checking for zlib.h... yes checking openssl/ssl.h usability... no checking openssl/ssl.h presence... no checking for openssl/ssl.h... no configure: error: header file openssl/ssl.h is required for OpenSSL error: Bad exit status from /var/tmp/rpm-tmp.3109 (%build) actually I have that file: # locate openssl/ssl.h /usr/include/openssl/ssl.h I have no idea about this and I can't remember right now how I was building RH9 RPMs ... If you provide me a RH9 box, I can help you. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/ ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [HACKERS] I have changed employers
Hi, On Tue, 2006-04-04 at 20:06 -0400, Bruce Momjian wrote: FYI, I have left SRA and am now working for EnterpriseDB: Congratulations Bruce! It is good to see many community members working in PostgreSQL-related companies. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/ ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] Some employment changes ...
Hi Josh, On Sat, 2006-03-25 at 12:01 -0800, Josh Berkus wrote: As of Monday I'm at Sun Microsystems. Congrats! -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/ ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [pgsql-advocacy] [HACKERS] PostgreSQL Anniversary Proposals --
Hi, On Sun, 2006-03-19 at 11:34 -0800, Josh Berkus wrote: Well, aside from anything else, we seem likely to have you, Devrim, Magnus and maybe even Robert Treat there (Robert?). Which would mean a good time for a meeting of the Web Team, yes? It seems that I'll be there, and yes, a PostgreSQL.org web development session will be cool. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/ ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] pg_hba.conf alternative
Hi, On Wed, 2006-02-08 at 14:34 +0200, Q Beukes wrote: I have the problem where the system administrators at our company obviously have access to the whole filesystem, and our database records needs to be hidden even from them. As they have access to whole filesystem, they can access anything, even if you enable password auth (they'd switch to trust auth and reload postmaster). They can also copy the data dir to another server and search the You should either trust your sysadms, or work with people who you trust. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] Upcoming re-releases
Hi, On Wed, 2006-02-08 at 11:28 -0500, Stephen Frost wrote: I'd really like to see the multiple DB connections with different Kerberos credentials go in to 8.1.3. It solved the problem we were having authenticating to PostgreSQL using Kerberos from Apache. We were also able to get phppgadmin to use Kerberos authentication with this patch (which is very nice). That patch also went into the 8.1.2-2 release of the Debian packages [OT] So Debian has a patch that is not in 8.1.2? I can't believe that they are doing that -- personally I'm against to add any patch into binaries that is not in the core. [/OT] Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[HACKERS] About PgPool Global Development Group
Hi, PgPool team is about to form PgPool Global Development Group whose concept is pretty similar to PostgreSQL Global Development Group. i.e. a virtual entity on the Internet. PgPool is currently being developed by Tatsuo Ishii. We want to switch to PgPool Global Development Group which will lower the barrier for hackers who wants to join this project. As of release 3.0.0, PgPool will be copyrighted to PgPool Global Development Group. Please join to pgpool-hackers list: http://pgfoundry.org/mailman/listinfo/pgpool-hackers We are looking forward for more people involved in this project. Regards, PgPool Global Development Group -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] New project launched : PostgreSQL GUI Installer for
Hi, On Mon, 2006-01-30 at 20:41 -0800, Jeffrey W. Baker wrote: How will you do an orderly upgrade from one revision to the next, including all the dependencies? We are still in planning phase, any ideas of how to do that is welcome. How will you distribute security updates? We are still in planning phase, any ideas of how to do that is welcome. I predict this form of installation will cause a great many support headaches as users report problems which are caused by oddball compilers, strange CFLAGS, unreleased or strangely patched versions of shared libraries and headers, and so forth. I can't see a problem in here. We already have platform test results in pgbuildfarm and we have the knowledbase about the configure options, flags etc. in that platforms. Obviously anybody is welcome and able to just write whatever software they feel is needed, but go ahead and count me among the skeptics. The world is not turning around us, and please don't be skeptic on a piece of software that you won't use but some people will. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [HACKERS] New project launched : PostgreSQL GUI Installer for
Hi, On Mon, 2006-01-30 at 19:35 -0800, Christopher Browne wrote: We are actively looking for developers for the project. Please drop me an e-mail if you want to join this project. We will use Python, so you need to be a Python guy to join the project. We are in planning phase, if you join us earlier, we will be able to share more ideas. You'd better define the purpose pretty clearly, as I don't see any purpose that's of value, yet. I agree with Joshua's points here. Think of people who do not want an installation via command line. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [HACKERS] New project launched : PostgreSQL GUI Installer for
Hi, On Tue, 2006-01-31 at 09:15 +, Dave Page wrote: As was said, a gui to produce postgresql.conf files (off host) can be of value. pgAdmin? Installer should produce a postgresql.conf, based on some selections via the interface. Then we will use pgAdmin to edit, improve, etc. postgresql.conf. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [HACKERS] New project launched : PostgreSQL GUI Installer for
Hi, On Tue, 2006-01-31 at 08:34 +0100, Tino Wildenhain wrote: http://pgfoundry.org/projects/pgnixinstaller/ We are actively looking for developers for the project. Please drop me an e-mail if you want to join this project. We will use Python, so you need to be a Python guy to join the project. We are in planning phase, if you join us earlier, we will be able to share more ideas. Might be fun of course. But on unix you usually have some kind of package system anyway - how is the installer supposed to play nicely with them? Yes, We will try to stick the file locations of those package managers. We already have that KB. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] [GENERAL] New project launched : PostgreSQL GUI Installer for
Hi, On Tue, 2006-01-31 at 08:36 +0100, Tino Wildenhain wrote: Are you going to work with the underlying system's package manager, or put everything in /usr/local? We'll work with the package manager -- I'm an RPM guy ;) RPM isnt the only packaging system out there ;) I used RPM as an alias to package managers :) Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ ---(end of broadcast)--- TIP 1: 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 project launched : PostgreSQL GUI
Hi, On Mon, 2006-01-30 at 22:45 -0500, Vivek Khera wrote: However none of them are PostgreSQL Installers, none of them has the ability to customize the packages and none of them has the ability to install the community packages, etc. :) You need to take a sniff over at the FreeBSD ports. Lets you build customized install of Pg quite easily, without need for a gui, which none of my big servers have. There are some people who do use GUI on their servers and do not know how to compile a software or do not want to build a software via command line. This is called marketing. :) Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ ---(end of broadcast)--- TIP 1: 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] New project launched : PostgreSQL GUI
Hi, On Mon, 2006-01-30 at 21:27 -0500, Jonah H. Harris wrote: I had to deal with an installer written in python and several in Java... IMHO, Java would be a better language for this and you could build off some nice OSS installers that already exist (such as IzPack). Just my 2 cents :) Bundling Java is a pain, so we'd better stay away from that. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[HACKERS] New project launched : PostgreSQL GUI Installer for Linux/Unix systems
Hi, As you know, many databases that run on Linux / Unix systems have a GUI installer which make installation easier and more attractive for some people. Our Windows Installer is very attractive, for example. Now, I and Burcu Guzel, who is a Senior Programmer, decided to launch a new project: pgnixinstaller : http://pgfoundry.org/projects/pgnixinstaller/ We are actively looking for developers for the project. Please drop me an e-mail if you want to join this project. We will use Python, so you need to be a Python guy to join the project. We are in planning phase, if you join us earlier, we will be able to share more ideas. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] [GENERAL] New project launched : PostgreSQL GUI Installer for
Hi, On Mon, 2006-01-30 at 20:03 -0500, Doug McNaught wrote: We are actively looking for developers for the project. Please drop me an e-mail if you want to join this project. We will use Python, so you need to be a Python guy to join the project. We are in planning phase, if you join us earlier, we will be able to share more ideas. What value does this bring to systems that have a good package system and up-to-date repositories? I can install Postgres today on Ubuntu using a GUI tool, and install another GUI tool to configure and adminsiter it. You can install, but what if you need different configure options than the package provides? This means a rebuild of the package. Instead, we will build and install that package via the installer. OTOH, exluding Synaptic that I hate to use, FC / RH does not have a GUI RPM interface for the repositories. So our installer will help them a lot. Also, our installer will have an option to download and install the prebuilt binaries from PostgreSQL FTP site (and possible other sites) For systems like Solaris I can see it maybe being a win. Agreed. Are you going to work with the underlying system's package manager, or put everything in /usr/local? We'll work with the package manager -- I'm an RPM guy ;) Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] [GENERAL] New project launched : PostgreSQL GUI
Hi, On Mon, 2006-01-30 at 20:27 -0500, Andrew Dunstan wrote: OTOH, exluding Synaptic that I hate to use, FC / RH does not have a GUI RPM interface for the repositories. So our installer will help them a lot. Also, our installer will have an option to download and install the prebuilt binaries from PostgreSQL FTP site (and possible other sites) There's yumex ... http://fedoranews.org/tchung/yumex/ Thanks for the info. I haven't heard about it before... However none of them are PostgreSQL Installers, none of them has the ability to customize the packages and none of them has the ability to install the community packages, etc. :) Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [HACKERS] [GENERAL] New project launched : PostgreSQL GUI
Hi, On Mon, 2006-01-30 at 20:31 -0500, Doug McNaught wrote: Certainly you can install pre-built binaries without a compiler, and let the user choose database location, autovacuum settings and stuff like that. That's another good point. We can adjust many settings before installing. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] [GENERAL] New project launched : PostgreSQL GUI
Hi, On Mon, 2006-01-30 at 21:34 -0400, Marc G. Fournier wrote: OTOH, exluding Synaptic that I hate to use, FC / RH does not have a GUI RPM interface for the repositories. So our installer will help them a lot. Also, our installer will have an option to download and install the prebuilt binaries from PostgreSQL FTP site (and possible other sites) And pull down/build/install the various extensions on pgFoundry? :) Another good idea. Thanks Marc. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ ---(end of broadcast)--- TIP 1: 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] New project launched : PostgreSQL GUI
Hi, On Mon, 2006-01-30 at 20:31 -0500, Doug McNaught wrote: You can install, but what if you need different configure options than the package provides? This means a rebuild of the package. Instead, we will build and install that package via the installer. That's actually a pretty cool idea--compile and generate debs/rpms that reflect the user's choices, then install them. But the dependency on a compiler adds a twist of complexity--sorry, you need to install the following system packages (gcc, etc) before you can install Postgres as you've configured it. Not horrible, but perhaps intimidating for the GUI crowd? :) Is gcc in the bog-standard default install on FC these days? We can pre-check the prerequisites for building the package and raise an error before beginning to build the package. It is not that hard. For example, RPMs have BuildRequires tags and we can compare those with the packages installed in the system. BTW, gcc is not installed on by default AFAIR. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] [GENERAL] New project launched : PostgreSQL GUI
Hi, On Mon, 2006-01-30 at 22:04 -0400, Marc G. Fournier wrote: BTW, gcc is not installed on by default AFAIR. Wow, how do you update the kernel each week? :) More seriously, I know under FreeBSD, one of the first things that gets done after installing is to customize the kernel to get rid of all the 'cruft' part of the generic kernel, I take it that this isn't something that ppl do with Linux? On systems that have a packaging system, you are supposed to download and install vendor kernels. There is no need to build the kernel. However, if you want to build, then you need to install development environment. On my RHEL boxes, I do never ever recompile the kernel since Red Hat does not provide support if I do so :) Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ ---(end of broadcast)--- TIP 6: explain analyze is your friend
[HACKERS] Adding a --quiet option to initdb
Hi, Attached is a patch which adds --quiet and --q option to initdb. I personally needed this option while writing a document and taking screenshot :) It only shows the error and warning messages, as well as the last lines. I've updated the docs. Regression tests pass. This is my first patch to PostgreSQL source, so please guide me if I have done something wrong. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ Index: doc/src/sgml/ref/initdb.sgml === RCS file: /projects/cvsroot/pgsql/doc/src/sgml/ref/initdb.sgml,v retrieving revision 1.35 diff -c -r1.35 initdb.sgml *** doc/src/sgml/ref/initdb.sgml 21 Jun 2005 04:02:31 - 1.35 --- doc/src/sgml/ref/initdb.sgml 25 Jan 2006 13:47:19 - *** *** 235,240 --- 235,252 /listitem /varlistentry + variablelist + varlistentry + termoption--q/option/term + termoption--quiet/option/term + listitem +para + Supresses the messages generated by commandinitdb/command. Only warning + and error messages are displayed. +/para + /listitem + /varlistentry + varlistentry termoption-L replaceable class=parameterdirectory/replaceable/option/term listitem Index: src/bin/initdb/initdb.c === RCS file: /projects/cvsroot/pgsql/src/bin/initdb/initdb.c,v retrieving revision 1.106 diff -c -r1.106 initdb.c *** src/bin/initdb/initdb.c 5 Jan 2006 10:07:46 - 1.106 --- src/bin/initdb/initdb.c 25 Jan 2006 13:47:36 - *** *** 95,100 --- 95,101 static bool debug = false; static bool noclean = false; static bool show_setting = false; + static bool quiet; /* internal vars */ *** *** 1120,1128 test_max_fsm, ok_buffers = 0; ! ! printf(_(selecting default max_connections ... )); ! fflush(stdout); for (i = 0; i connslen; i++) { --- 1121,1131 test_max_fsm, ok_buffers = 0; ! if (!quiet) ! { ! printf(_(selecting default max_connections ... )); ! fflush(stdout); ! } for (i = 0; i connslen; i++) { *** *** 1150,1159 i = connslen - 1; n_connections = trial_conns[i]; ! printf(%d\n, n_connections); ! printf(_(selecting default shared_buffers/max_fsm_pages ... )); ! fflush(stdout); for (i = 0; i bufslen; i++) { --- 1153,1168 i = connslen - 1; n_connections = trial_conns[i]; ! if (!quiet) ! { ! printf(%d\n, n_connections); ! } ! if (!quiet) ! { ! printf(_(selecting default shared_buffers/max_fsm_pages ... )); ! fflush(stdout); ! } for (i = 0; i bufslen; i++) { *** *** 1181,1187 n_buffers = test_buffs; n_fsm_pages = FSM_FOR_BUFS(n_buffers); ! printf(%d/%d\n, n_buffers, n_fsm_pages); } /* --- 1190,1199 n_buffers = test_buffs; n_fsm_pages = FSM_FOR_BUFS(n_buffers); ! if (!quiet) ! { ! printf(%d/%d\n, n_buffers, n_fsm_pages); ! } } /* *** *** 1194,1202 char repltok[100]; char path[MAXPGPATH]; ! fputs(_(creating configuration files ... ), stdout); ! fflush(stdout); ! /* postgresql.conf */ conflines = readfile(conf_file); --- 1206,1216 char repltok[100]; char path[MAXPGPATH]; ! if (!quiet) ! { ! fputs(_(creating configuration files ... ), stdout); ! fflush(stdout); ! } /* postgresql.conf */ conflines = readfile(conf_file); *** *** 1350,1359 char **bki_lines; char headerline[MAXPGPATH]; ! printf(_(creating template1 database in %s/base/1 ... ), pg_data); ! fflush(stdout); ! if (debug) talkargs = -d 5; bki_lines = readfile(bki_file); --- 1364,1376 char **bki_lines; char headerline[MAXPGPATH]; ! if (!quiet) ! { ! printf(_(creating template1 database in %s/base/1 ... ), pg_data); ! fflush(stdout); ! } ! if (debug) talkargs = -d 5; bki_lines = readfile(bki_file); *** *** 1444,1451 NULL }; ! fputs(_(initializing pg_authid ... ), stdout); ! fflush(stdout); snprintf(cmd, sizeof(cmd), \%s\ %s template1 %s, --- 1461,1471 NULL }; ! if (!quiet) ! { ! fputs(_(initializing pg_authid ... ), stdout); ! fflush(stdout); ! } snprintf(cmd, sizeof(cmd), \%s\ %s template1 %s, *** *** 1572,1579 NULL }; ! fputs(_(enabling unlimited row size for system tables ... ), stdout); ! fflush(stdout); snprintf(cmd, sizeof(cmd), \%s\ %s template1 %s, --- 1592,1602 NULL }; ! if (!quiet) ! { ! fputs(_(enabling unlimited row size
Re: [HACKERS] [PATCHES] Adding a --quiet option to initdb
Hi Andrew, On Wed, 2006-01-25 at 09:28 -0500, Andrew Dunstan wrote: What's wrong with just sending stdout to /dev/null? If that eats error messages too then we should probably fix initdb to send those to stderr. We have the same options with reindexdb, for example. I think a command line option But if we are going to do this, then I also noticed a couple of things: . you should explicitly initialize the quiet variable, in keeping with the style of the others nearby. Oh, I've missed it. Patch updated. . the idiom if (! quiet) { fputs(_(some message),stdout); fflush(stdout); } should not be endlessly repeated. Make it a macro or a function. I'm looking at it now. Thanks for your comments. I'll provide a new patch soon, which will also include Alvaro's suggestion about surpression both header and footer (--make-initdb-really-quiet-mode :) ) Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] [PATCHES] Adding a --quiet option to initdb
Hi, On Wed, 2006-01-25 at 17:22 +0200, Devrim GUNDUZ wrote: On Wed, 2006-01-25 at 09:28 -0500, Andrew Dunstan wrote: What's wrong with just sending stdout to /dev/null? If that eats error messages too then we should probably fix initdb to send those to stderr. We have the same options with reindexdb, for example. I think a command line option (Opps...) We have the same options with reindexdb, for example. I think a command line options is better and required. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [HACKERS] Adding a --quiet option to initdb
Hi, On Wed, 2006-01-25 at 11:28 -0500, Tom Lane wrote: Devrim GUNDUZ [EMAIL PROTECTED] writes: Attached is a patch which adds --quiet and --q option to initdb. Why is this a good idea? I was playing with 8.2 RPM init script and thought that instead of directing the output to /dev/null, it would be better to use a command line option for that. Also, we are designing a new installer project and --quiet might help us. I would rise this idea in -hackers before providing a patch, but since this is my first patch, I thought it would be a good exercise for me. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] [PATCHES] Adding a --quiet option to initdb
Hi, On Wed, 2006-01-25 at 16:32 +0100, Peter Eisentraut wrote: I think a command line options is better and required. I think we need more proof of that than a use case involving taking screen shots. I've just explained my points as a reply to Tom's mail. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ ---(end of broadcast)--- TIP 6: explain analyze is your friend
[HACKERS] Pushing init scripts into contrib/
Hi, PostgreSQL source tree had init scripts in contrib/ years before: http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/linux/?hideattic=0#dirlist I suggest to push the init scripts again into contrib/, for people who don'u use packaged versions and need init scripts. We could supply different scripts for different platforms, like the init scripts of our RPMs, init scripts of Debian, etc. Any objections? Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [HACKERS] Pushing init scripts into contrib/
Hi, On Mon, 26 Dec 2005, Tom Lane wrote: Devrim GUNDUZ [EMAIL PROTECTED] writes: PostgreSQL source tree had init scripts in contrib/ years before: http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/linux/?hideattic=0#dirlist Aren't those dead versions of what's now in contrib/start-scripts/ ? Oh... I haven't seen start-scripts :( Thanks. -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ ---(end of broadcast)--- TIP 6: explain analyze is your friend
[HACKERS] About my new work at Command Prompt Inc.
Hi, I'd like to inform the people who does not read Planet PostgreSQL Command Prompt Inc.has just hired me for my community work I have been doing so far, like PostgreSQL RPM stuff and other PostgreSQL related RPMs, such as Slony-I, pgpool, PostGIS, etc) and website things. That means I'll spend more time on these. Thanks to Joshua. I'm very happy to be a member of CMD. Let's see what else I can do for CMD. Regards -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [HACKERS] MS SQL Server compatibility functions
Hi, On Wed, 23 Nov 2005, Fredrik Olsson wrote: snip I guess I am not the only one moving from MS SQL Server, so is there interest for others to use my work, as a contrib perhaps. And how should I continue from here in that case? I'd start a new project at pgfoundry and then would begin talking about a contrib module. Regards, -- Devrim GUNDUZ Kivi Bilişim Teknolojileri - http://www.kivi.com.tr devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [HACKERS] 8.1 Release Candidate 1 Bundled ...
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Lamar, On Mon, 31 Oct 2005, Lamar Owen wrote: So thinking that: * Beta and RC RPMs are used only by testers * We use the beta and RC steps to build the new RPM sets, so that means that actually they are not production quality looking from the RPM perspective. By way of clarification, as I am the one who wrote that portion of the spec file, an 'RPM prerelease' and a 'beta' weren't intended to be the same thing; the line in the spec referenced was for my own use to remind me that my own internal testing packages (with a release number 0.x) weren't intended for public consumption. Devrim, you can remove that section of the spec file at any time at this point, because you are using CVS for the purpose that I was using 'prerelease' RPMs. Ok, I've removed that part from the spec files. Historically, beta and release candidate RPM's were put on the main ftp site but flagged as beta quality. I certainly appreciate your dilligence in following those instructions I wrote long ago, but, thanks to your smoother release process (in no small part due to the use of CVS) those instructions are obsolete. Many thanks for being that dilligent! :) Ok, I will be putting the beta and RC RPMs to FTP site from now on. Regards, - -- Devrim GUNDUZ Kivi Bilişim Teknolojileri - http://www.kivi.com.tr devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (GNU/Linux) iD8DBQFDZ9Is4zE8DGqpiZARAku+AJ90HZHQNUeLQ+a7zy7ge2hFvNpLegCgqD0U 2yf2pDfmsSGrZZDBWBf7yZU= =Wxyt -END PGP SIGNATURE- ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [HACKERS] 8.1 Release Candidate 1 Bundled ...
Hi, On Sun, 30 Oct 2005, Marc G. Fournier wrote: Take a look through it, will announce this evening ... Could you please include RPMs in your announcement? They *will* be here: http://developer.postgresql.org/~devrim/rpms/8.1/rc1 Regards, -- Devrim GUNDUZ Kivi Bilişim Teknolojileri - http://www.kivi.com.tr devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] 8.1 Release Candidate 1 Bundled ...
Hi, On Sun, 30 Oct 2005, Magnus Hagander wrote: http://developer.postgresql.org/~devrim/rpms/8.1/rc1 The developer.postgresql.org machine really isn't geared to handle downloads.. Any reason you can't just stick it on the standard ftp sites and have it mirrored along with everything else? This is taken from our spec: # Pre-release RPM's should not be put up on the public ftp.postgresql.org server # -- only test releases or full releases should be. So thinking that: * Beta and RC RPMs are used only by testers * We use the beta and RC steps to build the new RPM sets, so that means that actually they are not production quality looking from the RPM perspective. That's why I put them to developer site. Another reason was that gunduz.org was unavailable for 2 months (and putting the PGDG RPMs to my site does not sound good). Regards, -- Devrim GUNDUZ Kivi Bilişim Teknolojileri - http://www.kivi.com.tr devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org ---(end of broadcast)--- TIP 6: explain analyze is your friend
[HACKERS] Update for supported platforms list
Hi, All regression tests passed on : * SUSE LINUX 10.0 (i586) OSS * Fedora Core release 4 * Red Hat Linux release 9 * Red Hat Enterprise Linux ES release 3 (Taroon Update 6) Both are x86. Regards, -- Devrim GUNDUZ Kivi Bilişim Teknolojileri - http://www.kivi.com.tr devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] 8.04 and RedHat/CentOS init script issue
Hi, On Tue, 18 Oct 2005, Tony Caduto wrote: I installed 8.04 via RPM on Centos 4.2 which is the same as RedHat 4.2 and while booting the init script reports that the daemon [FAILED], but after I logon it shows the postmaster running and I am able to connect from any client remotely. I made not modifcations to the script and there is nothing out of the ordinary in the log. Hmm. In 8.0.4 RPM init scripts, we were using a 1 second of sleep time (see sleep 1 line in the init script). On some cases where the system is slow, you are prompted about the startup failure; however this is not the real case. In 8.1 RPMs, the sleep time was increased to 2 seconds; which we believe that won't have the problem you've reported: http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgsqlrpms/patches/8.1/postgresql.init?rev=1.2content-type=text/x-cvsweb-markup So please increase this sleep time and give another try. Regards, -- Devrim GUNDUZ Kivi Bilişim Teknolojileri - http://www.kivi.com.tr devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Slony RPM issue
Hi, On Thu, 6 Oct 2005, Philip Yarra wrote: On Thu, 6 Oct 2005 12:32 am, Devrim GUNDUZ wrote: Thanks for the report. It will fixed in CVS and all the RPM sets later today. Always feel free to send me a patch if you want, I can apply your patch, too. OK, you got my previous email about why pgsql-libs was dependent on compat-libs RPM? See: http://people.planetpostgresql.org/devrim/index.php?/archives/15-New-PostgreSQL-point-releases.html New 8.0.4 RPMs will solve that problem. Cheers, -- Devrim GUNDUZ Kivi Bilişim Teknolojileri - http://www.kivi.com.tr devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Slony RPM issue
Hi, On Wed, 5 Oct 2005, Philip Yarra wrote: Hi Devrim, I ran into another RPM issue, this time with Slony. :-) I grabbed the RPM from http://developer.postgresql.org/~devrim/slony/1.1.0/rpms/PG8.0.3/ Trying to run slon_start, I got errors such as: $ slon_start --config /etc/slon_tools.conf 2 Invoke slon for node 2 - @@@/slon -s 1000 -d2 -g 80 replication 'host=dev2 dbname=booktown user=postgres port=5432' 21 /var/log/slony/slony1/node2/booktown-2005-10-05_16:23:53.log sh: line 1: @@@/slon: No such file or directory Slon failed to start for cluster replication, node node2 This turned out to be because /usr/lib/pgsql/slon-tools.pm contained several un-expanded @@PGBINDIR@@ prefixes - once I replaced them with /usr/bin it all ran just fine. Hrrm. It seems that I've installed wrong file in the spec :( However slon-tools file is not updated by the Makefile, so I'll try to fix that, too. Thanks for the report. It will fixed in CVS and all the RPM sets later today. Always feel free to send me a patch if you want, I can apply your patch, too. BTW, could you please report the possible Slony problems to slony1-general@gborg.postgresql.org later? Regards, -- Devrim GUNDUZ Kivi Bilişim Teknolojileri - http://www.kivi.com.tr devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [HACKERS] RPMs for RedHat ES3.0
Hi, On Mon, 3 Oct 2005, Philip Yarra wrote: Devrim, I had some problems installing on RedHat ES3.0 with the RPMs. This issue turned out to be that I needed the compat libs to provide the old libs before I could install the new libs. I found a link to http://developer.PostgreSQL.org/~devrim/compat-postgresql-libs-3-3PGDG.i686.rpm in an archived post from -hackers. It wasn't all that obvious what was required though, so is it possible that this RPM could actually be put with the downloads for the main RPMs? I'm not sure anyone's installation would succeed without that RPM on RedHat ES3.0. Please let me know if I'm missing something. We haven't discussed it before, but I think we can't put the RPM among PGDG RPMs. The main reason is that this is not a piece of software that's included within that release of PostgreSQL. Also, this compat RPM is not needed if you don't have a software that needs that RPM. As an aside: is it possible to actually to just include the contents of compat-libs in postgresql-libs, since they actually seem to be required? It'd save me some hassles for future installations. Probably other folks too. As I wrote above, it does not seem possible. Also remember that this will be probably 'solved' in RHEL 5 (and FC 5), so merging compat with main libs package is not a good idea. Regards, -- Devrim GUNDUZ Kivi Bilişim Teknolojileri - http://www.kivi.com.tr devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] State of support for back PG branches
Hi, On Mon, 26 Sep 2005, Tom Lane wrote: snipped This brings up the question of whether we should officially abandon support for 7.2 and/or later branches. I don't think anyone is planning on supporting old branches forever, but when do we stop? I have a corporate need to keep supporting 7.3, at least to the extent of critical bug fixes, because Red Hat is still on the hook to support that version in RHEL3 for awhile longer. I have no such interest in 7.2 (which is one reason I'm not excited about doing the extra work to back-patch the VACUUM/ctid fix). I can definitely see that the community might not want to expend more effort on 7.3, though. I have no idea what the needs of other distributions might be. Doesn't Red Hat support RHEL 2.1, and so that PostgreSQL 7.1? Anyway, IMHO PGDG should stop supporting 7.2 when 8.1 will be officially released. But at this point, (recalling the vacuum bug) it may now be time to abandon supporting 7.2. Also, as the RPM maintainer of PGDG, it is hard to support 7.2 for us, too. Compiling 7.2 on newer platforms becomes a pain... There are some 7.3 users around (I remember some on Slony lists, etc), therefore we should keep supporting it. But maybe we can announce that 7.3 will become unsupported after XXX time so that people will know before we abandon the support. The best time for not supporting 7.3 might be when 8.2 will be released. However, I believe that 7.4 should live longer, since that's the last of the 7.X branch. Regards, -- Devrim GUNDUZ Kivi Bilişim Teknolojileri - http://www.kivi.com.tr devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] New dot releases
Hi, On Fri, 16 Sep 2005, Michael Fuhr wrote: On Fri, Sep 16, 2005 at 09:28:39AM -0600, Michael Fuhr wrote: FWIW, I have a Solaris 9/sparc box with gcc 3.4.2 (same setup as gerbil) and have no problems with REL7_2_STABLE through HEAD. I'll test REL8_0_STABLE with gerbil's configure options when I get a chance. I just built REL8_0_STABLE with the following configure options (same as gerbil): ./configure --enable-cassert --enable-debug --enable-nls \ --enable-integer-datetimes --with-perl --with-python \ --with-openssl --with-pgport=5682 gmake check returned the following: == All 96 tests passed. == So no need to hold the new dot releases? :) I want to work on new RPM sets and don't want to apply countless patches... :) Regards, -- Devrim GUNDUZ Kivi Bilişim Teknolojileri - http://www.kivi.com.tr devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[HACKERS] New dot releases
Hi, After / before 8.1 Beta 2, are there any plans to release new dot releases for the back branches? Regards, -- Devrim GUNDUZ Kivi Bilişim Teknolojileri - http://www.kivi.com.tr devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [HACKERS] problems installing pgsql
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Tue, 30 Aug 2005, Ricardo Gamero wrote: Hello everybody! I'm so sorry to post this simple question but I don't know what to do, the thing is I need to install postgresql 8.0.3 in red hat 9 but when I try to do it this errors appear: [EMAIL PROTECTED] root]# rpm -ivh postgresql-server-8.0.3-1PGDG.i686.rpm warning: postgresql-server-8.0.3-1PGDG.i686.rpm: V3 DSA signature: NOKEY, key ID 748f7d0e error: Failed dependencies: libcrypto.so.4 is needed by postgresql-server-8.0.3-1PGDG libpq.so.4 is needed by postgresql-server-8.0.3-1PGDG libssl.so.4 is needed by postgresql-server-8.0.3-1PGDG First of all, please install this RPM to solve these 3 dependencies: http://developer.postgresql.org/~devrim/rpms/compat/compat-postgresql-libs-3-3PGDG.i686.rpm postgresql = 8.0.3 is needed by postgresql-server-8.0.3-1PGDG Yes, before installing -server rpm, you have to install main package. postgresql 7.4 conflicts with postgresql-server-8.0.3-1PGDG Please follow the usual dump/reload process before upgrading PostgreSQL. Both 7.4 and 8.0 cannot stand on the same server. Regards, - -- Devrim GUNDUZ Kivi Bilişim Teknolojileri - http://www.kivi.com.tr devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFDFcSStl86P3SPfQ4RAj7hAJ4twmxTnd7ikcoeYP4VYtX0UV1vbgCfaV60 Odd04eVW2rhPc9rBBNyxorI= =rJa9 -END PGP SIGNATURE- ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[HACKERS] New dot releases?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, There are many commits to back branches and 8.0 branch since the last dot releases were announced. Any plans for new releases before 8.1beta1? Regards, - -- Devrim GUNDUZ devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.tdmsoft.com.tr http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFC08YJtl86P3SPfQ4RAnv7AKDRWRV1fBx+ngHwEZ8Cd13EhI/zyACfSfp4 5tjG2iZm25DPhOAWnBgblDA= =0ZL5 -END PGP SIGNATURE- ---(end of broadcast)--- TIP 6: explain analyze is your friend
[HACKERS] 7.4.8 compilation failure on Fedora Core 4
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, RPM building for Fedora Core 4 and PostgreSQL 7.4.8 failed with the error below: == make[3]: Leaving directory `/usr/src/redhat/BUILD/postgresql-7.4.8/src/pl/tcl' make[3]: Entering directory `/usr/src/redhat/BUILD/postgresql-7.4.8/src/pl/plper l' gcc -O2 -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -m32 -march=i686 - -mtune=pe ntium4 -fasynchronous-unwind-tables -I/usr/include/et - -fno-strict-aliasing -Wmis sing-declarations, - -Wl,-rpath,/usr/lib/perl5/5.8.6/i386-linux-thread-multi/CORE -fpic -I. - -I/usr/lib/perl5/5.8.6/i386-linux-thread-multi/CORE -I../../../src/in clude -D_GNU_SOURCE -I/usr/include -I/usr/include/et -c -o plperl.o plperl.c cc1: error: unrecognized command line option -Wmissing-declarations, make[3]: *** [plperl.o] Error 1 make[3]: Leaving directory `/usr/src/redhat/BUILD/postgresql-7.4.8/src/pl/plperl ' make[2]: *** [all] Error 2 make[2]: Leaving directory `/usr/src/redhat/BUILD/postgresql-7.4.8/src/pl' make[1]: *** [all] Error 2 make[1]: Leaving directory `/usr/src/redhat/BUILD/postgresql-7.4.8/src' make: *** [all] Error 2 error: Bad exit status from /var/tmp/rpm-tmp.91807 (%build) == Any comments on that? # gcc --version gcc (GCC) 4.0.0 20050519 (Red Hat 4.0.0-8) Regards, - -- Devrim GUNDUZ devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.tdmsoft.com.tr http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFCsqDAtl86P3SPfQ4RAkQXAKDpfwVcgBzlonCfRnvvBMzFlDm/ggCfd7ob xDj58reyKtigN3Wm+4yUpRM= =Ebz3 -END PGP SIGNATURE- ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[HACKERS] Usernames with hyphens
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, AFAIK, PostgreSQL does not allow hyphens in usernames and databases, right? template1=# SELECT version(); version - -- PostgreSQL 8.0.3 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-42) (1 row) template1=# CREATE DATABASE hyphen-test; ERROR: syntax error at or near - at character 22 LINE 1: CREATE DATABASE hyphen-test; ^ This is the same for users; template1=# CREATE USER hyphen-test; ERROR: syntax error at or near - at character 18 LINE 1: CREATE USER hyphen-test; ^ However, createuser allows us to create users that include a hyphen: # createuser hyphen-test -U postgres Shall the new user be allowed to create databases? (y/n) n Shall the new user be allowed to create more new users? (y/n) n Password: CREATE USER but it is not allowed in CREATE DATABASE syntax: template1=# CREATE DATABASE hyphen_test with owner hyphen-test; ERROR: syntax error at or near - at character 46 LINE 1: CREATE DATABASE hyphen_test with owner hyphen-test; template1=# SELECT * from pg_shadow WHERE usename='hyphen-test'; usename | usesysid | usecreatedb | usesuper | usecatupd | passwd | valuntil | useconfig - -+--+-+--+---++--+--- hyphen-test | 103 | f | f| f || | (1 row) Is it a bug in createuser or am I missing a point? Same applies to createdb: # createdb hyphen-test -U postgres Password: CREATE DATABASE Regards, - -- Devrim GUNDUZ devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.tdmsoft.com.tr http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFCrW5dtl86P3SPfQ4RAuF5AJ4xGGqswtNdzcLGi/lNCo8hD5PsYgCggllm u5GYDj/JODlZ5HA+XYD79DM= =pFsg -END PGP SIGNATURE- ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [HACKERS] Usernames with hyphens
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Mon, 13 Jun 2005, Weilguni Mario wrote: In fakt, it allows users with hyphens, but you have to use quotes: CREATE USER foo-bar; DROP USER foo-bar; Yeah quotes. I should have remembered it. Thanks Weilgunu, Dave and Michael. Regards, - -- Devrim GUNDUZ devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.tdmsoft.com.tr http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFCrXLftl86P3SPfQ4RAhCaAKC2xws9QRhsk8zP4U85c1GXRRZfiACfbrSC tUWfWE7Ve3NfBCjEf6n+x8U= =Ds6t -END PGP SIGNATURE- ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [HACKERS] 8.0.x RPM issues
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Gaetano, On Tue, 24 May 2005, Dave Cramer wrote: You can find it here if you need it quickly http://postgresql.gunduz.org/rpms/compat-postgresql-libs-3-1PGDG.i686.rpm Yeah, that package was tested on 5 platforms. Also Dave Cramer confirmed that it works. As soon as we are sure about the package naming, we'll upload it to main FTP repository. Regards, - -- Devrim GUNDUZ devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.tdmsoft.com.tr http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFCk3Aqtl86P3SPfQ4RAhCQAKDJhD6SyUiCDmKcyvzL2MONmLQ7RwCeMugo 7PxIqluAjka5H/mUtMJIuGs= =DA0L -END PGP SIGNATURE- ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] 8.02 rpm error
Hi, -- Original Message --- snip Now, the problem with 8.0.2/8.0.3 is that we forgot to bump the soname before shipping 8.0, so we shipped a bogus libpq.so.3 which is really libpq.so.4, with a wrong soname. How to fix? Maybe we should provide a libpq3 package with the libraries coming from the REL_7_4_STABLE cvs branch. I *was* working on a compatibility RPM this week. However, I'm now on a Linux and Open Source Festival in Turkey and will be able to release the first compat RPM next week. Regards, -- Devrim GUNDUZ devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.tdmsoft.com.tr http://www.gunduz.org ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] 7.3.10 working
Hi, On Wed, 11 May 2005, Robert Treat wrote: has anyone successfully built 7.3.10? I get the following when running make check on a slackware... Except geometry, make check runs fine on RHEL ES 4. -- Devrim GUNDUZ devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.tdmsoft.com.tr http://www.gunduz.org ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[HACKERS] Will new release require an initdb?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, The question is in the subject line: Will the new dot releases require an initdb, since they will play with system catalogs? Regards, - -- Devrim GUNDUZ devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.tdmsoft.com.tr http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFCfeHutl86P3SPfQ4RAr+2AKDuu/WYJOvtDOVUKnOBjCOGhA4PlQCfd3k3 AE8E7mckCUDT0Wb/qPDFmSk= =vpx2 -END PGP SIGNATURE- ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [HACKERS] pg_dump issue : Cannot drop a non-existent(?) trigger
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Sat, 26 Mar 2005, Devrim GUNDUZ wrote: Hmph. Those should be 'i' references to the foreign key constraint, not 'a' references to the relations. I suspect this database was carried forward from an ancient (pre-7.3) dump that defined the triggers by CREATE CONSTRAINT TRIGGER instead of ALTER ADD FOREIGN KEY. I haven't coded the application but AFAIKit was developed using 7.4 and 7.5(CVS); and we installed database on 8.0.1... This is a new app. Ok, sorry for the wrong info. I learned that they had begun coding the app on 7.2, then moved to 7.3-7.4-8.0... You are right. Have you ever run contrib/adddepend to update the definitions to be proper constraints? Ok, running adddepend solved our problem (in fact it produced some erros related to perl but we ran the queries inside psql and fixed the problem). Now we can run pg_dump. Thanks all. Regards, - -- Devrim GUNDUZ devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.tdmsoft.com http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFCRwoItl86P3SPfQ4RApMRAKCv7EZ1yd9UwBMLbLTBgju3pqcBzACfSYqI z2m1MsjhQWzeezM3WNKADgQ= =c3Fv -END PGP SIGNATURE- ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [HACKERS] pg_dump issue : Cannot drop a non-existent(?) trigger
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Fri, 25 Mar 2005, Tom Lane wrote: Does \d pg_trigger show that the tgargs column is of type bytea? Umm no: tgnargs| smallint | not null tgargs, not tgnargs. Ooops, sorry. Ok, tgargs is of type bytea. Also, get the OID for this pg_trigger row and see if it shows up in objid or refobjid of any rows of pg_depend Yes it is there prod=# SELECT * from pg_depend WHERE objid =39053; - -[ RECORD 1 ]-- classid | 16412 objid | 39053 objsubid| 0 refclassid | 1259 refobjid| 37564 refobjsubid | 0 deptype | a - -[ RECORD 2 ]-- classid | 16412 objid | 39053 objsubid| 0 refclassid | 1259 refobjid| 37577 refobjsubid | 0 deptype | a Hmph. Those should be 'i' references to the foreign key constraint, not 'a' references to the relations. I suspect this database was carried forward from an ancient (pre-7.3) dump that defined the triggers by CREATE CONSTRAINT TRIGGER instead of ALTER ADD FOREIGN KEY. I haven't coded the application but AFAIKit was developed using 7.4 and 7.5(CVS); and we installed database on 8.0.1... This is a new app. As a reminder, we ran pg_dump successfully before. After then we did nothing on schemas, we didn't upgrade db server, etc. Have you ever run contrib/adddepend to update the definitions to be proper constraints? Now I did, but the found constraints are not related to our problem... :( I'll try to drop trigger on Monday night and see what will happen. We have no up2date backup, except WAL logs... :( Regards, - -- Devrim GUNDUZ devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.tdmsoft.com http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFCRTYGtl86P3SPfQ4RAjn7AKDrz+t6gsc53EAQ9UZAfAmgpZUwVACg532w 7c61IvIL5e2AjRg+5jV1BVw= =Um2T -END PGP SIGNATURE- ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[HACKERS] pg_dump issue : Cannot drop a non-existent(?) trigger
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I've Google'd for the situation below and could not find any solution. We are using PostgreSQL 8.0.1, installed using PGDG RPMs on RHEL ES 3.0: === prod=# SELECT version(); version - -- PostgreSQL 8.0.1 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-42) === We wanted to take a full backup, so ran pg_dump,but got an error: === $ pg_dump prod -U postgres all.pgdump pg_dump: invalid argument string (firma_moduller_firma_fkey1) for trigger RI_ConstraintTrigger_39053 on table t_firma_moduller === Looking at the details, we saw the trigger there: === prod=# \d t_firma_moduller Table public.t_firma_moduller Column |Type | Modifiers - --+-+-- firma_no | character varying(10) | not null modul_adi| character varying(20) | not null last_update_date | timestamp without time zone | last_update_user | character varying(45) | kod | integer | not null default fn_get_seq_value('t_firma_moduller'::character varying) Indexes: t_firma_moduller_pkey PRIMARY KEY, btree (firma_no, modul_adi) t_firma_moduller_kodu_ukey UNIQUE, btree (kod) Triggers: RI_ConstraintTrigger_39053 AFTER INSERT OR UPDATE ON t_firma_moduller FROM t_firmalar NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins('firma_moduller_firma_fkey1', 't_firma_moduller', 't_firmalar', 'UNSPECIFIED', 'firma_no', 'no') Tablespace: data_ts === However, pgadmin3 can't see that. That is more possible since we can't drop them: prod=# DROP TRIGGER RI_ConstraintTrigger_39053 ON t_firma_moduller; ERROR: trigger ri_constrainttrigger_39053 for table t_firma_moduller does not exist Is this a bug or something? There should not be a trigger there. Regards, - -- Devrim GUNDUZ devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.tdmsoft.com http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFCQ+17tl86P3SPfQ4RAhZKAKCTEzLTizwyt+Zomgv3ikiussyaSQCgtDdD Q3Ua6lJChMT43p2x+bo0rPY= =s4g2 -END PGP SIGNATURE- ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] pg_dump issue : Cannot drop a non-existent(?) trigger
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Fri, 25 Mar 2005, Stephan Szabo wrote: === prod=# \d t_firma_moduller Table public.t_firma_moduller Column |Type | Modifiers - --+-+-- firma_no | character varying(10) | not null modul_adi| character varying(20) | not null last_update_date | timestamp without time zone | last_update_user | character varying(45) | kod | integer | not null default fn_get_seq_value('t_firma_moduller'::character varying) Indexes: t_firma_moduller_pkey PRIMARY KEY, btree (firma_no, modul_adi) t_firma_moduller_kodu_ukey UNIQUE, btree (kod) Triggers: RI_ConstraintTrigger_39053 AFTER INSERT OR UPDATE ON t_firma_moduller FROM t_firmalar NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins('firma_moduller_firma_fkey1', 't_firma_moduller', 't_firmalar', 'UNSPECIFIED', 'firma_no', 'no') Odd, why is this not showing up as a foreign key constraint? Has this database been upgraded (no matter through how many different upgrades) from an old version (7.1 or earlier I think)? No, this is a fresh install. The database went live about 1 month ago. prod=# DROP TRIGGER RI_ConstraintTrigger_39053 ON t_firma_moduller; ERROR: trigger ri_constrainttrigger_39053 for table t_firma_moduller does not exist You'd need to quote the trigger name because it's mixed case. :-( I should have thought it. Thanks. Is this a bug or something? There should not be a trigger there. Well, it really should be showing up as something like: CONSTRAINT firma_moduller_firma_fkey1 FOREIGN KEY (firma_no) REFERENCES t_firmalar(no) The problem is: * We ran pg_dump about 15 days before with no problem. Neither any data nor any relation was dropped since the cluster was initialized. If the trigger was there, how could we run pg_dump successfully? If it isn't there, why does it prevent pg_dump? Regards, - -- Devrim GUNDUZ devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.tdmsoft.com http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFCRCpPtl86P3SPfQ4RAjJCAJ9RuDrfeS78cNlJABvybhori6Cm6ACgtaxr p79z+3ty4SFTDnlaUK+ZdUM= =vaRH -END PGP SIGNATURE- ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] pg_dump issue : Cannot drop a non-existent(?) trigger
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Tom, On Fri, 25 Mar 2005, Tom Lane wrote: Stephan Szabo [EMAIL PROTECTED] writes: Odd, why is this not showing up as a foreign key constraint? Has this database been upgraded (no matter through how many different upgrades) from an old version (7.1 or earlier I think)? And the other odd thing is that it fails to dump it as a trigger either. The invalid argument string complaint indicates that pg_dump didn't find the right number of \000 sequences in the tgargs value; but pg_get_triggerdef evidently is finding the right number of zero bytes. It almost looks like the tgargs value got coerced from bytea to text somewhere between the catalogs and pg_dump, but how'd that happen? It'd be good to look at the trigger row directly: select * from pg_trigger where tgname = 'RI_ConstraintTrigger_39053'; Here it is: prod=# select * from pg_trigger where tgname = 'RI_ConstraintTrigger_39053'; - -[ RECORD 1 ]--+--- tgrelid| 37564 tgname | RI_ConstraintTrigger_39053 tgfoid | 1644 tgtype | 21 tgenabled | t tgisconstraint | t tgconstrname | firma_moduller_firma_fkey1 tgconstrrelid | 37577 tgdeferrable | f tginitdeferred | f tgnargs| 6 tgattr | tgargs | firma_moduller_firma_fkey1 Regards, - -- Devrim GUNDUZ devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.tdmsoft.com http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFCRCsQtl86P3SPfQ4RAij+AJ4+p+Q9WrVTIo8xWR2YMWlgj9EoXgCgvhK8 n7CpjIeR54dcOyMg8hlb6w0= =efYi -END PGP SIGNATURE- ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] pg_dump issue : Cannot drop a non-existent(?) trigger
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Fri, 25 Mar 2005, Tom Lane wrote: Devrim GUNDUZ [EMAIL PROTECTED] writes: prod=# select * from pg_trigger where tgname = 'RI_ConstraintTrigger_39053'; - -[ RECORD 1 ]--+--- tgrelid| 37564 tgname | RI_ConstraintTrigger_39053 tgfoid | 1644 tgtype | 21 tgenabled | t tgisconstraint | t tgconstrname | firma_moduller_firma_fkey1 tgconstrrelid | 37577 tgdeferrable | f tginitdeferred | f tgnargs| 6 tgattr | tgargs | firma_moduller_firma_fkey1 Well, that's consistent with what pg_dump said the tgargs value is; but it ought to look like firma_moduller_firma_fkey1\000t_firma_moduller\000t_firmalar\000UNSPECIFIED\000firma_no\000no\000 and the output from \d proves that that data is actually stored. So why isn't it being displayed?? Does \d pg_trigger show that the tgargs column is of type bytea? Umm no: tgnargs| smallint | not null Also, get the OID for this pg_trigger row and see if it shows up in objid or refobjid of any rows of pg_depend Yes it is there prod=# SELECT * from pg_depend WHERE objid =39053; - -[ RECORD 1 ]-- classid | 16412 objid | 39053 objsubid| 0 refclassid | 1259 refobjid| 37564 refobjsubid | 0 deptype | a - -[ RECORD 2 ]-- classid | 16412 objid | 39053 objsubid| 0 refclassid | 1259 refobjid| 37577 refobjsubid | 0 deptype | a So... Is it with tgnargs issue? :( Regards, - -- Devrim GUNDUZ devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.tdmsoft.com http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFCRFYUtl86P3SPfQ4RAk1LAJ4wW13o7n29Fr52SY5/EbqNysh3PACgznyh 6RLdbTufPwP+vuHXc3+h1WE= =AOBb -END PGP SIGNATURE- ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] cvsup binaries?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Sat, 12 Mar 2005, Joe Conway wrote: Tom Lane wrote: Neil Conway [EMAIL PROTECTED] writes: The PostgreSQL docs suggest that ftp.postgresql.org holds binary builds of CVSup: Is this still the case? (I couldn't see any cvsup binaries, but perhaps they are well-hidden). If they are still there, they're probably exceedingly out of date :-( Although listed as RH9, the ones at http://www.joeconway.com/ work on my FC2 machine. They don't work on FC3 however, and I haven't gotten around to trying to rebuild on FC3. If anyone's interested, I've rebuilt the packages for RHEL ES 3: http://www.gunduz.org/rpms/cvsup/ Regards, - -- Devrim GUNDUZ devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.tdmsoft.com http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFCMvyWtl86P3SPfQ4RAl+9AKDJ6kL21t+f+Kehz8CVGcdrQokLwACfaB2r ShLh063uyOHiuY35wpTIBG4= =OzRi -END PGP SIGNATURE- ---(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] [COMMITTERS] pgsql: Disallow LOAD to non-superusers.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, Is it time for 7.4.7? I've seen many commits to 7.4 branch nowadays. Regards, Devrim On Mon, 24 Jan 2005, Tom Lane wrote: Log Message: --- Disallow LOAD to non-superusers. Per report from John Heasman. Tags: REL7_4_STABLE Modified Files: -- pgsql/src/backend/tcop: utility.c (r1.208 - r1.208.2.1) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/tcop/utility.c.diff?r1=1.208r2=1.208.2.1) ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match - -- Devrim GUNDUZ devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.tdmsoft.com http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFB9TYbtl86P3SPfQ4RArMOAJ4u9iPSiRnXKMIBIXIQCauJ1QaljACg3gjG 17d0mWM80ytwj5NxTpidMFM= =bomB -END PGP SIGNATURE- ---(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] [pgsql-hackers] Re: Translations at pgfoundry
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Fri, 21 Jan 2005, Josh Berkus wrote: OK, is anyone opposed to this idea? I would register a pgfoundry project (name suggestions? translations?), give most established translators commit access, and move the statistics pages there. BTW, there is already a translators mailing list. While I've been using it for the press releases, there's no reason why the translators can use it for all translations. Are all regional contacts are also the translators of .po files? Translating a press release is somewhat a non-technical issue; but the .po translators have to know PostgreSQL internals, I think... So, translators ml should be limited to the press release translators as it is now; and we need to create a new ml for the .po translators. Just my 0.02 ... Regards, - -- Devrim GUNDUZ devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.tdmsoft.com http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFB8Ymdtl86P3SPfQ4RAp4zAJ918KcctE/c90xlA99/cI63wBn04gCdF5RQ ooljgkP59MdcRSrr98AjBzE= =QgSX -END PGP SIGNATURE- ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [HACKERS] [pgsql-hackers-win32] %2$, %1$ gettext placeholder
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Mon, 17 Jan 2005, Tom Lane wrote: snip I don't think we'll hold up release to fix this, :-) It seems nothing seems to stop you from holding up this release anymore: Neither ARC problem nor this one :) Regards, - -- Devrim GUNDUZ devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.tdmsoft.com http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFB7B0Ktl86P3SPfQ4RAqCFAJ9YLdaUP8ALAetKHQcpPxHfrlcXcQCgpKmX gKsYQYdu8nh4rGQOo2DQl3c= =g6q/ -END PGP SIGNATURE- ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [HACKERS] looking for rh9 rpms for pgadmin v 1.2
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Wed, 12 Jan 2005, Dave Cramer wrote: Is there any intent to build these rpm's ? Who is responsible for this ? I remember a guy that was working on it. HE pushed me several times to get the spec file :) I've sent him at last, bur dont't remember what has happened soon. I have RH9 at home but I'm connected via 28.8 K modem :) I can't dl/ul the RPM file. I also don't have a CD writer at home. Anyway, if you are familiar with rebuilding rpms, please download our SRPM and rebuild your own rpm -- and please share it with us :) Regards, - -- Devrim GUNDUZ devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.tdmsoft.com http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFB5joetl86P3SPfQ4RAu20AJ9rUh+77ybLViG6G4JDuefQR9HPNgCfZHNf icpnxwz8RPcN8J5YPaHug60= =zNE7 -END PGP SIGNATURE- ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[HACKERS] [SECURITY] Fedora Core 2 Update: mysql-3.23.58-9.1 (fwd)
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Heh heh heh :-) - -- Forwarded message -- Date: Wed, 08 Dec 2004 12:33:48 -0500 From: Tom Lane [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [SECURITY] Fedora Core 2 Update: mysql-3.23.58-9.1 - - Fedora Update Notification FEDORA-2004-530 2004-12-08 - - Product : Fedora Core 2 Name: mysql Version : 3.23.58 Release : 9.1 Summary : MySQL client programs and shared libraries. Description : MySQL is a multi-user, multi-threaded SQL database server. MySQL is a client/server implementation consisting of a server daemon (mysqld) and many different client programs and libraries. This package contains the MySQL client programs, the client shared libraries, and generic MySQL files. - - * Tue Oct 12 2004 Tom Lane [EMAIL PROTECTED] 3.23.58-9.1 - - fix security issues CAN-2004-0835, CAN-2004-0836, CAN-2004-0837 (bugs #135372, 135375, 135387) - - fix privilege escalation on GRANT ALL ON `Foo\_Bar` (CAN-2004-0957) - - fix multilib problem with mysqlbug and mysql_config - - adjust chkconfig priority per bug #128852 - - remove bogus quoting per bug #129409 (MySQL 4.0 has done likewise) - - add sleep to mysql.init restart(); may or may not fix bug #133993 - - fix low-priority security issues CAN-2004-0388, CAN-2004-0381, CAN-2004-0457 (bugs #119442, 125991, 130347, 130348) - - fix bug with dropping databases under recent kernels (bug #124352) - - This update can be downloaded from: http://download.fedora.redhat.com/pub/fedora/linux/core/updates/2/ 631ed84a7379164d0fbfb92b69016285 SRPMS/mysql-3.23.58-9.1.src.rpm 4a0aec6e6dbe79edd30eb441c2f142d6 x86_64/mysql-3.23.58-9.1.x86_64.rpm 36dccd9a66e5cea5350dce364bcabd35 x86_64/mysql-server-3.23.58-9.1.x86_64.rpm dd48b7d5690d051d53958613be03d995 x86_64/mysql-devel-3.23.58-9.1.x86_64.rpm 96805f6f4016ea429a61c9fd1b048f13 x86_64/mysql-bench-3.23.58-9.1.x86_64.rpm 6226ba82b2bdfe91c3b6b966340cb117 x86_64/debug/mysql-debuginfo-3.23.58-9.1.x86_64.rpm 643a2d1e297fc56c133e231b627ab9fa i386/mysql-3.23.58-9.1.i386.rpm 4dd68414fe1096b703f7f8e155ef227f i386/mysql-server-3.23.58-9.1.i386.rpm 09beb1f36eff820937e2a7193559b8d9 i386/mysql-devel-3.23.58-9.1.i386.rpm 63991ec7997909cddfa114d244353434 i386/mysql-bench-3.23.58-9.1.i386.rpm 8d99d621e6259d4df98c242c9030 i386/debug/mysql-debuginfo-3.23.58-9.1.i386.rpm This update can also be installed with the Update Agent; you can launch the Update Agent with the 'up2date' command. - - - -- fedora-announce-list mailing list [EMAIL PROTECTED] http://www.redhat.com/mailman/listinfo/fedora-announce-list -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFBt32Xtl86P3SPfQ4RAvmGAKDjC4Qdu0E20ohd0vARtCY/oMr+IgCfYndW EQHslhLJ5prwGCFWfDMAL9Y= =VCiB -END PGP SIGNATURE- ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[HACKERS] Small fix for 7.2.6/contrib/seg
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, While trying to build 7.2.6 FC1 RPMs due to a request from Pierlugi today, I saw an error in contrib/seg. This small patch fixed the typo and we can build the RPMs now. Could you please apply it to 7.2? === - --- segparse.y.orig 2004-12-08 16:31:56.406802528 +0200 +++ segparse.y 2004-12-08 16:32:13.773162440 +0200 @@ -97,7 +97,6 @@ ((SEG *)result)-l_ext = ( $1.ext ? $1.ext : '\0' ); ((SEG *)result)-u_ext = '-'; } - - ; | RANGE boundary { ((SEG *)result)-lower = -HUGE; === Regards, - -- Devrim GUNDUZ devrim~gunduz.orgdevrim.gunduz~linux.org.tr http://www.tdmsoft.com http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFBtygItl86P3SPfQ4RAgstAKDqAgwuPiIFWxZGOkuNBiqJsLkKbQCguaqi vur5mirSNuFiyNwRFOvUQ6c= =+FMA -END PGP SIGNATURE- ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] Opinions on Usenet ...
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Mon, 29 Nov 2004, Marc G. Fournier wrote: If there were a comp.databases.postgresql.hackers newsgroup created and carried by all the news servers ... would you move to using it vs using the mailing lists? No. Using mailing lists is what I prefer since about '95. Regards, - -- Devrim GUNDUZ devrim~gunduz.orgdevrim.gunduz~linux.org.tr http://www.tdmsoft.com http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFBq460tl86P3SPfQ4RAheLAKDKTBaYshtXtQ4aM6caTyTqMZTvVgCfW+ec FpBEKlasn5HW+S4aCfjNkw0= =WspG -END PGP SIGNATURE- ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] 7.4.5 / 7.4.6 crash (pg_hba.conf issue)
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Wed, 17 Nov 2004, Tom Lane wrote: Off-by-one memory allocation problem --- it only bites you if the string lengths are just right, which probably explains the lack of prior reports even though the bug has been there since 7.3. Is this worth new dot releases? Regards, - -- Devrim GUNDUZ devrim~gunduz.orgdevrim.gunduz~linux.org.tr http://www.tdmsoft.com http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFBm79Ztl86P3SPfQ4RAh34AKDp/fCXVBYcbY1dYKO/TfwteNnBZACgpnl5 uG/yaUhmh97ZM+h9al1fmeE= =RdZ5 -END PGP SIGNATURE- ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] [COMMITTERS] pgsql: timestamptz_trunc() should only recalculate
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I got an error in make check now, in horology test: http://postgresql.gunduz.org/regression.diffs Is it related to this commit? Regards, Devrim On Mon, 1 Nov 2004, Tom Lane wrote: Log Message: --- timestamptz_trunc() should only recalculate the timezone when truncating to DAY precision or coarser; leave the timezone alone when precision is HOUR or less. This avoids surprises for inputs near a DST transition time, as per example from Matthew Gabeler-Lee. (The only reason we recalculate at all is so that outputs that are supposed to represent days will come out as local midnight, and that's not relevant for sub-day precision.) Modified Files: -- pgsql/src/backend/utils/adt: timestamp.c (r1.113 - r1.114) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/timestamp.c.diff?r1=1.113r2=1.114) ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org - -- Devrim GUNDUZ devrim~gunduz.orgdevrim.gunduz~linux.org.tr http://www.tdmsoft.com http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFBhrpMtl86P3SPfQ4RAvtXAKCs7zWA3n8crbd5VsToKoTobHqtEQCdEw5y mU92XW7xTLm3iC3L+jq0idA= =Rm7E -END PGP SIGNATURE- ---(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] [COMMITTERS] pgsql: timestamptz_trunc() should only
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Tue, 2 Nov 2004, Devrim GUNDUZ wrote: I got an error in make check now, in horology test: http://postgresql.gunduz.org/regression.diffs Is it related to this commit? Ok, it seems no (tested with revision 1.113 for double-check). I've just read the recent discussion on -hackers. Regards, - -- Devrim GUNDUZ devrim~gunduz.orgdevrim.gunduz~linux.org.tr http://www.tdmsoft.com http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFBhsAmtl86P3SPfQ4RAkipAKDaxAegnb7yv00devyxpyU0c9GGMwCeKD/w gxkgKxcnE+A7tFaZ0i+oVsc= =3oIT -END PGP SIGNATURE- ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[HACKERS] make check error on -HEAD
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I'm getting this error on two different servers, one if them is the server that I build PostgreSQL from CVS daily, the other one is a fresh one (used to double-check the error) Two servers have LANG=en_US.UTF-8. They are RHEL 3.0 Update 3 with gcc 3.2.3-42, and bison 1.875c: == == creating database regression == CREATE DATABASE pg_regress: could not set database default locales make[2]: *** [check] Error 2 rm regress.o make[2]: Leaving directory `/home/pgsql80/pgsql/src/test/regress' make[1]: *** [check] Error 2 make[1]: Leaving directory `/home/pgsql80/pgsql/src/test' make: *** [check] Error 2 == Any comments? Regards, - -- Devrim GUNDUZ devrim~gunduz.orgdevrim.gunduz~linux.org.tr http://www.tdmsoft.com http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFBhMLwtl86P3SPfQ4RAibUAJ4h/gvrWr76FPjJvJRnGsF3TXEY/ACfWJ5d z+wKbSmMSgGaoBXCmeEX/gw= =3l/A -END PGP SIGNATURE- ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [HACKERS] make check error on -HEAD
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Sun, 31 Oct 2004, Tom Lane wrote: pg_regress: could not set database default locales What shows up in the postmaster log file? You mean src/test/regress/log/postmaster.log, right? Actually not that much: LOG: database system was shut down at 2004-10-31 18:41:23 EET LOG: checkpoint record is at 0/A30FE8 LOG: redo record is at 0/A30FE8; undo record is at 0/0; shutdown TRUE LOG: next transaction ID: 492; next OID: 17230 LOG: database system is ready LOG: unexpected EOF on client connection LOG: received fast shutdown request LOG: shutting down LOG: database system is shut down Regards, - -- Devrim GUNDUZ devrim~gunduz.orgdevrim.gunduz~linux.org.tr http://www.tdmsoft.com http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFBhRi8tl86P3SPfQ4RAjYeAKC75B6SPdZUR8SNZ1nOu5cXQZ1S1ACfbUhx rSL56HYBFmpltjTEF3s2SQQ= =vZ60 -END PGP SIGNATURE- ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [HACKERS] make check error on -HEAD
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Sun, 31 Oct 2004, Tom Lane wrote: LOG: unexpected EOF on client connection Hmm, that seems to be the only sign of trouble, which I guess means we have to conclude the problem is on the client side not the server side. The part of the pg_regress script that is failing is evidently $bindir/psql $psql_options -c \ checkpoint; alter database \$dbname\ set lc_messages to 'C'; alter database \$dbname\ set lc_monetary to 'C'; alter database \$dbname\ set lc_numeric to 'C'; alter database \$dbname\ set lc_time to 'C'; $dbname 2/dev/null if [ $? -ne 0 ]; then echo $me: could not set database default locales (exit 2); exit fi Try removing the 2/dev/null bit so that you can see if any error messages come out from psql. Ok, we have a detailed error now: /home/pgsql80/pgsql/src/test/regress/./tmp_check/install//usr/local/pgsql/bin/psql: relocation error: /home/pgsql80/pgsql/src/test/regress/./tmp_check/install//usr/local/pgsql/bin/psql: undefined symbol: PQgetCancel pg_regress: could not set database default locales make[2]: *** [check] Error 2 make[2]: Leaving directory `/home/pgsql80/pgsql/src/test/regress' Regards, - -- Devrim GUNDUZ devrim~gunduz.orgdevrim.gunduz~linux.org.tr http://www.tdmsoft.com http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFBhR0utl86P3SPfQ4RAjbWAJ9HsRqk7uW2yZTUbI/i4Ds+nMW6aQCfXlzx BI5pV37UYbKEjXgMxZSpfLY= =Ocrg -END PGP SIGNATURE- ---(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] Compile error on 7.2.6/contrib/seg
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Sun, 24 Oct 2004, Tom Lane wrote: I get an error while building 7.2.6 RPMS on Fedora Core 1. bison -y -d -p seg_yy segparse.y segparse.y:101.7: syntax error, unexpected | Not sure anyone still cares, but I've backpatched the 7.3 fix for this, just in case we do make any further 7.2.* releases. Thanks. I'll rebuild 7.2.6 RPMS with that fix. Regards, - -- Devrim GUNDUZ devrim~gunduz.orgdevrim.gunduz~linux.org.tr http://www.tdmsoft.com http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFBfLOgtl86P3SPfQ4RAq0tAJ0VkXZYtPdSFJBTmroujRGyTAhciQCgrED+ m1ukj9fzbz0Z7xBi+WkX/8k= =x0V+ -END PGP SIGNATURE- ---(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] RPMS, time, and other things.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Mon, 25 Oct 2004, Lamar Owen wrote: I may critique from time-to-time the packaging, if Devrim doesn't mind, It would not, and won't be without you. It's good to know that you are around, good to know that you'll keep your eye on the packages. Regards, - -- Devrim GUNDUZ devrim~gunduz.orgdevrim.gunduz~linux.org.tr http://www.tdmsoft.com http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFBfXu9tl86P3SPfQ4RAmyKAJ0eMLyNDk5o3vvSnxLGFxDCPmpaJACfaXI5 rUyETygu8GyIZjeCn/46N/o= =pDMj -END PGP SIGNATURE- ---(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] Compile error on 7.2.6/contrib/seg
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I get an error while building 7.2.6 RPMS on Fedora Core 1. # gcc --version gcc (GCC) 3.3.2 20031022 (Red Hat Linux 3.3.2-1) # bison --version bison (GNU Bison) 1.875 make[1]: Entering directory `/usr/src/redhat/BUILD/postgresql-7.2.6/contrib/seg' sed 's,MODULE_PATHNAME,$libdir/seg,g' seg.sql.in seg.sql gcc -O2 -g -pipe -march=i686 -Wall -Wmissing-prototypes -Wmissing-declarations -fpic -I. -I../../src/include -c -o seg.o seg.c bison -y -d -p seg_yy segparse.y segparse.y:101.7: syntax error, unexpected | make[1]: *** [segparse.h] Error 1 make[1]: Leaving directory `/usr/src/redhat/BUILD/postgresql-7.2.6/contrib/seg' make: *** [all] Error 2 make: Leaving directory `/usr/src/redhat/BUILD/postgresql-7.2.6/contrib' error: Bad exit status from /var/tmp/rpm-tmp.22295 (%build) I've built this on Red Hat 9 and RHEL3, btw. Since it may be an ancient version, maybe it's not that important to fix... Regards, - -- Devrim GUNDUZ devrim~gunduz.orgdevrim.gunduz~linux.org.tr http://www.tdmsoft.com http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFBfBmmtl86P3SPfQ4RAnP5AJ9MyR7PgDllTbakcibqD3bvvECfNwCfTHml ax6G99sX6W59WGsKCPtdVAA= =+zvD -END PGP SIGNATURE- ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [HACKERS] Compiling from CVS: undefined reference to
Hi, On Mon, 27 Sep 2004, Serguei A. Mokhov wrote: Risking to report a dup (by being on digest), I report that I can't compile postgres from just CVS-checked out sources: snip Just had a fresh checkout, but could not reproduce it on RHEL3, gcc 3.2.3. Maybe you were caught in the middle of an commit? Regards, -- Devrim GUNDUZ devrim~gunduz.orgdevrim.gunduz~linux.org.tr http://www.tdmsoft.com http://www.gunduz.org ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Compiling from CVS: undefined reference to
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Mon, 27 Sep 2004, Serguei A. Mokhov wrote: Just had a fresh checkout, but could not reproduce it on RHEL3, gcc 3.2.3. Maybe you were caught in the middle of a commit? Dunno. I then did cvs up -dP, make distclean, and then ./configure --enable-nls again two times and the problem is still there. Perhaps it'd be wise of me to report the OS and the compiler versions :) This is FC2 with gcc 3.3.2. ... make[1]: Leaving directory `/home/pgsql80/pgsql/config' All of PostgreSQL successfully made. Ready to install. This is also FC2, with gcc version 3.3.3 20040412 (Red Hat Linux 3.3.3-7), a server that PostgreSQL has never been compiled before. There must be something messing up with your (previous) installation. Regards, - -- Devrim GUNDUZ devrim~gunduz.orgdevrim.gunduz~linux.org.tr http://www.tdmsoft.com http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFBWI0qtl86P3SPfQ4RAozIAJ4qk+VHueUaSfQHVgaMfEJTtOvphwCfcEa7 6ix75V3TXh+vCl32GL2ALh4= =Svg6 -END PGP SIGNATURE- ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [HACKERS] SELECT FOR UPDATE NOWAIT and PostgreSQL 8.0
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Mon, 13 Sep 2004, Simon Riggs wrote: Now we have LOCK TABLE ... NOWAIT; but I wonder whether we'll have the SELECT ... NOWAIT one. Today I got a request for this; and it was reported that this feature will be used in a huge project. Well, it shouldn't be too much of a patch - just cloning the code? Perhaps they can start in development without it and we'll patch it in later. I learned that the code is ready. They'll change the code now. Hmm... this seems the exact opposite of how I would tend to think the feature would be used... ie. you don't really care how long the query takes, just that you can't get the lock. Agreed - and this is important! I thought we'd done NOWAIT on the SELECT... Oh well, 8.1 will be better still. Bruce: Any TODO here? ;) Regards, - -- Devrim GUNDUZ devrim~gunduz.orgdevrim.gunduz~linux.org.tr http://www.tdmsoft.com http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFBRythtl86P3SPfQ4RAg5+AJ9jdgkolYwBgeLhTBRMt0W0TGd8AwCeJQuM 95igCBca4aisP82g4374nxs= =Yr9x -END PGP SIGNATURE- ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster