Re: [HACKERS] extension build issue with PostgreSQL 10 on Centos6

[Devrim Gündüz]

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

[Devrim Gündüz]

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

[Devrim Gündüz]

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

[Devrim Gündüz]

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

[Devrim Gündüz]

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

[Devrim Gündüz]

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

[Devrim Gündüz]

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

[Devrim Gündüz]

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

[Devrim Gündüz]

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

[Devrim Gündüz]

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

[Devrim Gündüz]

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

[Devrim Gündüz]

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

[Devrim Gündüz]

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?

[Devrim Gündüz]

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

[Devrim Gündüz]

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

[Devrim Gündüz]

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

[Devrim Gündüz]

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

[Devrim Gündüz]

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

[Devrim Gündüz]

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

[Devrim Gündüz]

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

[Devrim Gündüz]

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 Haas  
wrote:
>> 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

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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

[Devrim Gündüz]

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

[Devrim Gündüz]

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

[Devrim Gündüz]

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?

[Devrim Gündüz]

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

[Devrim Gündüz]

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

[Devrim Gündüz]

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

[Devrim Gündüz]

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

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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?

[Devrim GÜNDÜZ]

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

[Devrim Gündüz]

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

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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.

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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?

[Devrim GÜNDÜZ]

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?

[Devrim GÜNDÜZ]

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?

[Devrim GÜNDÜZ]

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?

[Devrim GÜNDÜZ]

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?

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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 ?

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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?

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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.

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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?

[Devrim GÜNDÜZ]

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?

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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?

[Devrim GÜNDÜZ]

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?

[Devrim GÜNDÜZ]

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?

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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?

[Devrim GÜNDÜZ]

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?

[Devrim GÜNDÜZ]

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)

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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?

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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?

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

+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

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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)

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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?

[Devrim GÜNDÜZ]

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

[Devrim GÜNDÜZ]

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