Re: [HACKERS] extension build issue with PostgreSQL 10 on Centos6
Hi, On Sat, 2017-09-30 at 11:15 -0400, Tom Lane wrote: > So the point is that postgresql-devel now needs to have a dependency > on icu-devel. Oh, I see. Ack, added. Will appear in 10.0 RPMs. Regards, -- Devrim Gündüz EnterpriseDB: https://www.enterprisedb.com PostgreSQL Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [HACKERS] extension build issue with PostgreSQL 10 on Centos6
Hi, On Sat, 2017-09-30 at 08:19 +0200, Pavel Stehule wrote: > probably rpm is created with --with-icu Sure, I compile all v10 RPMs with ICU support. Regards -- Devrim Gündüz EnterpriseDB: https://www.enterprisedb.com PostgreSQL Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [HACKERS] configure issue - warnings sort: No such file or directory
Hi, On Sat, 2017-09-02 at 06:52 +0200, Pavel Stehule wrote: > but looks so it is Fedora26 issue - I see these lines elsewhere too. I cannot reproduce it on my F26 box. Regards, -- Devrim Gündüz EnterpriseDB: https://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [HACKERS] how are the rpms configured that are available in PostgreSQL RPM Building Project - Yum Repository
Hi, On Fri, 2017-06-16 at 19:40 +, Cook, Malcolm wrote: > > I am referring to the contents of https://yum.postgresql.org/ (specifically > version 9.6 rpms for CentoOS7) > > More specifically I wonder if they are configured: --with-python --with- > tcl --with-pam --with-ldap /usr/pgsql-9.6/bin/pg_config --configure will give the full list (the answer is yes, btw) > And do they install the Additional Supplied Modules > (https://www.postgresql.org/docs/9.1/static/contrib.html ) as provided when > performing a > > make install world Yes, the -contrib rpm provides those. > Please advise if my possibly novice question should better be posed > elsewhere. Please email pgsql-pkg-...@postgresql.org list for further questions. Regards, -- Devrim Gündüz EnterpriseDB: https://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [HACKERS] PDF build is broken
Hi Peter, On Sun, 2017-03-26 at 15:05 -0400, Peter Eisentraut wrote: > Fixed. (Sorry for the late response): Thanks, it builds fine. > But I also suggest that you try out the FOP based builds, > because the jadetex-based builds will probably go away soon. Can you please let me know how I will do it? Any docs somewhere? Regards, -- Devrim Gündüz EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
[HACKERS] PDF build is broken
Hi, I can't build PDFs with latest snapshot tarball: $ make postgres-A4.pdf { \ echo ""; \ echo ""; \ } > version.sgml '/usr/bin/perl' ./mk_feature_tables.pl YES ../../../src/backend/catalog/sql_feature_packages.txt ../../../src/backend/catalog/sql_features.txt > features-supported.sgml '/usr/bin/perl' ./mk_feature_tables.pl NO ../../../src/backend/catalog/sql_feature_packages.txt ../../../src/backend/catalog/sql_features.txt > features-unsupported.sgml '/usr/bin/perl' ./generate-errcodes-table.pl ../../../src/backend/utils/errcodes.txt > errcodes-table.sgml openjade -wall -wno-unused-param -wno-empty -wfully-tagged -D . -D . -c /usr/share/sgml/docbook/dsssl-stylesheets/catalog -d stylesheet.dsl -t sgml -i output-html -V html-index postgres.sgml LC_ALL=C '/usr/bin/perl' /usr/bin/collateindex.pl -f -g -i 'bookindex' -o bookindex.sgml HTML.index Processing HTML.index... 2762 entries loaded... collateindex.pl: duplicated index entry found: TRUNC 1 entries ignored... Done. openjade -D . -D . -c /usr/share/sgml/docbook/dsssl-stylesheets/catalog -d ./stylesheet.dsl -t tex -V tex-backend -i output-print -i include-index -V texpdf-output -V '%paper-type%'=A4 -o postgres-A4.tex-pdf postgres.sgml openjade:ref/alter_collation.sgml:96:10:E: [xref to REFSECT1 unsupported] pdfjadetex postgres-A4.tex-pdf This is pdfTeX, Version 3.14159265-2.6-1.40.17 (TeX Live 2016) (preloaded format=pdfjadetex) restricted \write18 enabled. entering extended mode ! I can't find file `postgres-A4.tex-pdf'. <*> postgres-A4.tex-pdf (Press Enter to retry, or Control-D to exit) Please type another input file name: Can someone please take a look? Regards, -- Devrim Gündüz EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [HACKERS] drop support for Python 2.3
Hi, On Sun, 2017-02-19 at 16:20 -0500, Tom Lane wrote: > Well, that test is checking which week-of-the-year a Sunday midnight is > considered to fall into. There could be an edge-case bug in Tcl itself, > or a problem with the time zone data, or maybe if you're setting LC_TIME > to tr_TR, that changes whether weeks are considered to start on Sunday > or Monday? Although if that were the explanation I'd have expected this > test to fail in tr_TR locale on pretty much any platform. Weird. All LC_* settings are en_GB.UTF-8 on this server. > Whatever, even if it's a bug it's not our bug. I've adjusted the test to > check the following Tuesday, so as to dodge the edge case. Thanks! Looks like buildfarm is green again. Regards, -- Devrim Gündüz EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [HACKERS] drop support for Python 2.3
Hi Tom, On Sun, 2017-02-19 at 13:48 -0500, Tom Lane wrote: > Hmph. I can't see any relevant-looking source changes between 8.4.13 > and 8.4.15, which I have laying about here and which works fine. > I wonder if Red Hat is carrying some distro-specific patch that > breaks this case? Just downloaded SRPM, and I don't *think* so their patch would break this. > Or conceivably it's timezone dependent? FWIW, the timezone of the server is GMT+3, if that is what you are asking. > Anyway, my inclination is just to tweak that test a bit so it doesn't > trip over the problem. The point of the test is mainly to see if the > [clock] command works at all, not to exercise any specific parameter > choices. Would you check whether this: > > $ tclsh > % clock format [clock scan "1/26/2010"] -format "%U" > > gives the expected result "04" on that machine? Yes, I got 04. Regards, -- Devrim Gündüz EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [HACKERS] drop support for Python 2.3
Hi Tom, On Sun, 2017-02-19 at 10:42 -0500, Tom Lane wrote: > Relevant question: what version of tcl is installed on those? 8.4.13 is installed. Regards, -- Devrim Gündüz EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [HACKERS] drop support for Python 2.3
Hi, On Thu, 2017-02-16 at 08:21 -0500, Peter Eisentraut wrote: > I will wait for that before proceeding. Sorry for the delay, I also had to build a newer flex RPM before proceeding. arapaima(x86) and aholehole(x86_64) are the new animals. They are running the buildfarm script now. Regards, -- Devrim Gündüz EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [HACKERS] drop support for Python 2.3
Hi Peter, On Thu, 2017-02-16 at 08:21 -0500, Peter Eisentraut wrote: > > I have CentOS 5 instances running on buildfarm. I'll register them via > > buildfarm.pg.org soon. > > I will wait for that before proceeding. Sorry for the delay. Machines are ready, I think I can prepare the buildfarm instances later Saturday. Regards, -- Devrim Gündüz EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [HACKERS] drop support for Python 2.3
Hi, On Wed, 2017-02-08 at 09:16 -0500, Peter Eisentraut wrote: > It appears that we don't have anything running 2.4. A RHEL/CentOS 5 > system with standard components would be a good addition to the build farm. I have CentOS 5 instances running on buildfarm. I'll register them via buildfarm.pg.org soon. Regards, -- Devrim Gündüz EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [HACKERS] Retiring from the Core Team
Hi, On Wed, 2017-01-11 at 16:29 -0800, Josh Berkus wrote: > You will have noticed that I haven't been very active for the past year. > My new work on Linux containers and Kubernetes has been even more > absorbing than I anticipated, and I just haven't had a lot of time for > PostgreSQL work. > > For that reason, as of today, I am stepping down from the PostgreSQL > Core Team. This is sad news. Thank you for your great contributions to PostgreSQL, and I with success in the future! Regards, -- Devrim Gündüz EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [HACKERS] Time to up bgwriter_lru_maxpages?
Hi, On Mon, 2016-11-28 at 11:40 -0800, Jim Nasby wrote: > With current limits, the most bgwriter can do (with 8k pages) is 1000 > pages * 100 times/sec = 780MB/s. It's not hard to exceed that with > modern hardware. Should we increase the limit on bgwriter_lru_maxpages? +1 for that. I've seen many cases that we need more than 1000. Regards, -- Devrim Gündüz EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [HACKERS] Non-empty default log_line_prefix
Hi, On Wed, 2016-10-12 at 13:11 -0400, Tom Lane wrote: > > What is the cost of using %m, other than 4 (rather compressible) bytes per > > log entry? > > More log I/O, which is not free ... FWIW, we've been setting log_line_prefix to '< %m > ' for quite a long time in PGDG RPMs, and did not get any complaints. I'd vote for %m for default. Regards, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [HACKERS] ICU integration
Hi, On Fri, 2016-09-09 at 09:48 +0800, Craig Ringer wrote: > Personally I would be pretty reluctant to package libicu when it's > already in RH/Fedora. If it were bundled in Pg's source tree and a > private copy was built/installed by the build system so it was part of > the main postgresql-server package that'd be different. Agreed. I did not read the whole thread (yet), but if this is something like tzdata, I would personally want to use the libuci supplied by OS, like we do for tzdata. (That said, just checked EDB's ICU support. We currently ship our own libicu there, as a part of EPAS, but I don't know the reasoning/history behind there.) Regards, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [HACKERS] 9.5.4: Segfault (signal 11) while running ALTER TABLE
Hi Tom, On Tue, 2016-08-30 at 08:18 -0400, Tom Lane wrote: > The above isn't ever likely to work for any large value of "work", > because the function would be confused about what the table rowtype > is. I thought we had adequate defenses in there to throw an error > if you try to access a table that's in the middle of being altered, > but apparently this case isn't covered. > > Why didn't they just do > ALTER TABLE foo1 ALTER COLUMN id TYPE INTEGER USING newid; > ? The intermediate function sure seems like the hard way. Just got a reply from them. They had some historical reasons for this, but apparently it was not needed, so they'll change their procedures based on your suggestion. However, they also reported that they did not have this problem in their staging environment. I assume that staging has less resources than the prod machine. What could cause this problem that has more maintenance_work_mem and shared_buffers than staging one? Thanks! Regards, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
[HACKERS] 9.5.4: Segfault (signal 11) while running ALTER TABLE
Hi, I received an email offlist about a crash that a non-customer experienced recently. I asked them to send a few details about the crash, so here it is. Please note that I don't have access to their systems, but they will be fast enough to provide data if needed. (They asked me to mask some of the table/func names) They have a domain called primaryuuid: CREATE DOMAIN primaryuuid AS uuid NOT NULL DEFAULT uuid_generate_v4(); and a table called foo1, which used to have this domain as a data type: CREATE TABLE foo1 ( id public.primaryuuid NOT NULL, tempuuid uuid ); They wanted to change id column from uuid to int, so created this func first: CREATE FUNCTION foofunc_id_uuidtoint(chartoconvert uuid) RETURNS integer LANGUAGE sql IMMUTABLE STRICT AS $_$ SELECT newid FROM foo1 WHERE tempuuid = $1 LIMIT 1; $_$; and ran this: ALTER TABLE foo1 ALTER COLUMN id TYPE INTEGER USING foofunc_id_uuidtoint(tempuuid); This command crashed postmaster. They connected to related process once again with gdb, and got this: === Program received signal SIGSEGV, Segmentation fault. slot_deform_tuple (slot=0x1b80440, natts=13) at heaptuple.c:1157 1157values[attnum] = fetchatt(thisatt, tp + off); Continuing. === Below are some lines in postgresql.log: == ERROR: canceling autovacuum task CONTEXT: automatic vacuum of table "foo1" process 10884 acquired AccessExclusiveLock on relation 16961 of database 16401 after 1000.411 ms STATEMENT: ALTER TABLE foo1 ALTER COLUMN id TYPE INTEGER USING foofunc_id_uuidtoint(tempuuid); LOG: server process (PID 10884) was terminated by signal 11: Segmentation fault == Please note that this crash is not specific to this table. Various attempts to change this data type on various tables also crashed postmaster. This happened a few times, and after disabling autovacuum and lowering maintenance_work_mem from 4GB to 2GB, they could complete all ALTER TABLE commands. This is PostgreSQL 9.5.4 on CentOS 6.8, fully up2date, and they are using the community RPMs. Any ideas what is causing this crash? Please let me know if you need more data. Regards, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [HACKERS] Renaming of pg_xlog and pg_clog
Hi, On Fri, 2016-08-26 at 21:12 +0900, Michael Paquier wrote: > In short, with the current names, sometimes users think that pg_xlog > and pg_clog are just logs. And so it is fine to delete them to free up > space, corrupting their cluster, because they are just *logs*. ...and we also have "pg_logical", that includes a "log" keyword already... Regards, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [HACKERS] Unable to test parallel aggregate/joins in Postgres beta 2
Hi, On Thu, 2016-07-14 at 18:46 +0530, Madusudanan.B.N wrote: > I installed postgres beta 2 using the RPM provided here for Cent OS. > > Based on this article I was trying to set *max_parallel_degree*, but > postgres complained that there was no such config variable. But I was able > to set *max_parallel_workers_per_gather* and test things for parallel > sequential scan That article seems to be pre-beta2. The name of the parameter was changed to max_parallel_workers_per_gather, so what you did was correct. > I have a hunch that I have installed a previous beta version i.e beta 1, > but *Select version()* reported that I was using 9.6beta2 only. What makes you feel like you have beta1 installed? Can I get the output of: rpm -qa|grep postgresql > What have I done wrong ? > > 1) The RPM file that I downloaded has 9.6 beta 1. Name is mentioned as > pgdg-redhat96-9.6-1.noarch.rpm. This is *not* PostgreSQL version -- this is the repository RPM only. > 2) Should beta2 built only from source ? If the RPM is beta 1 why is the > server version reporting as beta2 ? See above. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [HACKERS] Death by regexp_replace
Hi, That is the version of *repo* RPM, not PostgreSQL itself.Once you install it, you can grab the latest version with yum install postgresql92-server Regards, Devrim On January 15, 2016 7:48:53 PM GMT+02:00, Robert Haaswrote: >> Hmm I just wanted to get the rpm for the latest 9.2 release for >centos6 but >> it looks like you haven't released at least the link on this page for >9.2 >> >> http://yum.postgresql.org/repopackages.php >> >> says 7 in the filename which is certainly not 14 ;-) >> >> >http://yum.postgresql.org/9.2/redhat/rhel-6-x86_64/pgdg-centos92-9.2-7.noarch.rpm >> >> Is that expected? > >Adding Devrim, who I believe maintains that stuff. > >-- >Robert Haas >EnterpriseDB: http://www.enterprisedb.com >The Enterprise PostgreSQL Company -- Sent from my Android device with K-9 Mail. Please excuse my brevity.
Re: [HACKERS] [CORE] Restore-reliability mode
Hi, On Sat, 2015-06-06 at 12:15 +0200, Magnus Hagander wrote: If I'm not mistaken, we (Simon and me) actually discussed something else along this line a while ago that might be worth considering. That is, maybe we should consider time-based alpha releases. That is, we can just decide we wrap an alpha every other Monday until we think we are good to go with beta. The reason for that is to get much quicker iteration on bugfixes, which would encourage people to use and test these versions. Report a bug and if it was easy enough to fix, you have a wrapped release with the fix in 2 weeks top. +1. Package availability would depend on platform. For those platforms where package building is more or less entirely automatic already, this could probably also be easily automated. When we used to release more alphas years ago, I was releasing Alpha RPMs for many platforms. I'll do it again if we keep doing it. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] rhel6 rpm file locations
Hi, On Thu, 2015-05-28 at 08:54 -0500, Ted Toth wrote: Are there any other packagers following the Fedora 'standards' that you are aware of? It is not about following the standards or not. Unlike distro RPMs, you can install multiple PostgreSQL versions into the same box using community RPMS. That caused a bit of breakage. So, instead of using %{_libdir}, we install our libs and binaries under /usr/pgsql-X.Y, (like 9.4, 9.3), and use lib/ and bin/ subdirectory under that one. So, we are are not multiarch compatible. I am not sure if we can ship 32-bit libs with 64-bit packages or not, though, to fix this issue. May I ask you to subscribe pgsql-pkg-...@postgresql.org if you want to discuss more? Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] Help needed for PL/Ruby
Hi, Anyone? :) Regards, Devrim On Wed, 2015-03-18 at 15:19 +0200, Devrim Gündüz wrote: Hi, Background info first: PL/Ruby was originally maintained by Guy Decoux, who passed away in 2008: https://www.ruby-forum.com/topic/166658 . After his death, Akinori MUSHA forked the project and maintained it until 2010: https://github.com/knu/postgresql-plruby . Last release was on Jan 2010, and recent distros started throwing build errors. I was having similar build issues while trying to RPMify PL/Ruby, and finally stepped up the plate and tried to fix those build issues by forking the project: https://github.com/devrimgunduz/postgresql-plruby/ I mainly applied patches from Fedora, and also did some basic cleanup. However, I don't know Ruby and have limited C skills, so I need some help on these: * Complete the extension support: I committed initial infrastructure for it, but I don't think it is ready yet. * Fix the FIXME: https://github.com/devrimgunduz/postgresql-plruby/blob/master/src/plpl.c#L844 * Documentation review and update: The recent example is against PostgreSQL 8.0. A recent Ruby example would be good, and also we need updates for creating the language. Any contributions are welcome. I recently released 0.5.5 that at least is ready for testing. I want to remind that I am not a Ruby guy, so this is really a community stuff for me. Thanks by now. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
[HACKERS] Help needed for PL/Ruby
Hi, Background info first: PL/Ruby was originally maintained by Guy Decoux, who passed away in 2008: https://www.ruby-forum.com/topic/166658 . After his death, Akinori MUSHA forked the project and maintained it until 2010: https://github.com/knu/postgresql-plruby . Last release was on Jan 2010, and recent distros started throwing build errors. I was having similar build issues while trying to RPMify PL/Ruby, and finally stepped up the plate and tried to fix those build issues by forking the project: https://github.com/devrimgunduz/postgresql-plruby/ I mainly applied patches from Fedora, and also did some basic cleanup. However, I don't know Ruby and have limited C skills, so I need some help on these: * Complete the extension support: I committed initial infrastructure for it, but I don't think it is ready yet. * Fix the FIXME: https://github.com/devrimgunduz/postgresql-plruby/blob/master/src/plpl.c#L844 * Documentation review and update: The recent example is against PostgreSQL 8.0. A recent Ruby example would be good, and also we need updates for creating the language. Any contributions are welcome. I recently released 0.5.5 that at least is ready for testing. I want to remind that I am not a Ruby guy, so this is really a community stuff for me. Thanks by now. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [HACKERS] PDF builds broken again
Hi, On Wed, 2014-07-23 at 15:53 +0200, Magnus Hagander wrote: I ended up splitting the paragraph in two in order to get the PDFs to build. I've applied a patch for this to 9.0 only so we can keep building PDFs. Thanks for looking at this -- you saved my time. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
[HACKERS] pg_filedump for 9.4?
Hi, Will there be a pg_filedump for 9.4? I'd like to finish package tests before we release 9.4.0. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [HACKERS] postgresql.auto.conf and reload
Hi, On Wed, 2014-06-25 at 18:42 +0530, Amit Kapila wrote: This will happen without Alter System as well, if you change the value of port in postgresql.conf and try to load conf file with SIGHUP. You cannot reload PGC_POSTMASTER parameters without server restart. Ok, but Christoph already started the server (successfully) with port 5494, so the pg_reload_conf() should ignore it in the next attempt. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [HACKERS] RHEL6 packaging issue for 9.4 beta - libevent conflict
Hi, On Wed, 2014-06-18 at 09:41 -0400, Andrew Dunstan wrote: The only thing I can think of offhand that would require it is pgbouncer. Yeah. Recent pgbouncer versions require libevent 2.0+, and RHEL 6 has 1.4. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [HACKERS] slotname vs slot_name
Hi, On Thu, 2014-06-05 at 10:57 +0900, Fujii Masao wrote: BTW, what about also renaming pg_llog directory? I'm afraid that a user can confuse pg_log with pg_llog. +1. I hit this while testing 9.4 this week. Should be confusing for many end-users. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [HACKERS] yum psycopg2 doc package not signed
Hi, On Tue, 2014-01-21 at 20:19 -0200, Martín Marqués wrote: I was updating the packages from one of my servers and I got this message: Package python-psycopg2-doc-2.5.2-1.f19.x86_64.rpm is not signed If I remove the package (I thought it might be that package alone) I get errors from other packages: Package python-psycopg2-2.5.2-1.f19.x86_64.rpm is not signed Something wrong with the packages? I thought I fixed that -- but apparently not. Please run yum clean metadata and try updating the package again. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
Re: [HACKERS] using rpmbuild with PostgreSQL 9.2.6 source code
Hi, On Mon, 2014-01-20 at 15:46 +0800, Sameer Kumar wrote: I have downloaded the tar source code of PostgreSQL and also the SPEC file. I am trying to use rpmbuild command but I always get below error: error: Failed build dependencies: uuid-devel is needed by postgresql92-9.2.6-1PGDG.el6.ppc64 selinux-policy = 3.9.13 is needed by postgresql92-9.2.6-1PGDG.el6.ppc64 You are not using the correct spec file -- the one you are using is for Fedora. Use RHEL spec file: http://svn.pgrpms.org/repo/rpm/redhat/9.2/postgresql/EL-6/ (Also, this email do not belong to -hackers. You don't need to cross-post here) Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part
[HACKERS] Can we add sample systemd service file to git repo?
Hi, Many distros are switching/switched to systemd. In the git repo, we only have init script for SysV. Would it make sense to add systemd service script to our tarball as well? This could also standardize the systemd scripts used in other distros. http://svn.pgrpms.org/browser/rpm/redhat/9.3/postgresql/F-19/postgresql-9.3.service is an example of what we use in the RPMs. (if website fails, please just reload) Attached is a modified version that will work with the compile defaults. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz [Unit] Description=PostgreSQL 9.3 database server After=syslog.target After=network.target [Service] Type=forking User=postgres Group=postgres # Note: avoid inserting whitespace in these Environment= lines, or you may # break postgresql-setup. # Port number for server to listen on Environment=PGPORT=5432 # Location of database directory Environment=PGDATA=/usr/local/pgsql/data/ # Where to send early-startup messages from the server (before the logging # options of postgresql.conf take effect) StandardOutput=syslog # Disable OOM kill on the postmaster OOMScoreAdjust=-1000 ExecStart=/usr/local/pgsql/bin/pg_ctl start -D ${PGDATA} -s -o -p ${PGPORT} -w -t 300 ExecStop=/usr/local/pgsql/bin/pg_ctl stop -D ${PGDATA} -s -m fast ExecReload=/usr/local/pgsql/bin/pg_ctl reload -D ${PGDATA} -s # Give a reasonable amount of time for the server to start up/shut down TimeoutSec=300 [Install] WantedBy=multi-user.target signature.asc Description: This is a digitally signed message part
Re: [HACKERS] Matview patch added rewriteDefine.c.orig to the repository
Hi, Kevin already removed it with a followup commit: http://git.postgresql.org/pg/commitdiff/d63977eea3ab18fdec05e370b633d10b9fd20179 Regards, Devrim Boszormenyi Zoltan z...@cybertec.at wrote: Hi, commit 3bf3ab8c563699138be02f9dc305b7b77a724307 (Add a materialized view relations.) added this: src/backend/rewrite/rewriteDefine.c.orig| 945 +... ... create mode 100644 src/backend/rewrite/rewriteDefine.c.orig Committers should be more careful if they want to do work late Sunday. I know, Monday begins on Saturday[1], but still... ;-) [1] http://en.wikipedia.org/wiki/Monday_Begins_on_Saturday Best regards, Zoltán Böszörményi -- -- Zoltán Böszörményi Cybertec Schönig Schönig GmbH Gröhrmühlgasse 26 A-2700 Wiener Neustadt, Austria Web: http://www.postgresql-support.de http://www.postgresql.at/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers -- Devrim Gündüz
Re: [HACKERS] Error Building rpm
Hi, On Mon, 2013-01-21 at 10:53 +0530, Vivek Singh Raghuwanshi wrote: I am trying to build rpm of PostgreSQL, and the approach is building rpm for 1. CentOS 6+ 2. Fedora 15+ 3. RedHat 6+ 4. OpenSUSE 5. SuSE via single spec file and not using any external rpm or repo while building Building RPMs using a single spec file is almost impossible, as I wrote you in my previous emails. SuSE has different package names, Fedora 15+ has separate init system (systemd), etc. That's why I am keeping separate copies of each spec file for Fedora and its derivatives (RHEL, SL, CentOS) separately. -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] Error Building rpm
Hi, On Mon, 2013-01-21 at 11:33 +0530, Vivek Singh Raghuwanshi wrote: But i am trying to achieve this via multiple if conditions , can you send me your redhat and suse spec files. As I have emailed you before, spec files,etc. are at http://svn.pgrpms.org/repo Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] pg_upgrade does not completely honor --new-port
Hi, On Wed, 2012-09-26 at 22:06 -0400, Bruce Momjian wrote: I just performed a test upgrade from 9.1 to 9.2, and used --new-port variable. However, the analyze_new_cluster.sh does not include the new port, thus when I run it, it fails. Any chance to add the port number to the script? Well, the reason people normally use the port number is to do a live check, but obviously when the script is created it isn't doing a check. I am worried that if I do embed the port number in there, then if they change the port after the upgrade, they now can't use the script. I assume users would have PGPORT set before running the script, no? They can't use the script in each way -- at least we can make it usable for one case, I think. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
[HACKERS] Re: [COMMITTERS] pgsql: Properly set relpersistence for fake relcache entries.
Hi, On Tue, 2012-09-25 at 20:42 -0400, Robert Haas wrote: It seems therefore that REINDEX + VACUUM with vacuum_freeze_table_age=0 is not quite sufficient to recover from this problem. If your index has come to contain a circularity, vacuum will fail to terminate, and you'll need to drop it completely to recover. What is the difference between REINDEX and dropping and recreating index? (or say, creating the same index with another name, dropping old one, and renaming the new one with old one?) Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
[HACKERS] pg_upgrade does not completely honor --new-port
Hi, I just performed a test upgrade from 9.1 to 9.2, and used --new-port variable. However, the analyze_new_cluster.sh does not include the new port, thus when I run it, it fails. Any chance to add the port number to the script? Also, is it worth to add the value specified in --new-bindir as a prefix to vacuumdb command in the same script? Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] Uppercase tab completion keywords in psql?
Hi, On Wed, 2012-05-30 at 22:03 -0400, Bruce Momjian wrote: A control variable was added in this commit: commit db84ba65ab5c0ad0b34d68ab5a687bc5f4ca3ba6 Author: Peter Eisentraut pete...@gmx.net Thanks Bruce, apparently I missed it. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] Uppercase tab completion keywords in psql?
Hi, On Mon, 2012-05-07 at 13:22 -0400, Robert Haas wrote: On Sat, May 5, 2012 at 9:03 AM, Bruce Momjian br...@momjian.us wrote: On Fri, May 04, 2012 at 08:46:28PM +0300, Peter Eisentraut wrote: On tor, 2012-05-03 at 15:47 -0400, Bruce Momjian wrote: Peter, where are we on this? I hadn't received any clear feedback, but if no one objects, I can commit it. I think there were enough people that wanted some kind of control in this area. I did give you feedback on the patch. Yes, there were significantly more votes for reverting this than keeping it. So we at least need to have a setting. Can we do something about this before beta2 is bundled? I would like it to be reverted though, rather than having a setting. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] 9.2 release notes, beta time?
On Sun, 2012-04-29 at 13:23 +0100, Simon Riggs wrote: (As a side note, RPMs *may not* be ready, because I (and Magnus) will be at PGDay Turkey on 12th, and will be busy over the whole weekend). Is that a closed meeting? I hadn't seen any mention of that anywhere. Not that much. I've been tweeting about that (in Turkish, sorry) and sending out announcements to local mailing lists for quite some time, but we not able to finalize the venue until last week. This is the 2nd one after last year. I will do a wider announcement next time, I promise -- and the new event submission policy on postgresql.org raised a barrier against adding an item to the website, but that is more a -www topic. (Oh, and you need to have the secret key to enter the meeting.) -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] 9.2 release notes, beta time?
Hi, On Fri, 2012-04-27 at 21:17 -0400, Bruce Momjian wrote: We release the alpha with no packaging. I have released RPMs regularly for all alphas before, at least over the last 2 years or so. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] 9.2 release notes, beta time?
Hi, On Fri, 2012-04-27 at 19:02 -0400, Tom Lane wrote: The website crew might have a problem though. Magnus is flying on 13th and 14th, Dave, Stefan and Thom are flying on 14th. I'm flying on 15th -- it seems I have some cycles for updating website, I hope. Not sure about the others. (As a side note, RPMs *may not* be ready, because I (and Magnus) will be at PGDay Turkey on 12th, and will be busy over the whole weekend). Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] pg_prewarm
Hi, On Thu, 2012-03-08 at 23:13 -0500, Robert Haas wrote: It's been bugging me for a while now that we don't have a prewarming utility, for a couple of reasons, including: 1. Our customers look at me funny when I suggest that they use pg_relation_filepath() and /bin/dd for this purpose. 2. Sometimes when I'm benchmarking stuff, I want to get all the data cached in shared_buffers. This is surprisingly hard to do if the size of any relation involved is =1/4 of shared buffers, because the BAS_BULKREAD stuff kicks in. You can do it by repeatedly seq-scanning the relation - eventually all the blocks trickle in - but it takes a long time, and that's annoying. So I wrote a prewarming utility. I was talking to an Oracle DBA about this just yesterday. We also have pgfincore, but pg_prewarm is pretty much we need actually, I think. Did not test the patch, but the feature should be in core/contrib/whatever. This will also increase performance for the static tables that needs to be in the buffers all the time. I'm also seeing some use cases for BI databases. Thanks! Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] broken link to PostgreSQL 9.1 repository for Fedora 14
Hi, On Sat, 2012-01-07 at 08:47 +0100, Pavel Stehule wrote: There is broken link on http://yum.postgresql.org/repopackages.php page PostgreSQL 9.1 - Fedora 14 - http://yum.postgresql.org/9.1/fedora/fedora-14-i386/pgdg-fedora-9.1-2.noarch.rpm - 404 - Not Found Fixed, but please report it to pgsql-www next time. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] 9.1.2 ?
On Wed, 2011-11-09 at 21:12 -0500, Robert Haas wrote: The point is that all the packaging will be done *before* people leave to go eat Turkey. Eating me? -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] Will Index-only-scan be in 9.2
On Wed, 2011-10-12 at 02:08 +0200, hans wulf wrote: I was wondering if the index-only-scan will be available in 9.2? This is not having to visit the real data to answer a query, if all the information is available in the index. I think this will be a mayor step in overtaking the big O in the g-spot. http://rhaas.blogspot.com/2011/10/index-only-scans-weve-got-em.html Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] unaccent contrib
On Wed, 2011-09-21 at 18:28 +0200, Daniel Vázquez wrote: Can Global Development Group, make some acumulative rpm for contrib modules that are backward compatible??? No (as the RPM maintainer). -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] Back-branch releases upcoming this week
On Tue, 2011-09-20 at 01:37 -0400, Tom Lane wrote: As has been mentioned a couple times, we're well overdue for updates of the back branches. Seems like time to get that done, so we'll be wrapping 8.2.x and up this Thursday for release Monday the 26th. Can we also specify a final release version for 8.2? This set will be 8.2.21, and I propose to EOL 8.2 as of 8.2.22. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] Alpha 1 for 9.2
On Tue, 2011-09-06 at 16:49 +0300, Devrim GÜNDÜZ wrote: Is there a plan to wrap up 9.2 Alpha 1 before the next commitfest? ... Ok, so if noone is willing to produce alpha's (which is sad), we need to change the text in here: http://www.postgresql.org/developer/alpha -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
[HACKERS] Alpha 1 for 9.2
Hi, Is there a plan to wrap up 9.2 Alpha 1 before the next commitfest? Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] Alpha 1 for 9.2
On Tue, 2011-09-06 at 10:06 -0400, Bruce Momjian wrote: Devrim GNDZ wrote: Is there a plan to wrap up 9.2 Alpha 1 before the next commitfest? We talked about it on core and no one seems interested in doing the packaging. :-( Oh, what if noone will be interested in packaging until the last commitfest? We need people to start testing features, without having to use git or such. -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] rc1 or beta4?
On Wed, 2011-08-17 at 14:00 +0100, Dave Page wrote: Are we going with beta4 or rc1? RC1: http://archives.postgresql.org/message-id/19869.1312298...@sss.pgh.pa.us Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] [COMMITTERS] pgsql: Enable CHECK constraints to be declared NOT VALID
On Thu, 2011-06-30 at 15:09 -0400, Alvaro Herrera wrote: snip I don't think we have a policy for this, but I have done it for some time now and nobody has complained, so I sort of assumed it was okay. Besides, some of the people pouring the money in does care about it; moreover, it provides a little incentive for other companies that might also be in a position to fund development but lack the peer approval of the idea, or a final little push. So what's the general opinion here? +1 for adding sponsor name to the commit message. It will encourage companies more. -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
[HACKERS] Re: [COMMITTERS] pgsql: Fixed string in German translation that causes segfault.
On Mon, 2011-06-20 at 11:58 +, Michael Meskes wrote: Fixed string in German translation that causes segfault. Applied patch by Christoph Berg c...@df7cb.de to replace placeholder %s by correct string. AFAIK this won't have any effect. This change needs to go to through pgtranslation project. -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] deprecating contrib for PGXN
On Tue, 2011-05-17 at 13:45 -0700, Joshua D. Drake wrote: If PGXN moves into .Org infrastructure (which I believe is currently the plan) then yes, contrib should go away. Well, it is not an enough reason to kick contrib off. I am not aware that PGXN is a community driven project, and not aware that it has the same standards that contrib/ has. PGXN cannot replace contrib. It can only be an add-on to contrib. -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] deprecating contrib for PGXN
On Tue, 2011-05-17 at 20:37 -0700, Darren Duncan wrote: Are the individual projects in contrib/ also distributed separately from Pg, on their own release schedules, No. If the only way to get a contrib/ project is bundled with Pg, then the project developers and users don't get the flexibility that they otherwise would have. These types of stuff goes under pgfoundry, for now. -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] Why not install pgstattuple by default?
On Thu, 2011-05-12 at 19:37 -0400, Tom Lane wrote: It should be okay to move, since the -devel subpackage requires the main one. Therefore there is no configuration in which pg_config would be present before and missing after the change. Thanks Tom. I can make this change in next build set. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] Why not install pgstattuple by default?
On Sat, 2011-05-07 at 21:47 -0400, Greg Smith wrote: On 05/06/2011 04:06 PM, Tom Lane wrote: FWIW, I did move pg_config from -devel to the main (really client) postgresql package in Fedora, as of 9.0. That will ensure it's present in either client or server installations. Eventually that packaging will reach RHEL ... We should make sure that the PGDG packages adopt that for 9.1 then, so it starts catching on more. Unless Devrim changed to catch up since I last installed an RPM set, in that 9.0 it's still in the same place: $ rpm -qf /usr/pgsql-9.0/bin/pg_config postgresql90-devel-9.0.2-2PGDG.rhel5 I'm not sure that I can move it to main package in 9.0 package set, I need to make sure that I won't break anything. But it is pretty doable for 9.1. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] JDBC connections to 9.1
On Mon, 2011-04-18 at 16:17 +0200, Bernd Helmle wrote: Hmm, seems it stumbles while reading client_encoding This is probably similar to what I had a couple weeks ago. With today's new minor releases, I get: $ psql psql: invalid connection option client_encoding (I was getting another message before) This is 9.1's psql connecting to 9.1's server. For some reason, psql uses 9.0 client libs, so if I export LD_LIBRARY_PATH, everything works: $ LD_LIBRARY_PATH=/usr/pgsql-9.1/lib psql ... Could it be the same thing? -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] psql 9.1 alpha5: connection pointer is NULL
On Sat, 2011-04-02 at 18:10 -0400, Tom Lane wrote: It could explain Devrim's report if the parameters passed by psql had some problem that was detectable by conninfo_array_parse(). That seems a bit unlikely, but I did think of one possibility: if Devrim was testing 9.1 psql with a 9.0 libpq (perhaps due to an rpath issue) then 9.0 libpq would spit up on client_encoding, which wasn't a legal connection parameter in 9.0. Bingo: LD_LIBRARY_PATH=/usr/pgsql-9.1/lib/ psql -p 5433 worked. Let me fix the rpms. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
[HACKERS] psql 9.1 alpha5: connection pointer is NULL
I'm getting the following message after upgrading to Alpha5 on my Fedora 14 box: $ psql -p 5433 psql: connection pointer is NULL which comes from libpq. Server is running, and I can connect it to via 9.0's psql. This is a regular RPM build. Am I doing something wrong, or? Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] 2nd Level Buffer Cache
On Tue, 2011-03-22 at 15:53 -0400, Robert Haas wrote: To be honest, I'm mostly just reporting what I've heard Greg Smith say on this topic. I don't have any machine with that kind of RAM. I thought we had a machine for hackers who want to do performance testing. Mark? -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] GSoC 2011 - Mentors? Projects?
On Mon, 2011-03-14 at 16:08 +, Dave Page wrote: Please count me in as a mentor for a GUI project. It is an open source dashboard for PostgreSQL DBAs, called ADJ Dashboard. I can't find any info on that via Google. URL please? Erdinc said that he will setup a web page for this, and let the list know. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] Flex output missing from 9.1a4 tarballs?
On Fri, 2011-03-11 at 11:40 -0500, Robert Haas wrote: My vote would be forget about building installers for alpha4 and instead wrap an alpha5 next week. If you need more votes for this: +1 from me. I'd like to wrap the packages before I leave for PGEast. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] Flex output missing from 9.1a4 tarballs?
On Tue, 2011-03-15 at 22:00 -0400, Tom Lane wrote: My only hesitation about this is that it seems like sync rep and collation support are both still pretty broken. Should we just not worry about that for alpha? FWIW, collations are probably still several days away from being noticeably less broken than they were in alpha4. I have mixed feelings about whether an alpha5 right now is useful. Fair enough. Looks like we will skip next week, too. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] initdb -A ident, with params
On Mon, 2011-03-14 at 10:28 +0100, Magnus Hagander wrote: In looking at the peer patch, I notice that initdb still supports things like -A ident map=foo, but it *only* supports this for ident, and nothing else. I'm pretty sure this is a leftover from the ident sameuser days, so that things like the RPM install could set it properly. Since this is not needed any more, I propose we take that out and make ident work the same way as any other authentication methods. At some point we might want to extend initdb to support any parameters (with validation, of course), but that's a much bigger thing. Just removing the (undocumented, btw) special case would make things more consistent. Thoughts? RPMs don't need it anymore, so +1 for removing. -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] GSoC 2011 - Mentors? Projects?
Hi Selena, On Mon, 2011-03-07 at 22:44 -0800, Selena Deckelmann wrote: PostgreSQL is applying for GSoC again this year. We're looking for: * Mentors * Project ideas Would you like to mentor? Please let me know! Our application closes on Friday, so please contact me *before* Friday. Please count me in as a mentor for a GUI project. It is an open source dashboard for PostgreSQL DBAs, called ADJ Dashboard. Erdinc (I CC'ed him) is/will be working on the project. This is my first touch with GSoC, please let me know if I'm missing anything. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] Flex output missing from 9.1a4 tarballs?
On Fri, 2011-03-11 at 17:45 +0200, Heikki Linnakangas wrote: On 11.03.2011 17:41, Dave Page wrote: Looks like we're missing the pre-build output from the tarball. Yes. Tom spotted and fixed this yesterday: I believe we need an alpha5 for post-alpha-4 fixes, including syncrep ones. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] Alpha4 release blockers (was Re: wrapping up this CommitFest)
On Mon, 2011-03-07 at 11:00 -0800, Josh Berkus wrote: At the risk of hijacking this thread to talk about the subject of this thread, when are we going to cut alpha4? Any reason not to release it this week, like Thursday? Let's release it before PGEast, please -- I will be there, and won't be able to spend time on packaging. -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] using a lot of maintenance_work_mem
On Wed, 2011-02-16 at 23:24 +0200, Peter Eisentraut wrote: But before expending time on that, I'd want to see some evidence that it's actually helpful for production situations. I'm a bit dubious that you're going to gain much here. If you want to build an index on a 500GB table and you have 1TB RAM, then being able to use 1GB maintenance_work_mem can only be good, no? That would also probably speed up Slony (or similar) replication engines in initial replication phase. I know that I had to wait a lot while creating big indexes on a machine which had enough ram. -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
[HACKERS] Cannot *start* server because of a typo in pg_hba.conf
Yesterday I spent about half an hour to dig an issue on my laptop -- 9.0 instance did not start, and there were nothing in the logs. Eventually I straced postmaster on start, and noticed an extra char in the pg_hba.conf, which caused postmaster not to start. Is it possible to drop something to (startup) log file and mention about the syntax error in hba file? (FWIW, I saw the same issue in a Greenplum 4.0.3 instance 2 months before or so.) -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] Cannot *start* server because of a typo in pg_hba.conf
On Sun, 2011-02-20 at 10:39 -0500, Tom Lane wrote: Is it possible to drop something to (startup) log file and mention about the syntax error in hba file? That information would certainly be logged somewhere. Maybe you looked in the wrong log file? Or you're using one of those configurations where early output to stderr goes to /dev/null? I tried to start postmaster with: * pg_ctl -D data start * postmaster -D data * pg_ctl -D data -l logfile start None of them logged anything to anywhere. You can reproduce it on your machine, too. -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] Cannot *start* server because of a typo in pg_hba.conf
On Sun, 2011-02-20 at 12:45 -0500, Tom Lane wrote: None of them logged anything to anywhere. You can reproduce it on your machine, too. No, I can't. I get something like this on stderr: LOG: invalid connection type zlocal Err, please try putting an extra char before the first comment line, like: w# PostgreSQL Client Authentication Configuration File -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] Debian readline/libedit breakage
On Mon, 2011-02-14 at 13:52 +0100, Cédric Villemain wrote: Consider providing debian packages at debian.postgresql.org apt.postgresql.org, please. :) -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] Re: Vacuum of newly activated 8.3.12 standby receives warnings page xxx is uninitialized --- fixing
On Fri, 2010-12-31 at 11:11 +1300, Mark Kirkwood wrote: I note that this uninitialized pages with standbys has cropped up from time to time - I wonder if in most/all the cases folk were using Pitrtools? I deployed Pitrtools a lot when I was working for CMD, and I haven't seen any issues with that. It is just a wrapper, nothing else... Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
[HACKERS] When will 8.1 be EOLed?
IIRC we announced that we will EOL 8.1 in 2010 -- given that we are now in December, will it be done soon? (As a packager, I'll be happy to drop is ASAP, so that I can use those VMs for new OSes). Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] pgxs docdir question
On Mon, 2010-10-11 at 13:30 -0400, Tom Lane wrote: What does pg_config --docdir report? $ /usr/pgsql-9.0/bin/pg_config --docdir /usr/share/doc/pgsql I was expecting it to be somewhere in /usr/pgsql-9.0, where it is the --prefix. Am I wrong? Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] pgxs docdir question
On Tue, 2010-10-12 at 09:36 -0400, Tom Lane wrote: I think docdir is separate from the regular prefix. Try specifying --docdir to configure. Thanks, I'll test (not now, but soon). Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] pgxs docdir question
On Sun, 2010-09-19 at 17:36 -0400, Tom Lane wrote: While building 3rd party RPMs using PGXS, even if I specify docdir in Makefile, README.* files are installed to this directory, which breaks parallel installation path as of 9.0+ Maybe you need to fool with MODULEDIR. See http://archives.postgresql.org/pgsql-committers/2010-01/msg00025.php Has anyone used this successfully? It did not work for me, and I'm hacking spec files in order to install docs under somewhere else. -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] pg_filedump for 9.0?
On Tue, 2010-10-05 at 10:12 -0400, Tom Lane wrote: Does anybody know if pg_filedump for PostgreSQL 9.0 already exists? It's on my todo list to look at that, but right now I would think that it doesn't need any changes since 8.4. Is there a test suite or so ? I can give it a try while building RPMs. -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] pgadmin3_90 package
On Sun, 2010-10-03 at 23:46 +0900, Tomoaki Sato wrote: I try to install pgAdmin III using Yum on CentOS 5.5 (x86_64), but it seems pgadmin3_90 package architecture is i386 in Yum repository. There was a build problem on 64-bit build on RHEL5, so I pushed 32-bit version. -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
[HACKERS] A small update for postgresql.conf.sample
Attached is a small patch that adds a few comments for the settings that require restart. Applicable for 9.0+. Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index d31f1a1..b6a8f91 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -151,6 +151,7 @@ # - Settings - #wal_level = minimal # minimal, archive, or hot_standby + # (change requires restart) #fsync = on# turns forced synchronization on or off #synchronous_commit = on # immediate fsync at commit #wal_sync_method = fsync # the default is the first option @@ -186,6 +187,7 @@ # - Streaming Replication - #max_wal_senders = 0 # max number of walsender processes +# (change requires restart) #wal_sender_delay = 200ms # walsender cycle time, 1-1 milliseconds #wal_keep_segments = 0 # in logfile segments, 16MB each; 0 disables #vacuum_defer_cleanup_age = 0 # number of xacts by which cleanup is delayed @@ -193,6 +195,7 @@ # - Standby Servers - #hot_standby = off # on allows queries during recovery + # (change requires restart) #max_standby_archive_delay = 30s # max delay before canceling queries # when reading WAL from archive; # -1 allows indefinite delay @@ -392,7 +395,7 @@ #track_activities = on #track_counts = on #track_functions = none # none, pl, all -#track_activity_query_size = 1024 +#track_activity_query_size = 1024 # (change requires restart) #update_process_title = on #stats_temp_directory = 'pg_stat_tmp' @@ -416,6 +419,7 @@ # actions running at least this number # of milliseconds. #autovacuum_max_workers = 3 # max number of autovacuum subprocesses + # (change requires restart) #autovacuum_naptime = 1min # time between autovacuum runs #autovacuum_vacuum_threshold = 50 # min number of row updates before # vacuum signature.asc Description: This is a digitally signed message part
Re: [HACKERS] A small update for postgresql.conf.sample
On Mon, 2010-09-27 at 09:40 -0400, Robert Haas wrote: Actually, I don't see any reason why not to backpatch it. I was wondering if it would cause package management headaches for people who had already modified their postgresql.conf. We don't overwrite .conf files during upgrades. -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
[HACKERS] pgxs docdir question
Where does PGXS makefile get /usr/share/doc/pgsql/contrib directory from? While building 3rd party RPMs using PGXS, even if I specify docdir in Makefile, README.* files are installed to this directory, which breaks parallel installation path as of 9.0+ Speficially, I want to install READMEs under /usr/pgsql-9.0/share/contrib for 9.0. How do I do that? Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] psycopg and two phase commit
On Sat, 2010-09-18 at 18:01 +0200, Pavel Stehule wrote: who is psycopg maintainer, please? Why don't you ask it to psycopg2 mailing list? http://www.initd.org/ (I know, mailing lists are down nowadays. See website) -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] upcoming wraps
On Mon, 2010-08-30 at 11:19 +0300, Peter Eisentraut wrote: Peter muttered something about doing that this week. The major blocker is preparing the release notes. If someone has time for that ... Peter, do you have a time estimation about this? I'd like to build 9.1 alpha1 RPMs before we release 9.0, so that I can test parallel installation with RPMs. Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] Version Numbering
+1 for Tom's post. -- 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 20.Ağu.2010 tarihinde 21:40 saatinde, Tom Lane t...@sss.pgh.pa.us şunları yazdı: David E. Wheeler da...@kineticode.com writes: A while ago, I asked if .0 releases could be versioned with three digits instead of two. That is, it would be 8.4.0 instead of 8.4. We've been doing that for some time, no? A quick look at the CVS history shows that 8.0.0 and up were tagged that way. This is to make the format consistent with maintenance releases (8.4.1, etc.). I thought this was generally agreed upon, but maybe not, because I just went to build the latest 9.0 beta and saw that the version number is 9.0beta4. .0 is for releases, not betas. I see no need for an extra number in beta versions. regards, tom lane -- 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: [HACKERS] Version Numbering
20.Ağu.2010 tarihinde 21:47 saatinde, David Fetter da...@fetter.org şunları yazdı: The current system give people the completely false impression that 7.0 and 7.4 are somehow similar. Well, I do find PostgreSQL versioning policy very good, which is pretty much similar to Linux. For me, 7.x are similar. Remember why we jumped from 7.5 to 8.0 or from 8.5 to 9.0. Cheers, -- 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] Version Numbering
20.Ağu.2010 tarihinde 23:03 saatinde, Josh Berkus j...@agliodbs.com şunları yazdı: The betas are pre-.0. Maybe we should have 9.0.(-3) instead. Or 8.9.97? ;-) This is pretty much what Fedora does actually :-) -- 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] Drop one-argument string_agg? (was Re: [BUGS] string_agg delimiter having no effect with order by)
04.Ağu.2010 tarihinde 22:44 saatinde, Josh Berkus j...@agliodbs.com şunları yazdı: I'm OK with forcing an initDB for RC1. I think beta5 will be a better choice than RC 1 here. -- 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
[HACKERS] Keeping separate WAL segments for each database
I talked to Sybase people about their latest technologies. Many features that shipped with their latest ASE 15.5 product has been in PostgreSQL since many years (like functional indexes, etc). :) One of the things that interested me was parallel recovery feature. They said that they are keeping separate xlogs for each database, which speeds ups recovery in case of a crash. It also would increase performance, since we could write xlogs to separate disks. Is that doable for PostgreSQL, too? -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] PG 9.1 tentative timeline
On Fri, 2010-06-11 at 19:56 +0800, Pr, Solaiyappan (NSN - IN/Bangalore) wrote: Also, is there any synchronous replication patch planned for the PostgreSQL 9.0 version? Cybertec announced new version of Cybercluster, which includes sync replication -- I haven't tested it though. -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] pg_upgrade code questions
On Thu, 2010-05-13 at 17:19 +0200, Magnus Hagander wrote: I say remove it. On all accounts. There's a fork of postgres for EDB AS, shouldn't there be a fork of pg_upgrade the same way, if it requires special code? The code in community postgresql certainly shouldn't have any EDB AS code in it. Agreed. -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] pg_upgrade code questions
On Thu, 2010-05-13 at 15:13 +0900, Takahiro Itagaki wrote: 4. EDB_NATIVE_LANG Of course it is commented out with #ifdef, but do we have codes for EDB in core? I was about to raise similar thing, for the documentation: http://developer.postgresql.org/pgdocs/postgres/pgupgrade.html This includes some references to EDB AS, which should be removed from PostgreSQL official documentation, IMHO. Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] RPM script bug #5430
Tom forwarded it to RPM list. I'll take care of it soon. On Tue, 2010-04-20 at 05:51 -0700, Jamie Strachan wrote: Hello, I posted Bug #5430, initdb script fails due to permissions of /usr/share/pgsql/ I would be happy to fix this bug and submit a patch. However, I don't seem to see the RPM scripts in the source tree! Do they live somewhere else? Please reply by email, as I haven't subscribed to this list. Thanks, Jamie Strachan -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] make check hangs in alpha5
On Sun, 2010-04-04 at 12:19 -0400, Tom Lane wrote: Hitoshi Harada umi.tan...@gmail.com writes: I cannot figure out at all what is wrong. Have any idea? Since nobody else is reporting this, it seems like it must be either something messed up about your system, or something wrong with your copy of the PG sources. The only times that I see this issue over the last years is when I build PostgreSQL RPMs in the xen-based virtual machines. It is rare, and it happens when there are 10+ parallel builds. ...I'm pretty sure that it is related to the available resources during build time... -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [HACKERS] Alpha release this week?
On Wed, 2010-03-31 at 10:46 -0700, Josh Berkus wrote: Not with any amount of testing as we'd normally give any build before releasing it anyway. I can certainly stuff a tarball into the new build machine and see what comes out the next morning. That would be good enough for Saturday; we're going to test it after all. Let me know which snapshot day you grab, so we can have the same snapshot-day for Windows and other platforms. FWIW, I can release RPMs based on the same snapshot in an hour after I get the tarball. -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
[HACKERS] Updated Turkish stopwords list for Tsearch2
Hi, Attached is updated Turkish stopword list for Tsearch2, against 8.4 and HEAD. Please apply. Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz Index: src/backend/snowball/stopwords/turkish.stop === RCS file: /projects/cvsroot/pgsql/src/backend/snowball/stopwords/turkish.stop,v retrieving revision 1.1 diff -u -r1.1 turkish.stop --- src/backend/snowball/stopwords/turkish.stop 7 Sep 2007 14:46:43 - 1.1 +++ src/backend/snowball/stopwords/turkish.stop 22 Mar 2010 12:20:33 - @@ -1,53 +1,224 @@ +a acaba +altı ama +ancak +artık +asla aslında az +b +bana +bazen bazı +bazıları +bazısı belki +ben +beni +benim +beş +bile +bir +birçoğu +birçok +birçokları biri +birisi birkaç +birkaçı birşey +birşeyi biz +bize +bizi +bizim +böyle +böylece bu +buna +bunda +bundan +bunu +bunun +burada +bütün +c +ç +çoğu +çoğuna +çoğunu çok çünkü +d da daha de -defa +değil +demek +diğer +diğeri +diğerleri diye -eğer +dokuz +dolayı +dört +e +elbette en +f +fakat +falan +felan +filan +g +gene gibi +ğ +h +hâlâ +hangi +hangisi +hani +hatta hem +henüz hep hepsi +hepsine +hepsini her +her biri +herkes +herkese +herkesi hiç +hiç kimse +hiçbiri +hiçbirine +hiçbirini +ı +i için +içinde +iki ile ise -kez +işte +j +k +kaç +kadar +kendi +kendine +kendini ki kim +kime +kimi +kimin +kimisi +l +m +madem mı +mı +mi +mu mu mü +mü +n nasıl ne +ne kadar +ne zaman neden +nedir nerde nerede +nereden nereye +nesi +neyse niçin niye o -sanki -şey +on +ona +ondan +onlar +onlara +onlardan +onların +onların +onu +onun +orada +oysa +oysaki +ö +öbürü +ön +önce +ötürü +öyle +p +r +rağmen +s +sana +sekiz +sen +senden +seni +senin siz +sizden +size +sizi +sizin +son +sonra +ş +şayet +şey +şeyden +şeye +şeyi +şeyler +şimdi +şöyle şu +şuna +şunda +şundan +şunlar +şunu +şunun +t +tabi +tamam tüm +tümü +u +ü +üç +üzere +v +var ve veya +veyahut +y ya +ya da yani +yedi +yerine +yine +yoksa +z +zaten +zira signature.asc Description: This is a digitally signed message part