Re: [GENERAL] CentOS initd Script

2012-09-12 Thread Devrim GÜNDÜZ
it there, btw, like inefficiency of parsing postgresql.conf via shell script to get the port., etc. FWIW, Fedora switched to systemd, RHEL 7 will be switching to systemd, too, so I'm not that much excited about changing the current behavior. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer

Re: [GENERAL] 9.0 to 9.2 pg_upgrade pain due to collation mismatch

2012-09-12 Thread Devrim GÜNDÜZ
in the latest 9.0.9 packages. 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

Re: [GENERAL] Where do I get pgAdmin 1.16 for openSuSE?

2012-09-11 Thread Devrim GÜNDÜZ
: https://build.opensuse.org/ You may want to submit 1.16 there, that would also help many people. 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

Re: [GENERAL] SEPostgreSQL alive?

2012-09-04 Thread Devrim GÜNDÜZ
/SEPostgreSQL_Introduction Is anyone actively using/developing SEPostgreSQL? It was merged to contrib/sepgsql. 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

Re: [GENERAL] PostgreSQL 8.4 download for RHEL6

2012-06-05 Thread Devrim GÜNDÜZ
it from RPMs? RHEL 6 is already shipping with PostgreSQL 8.4, and I suggest you to use 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

Re: [GENERAL] Extreme PostgreSQL?

2012-05-23 Thread Devrim GÜNDÜZ
at pgsql-performance archives. You will see lots of posts there (or just search for posts from Greg Smith, it will be a shortcut to the solution) Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer

Re: [GENERAL] dblink.sql and Linux

2012-05-14 Thread Devrim GÜNDÜZ
Hi, On Mon, 2012-05-14 at 18:05 -0700, Mike Christensen wrote: I've become a big fan of DBLink lately, but I'm curious where it lives on Linux installations. Which Linux? Which package/installer? It mostly ships with the -contrib package. -- Devrim GÜNDÜZ Principal Systems Engineer

Re: [GENERAL] yum repo issue

2012-04-22 Thread Devrim GÜNDÜZ
(pgdg91) Requires: mx mx is in EPEL repo actually, but I copied it to our repository to avoid extra dependencies. You can update your cache with yum makecache Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat

Re: [GENERAL] compilation info without pg_config

2012-03-26 Thread Devrim GÜNDÜZ
: pg_config is put into the -devel package. RPMs have it in main package over the last few months. -- 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

Re: [GENERAL] yum repository packages 9.0 and 9.1 libpq conflict

2012-03-15 Thread Devrim GÜNDÜZ
here: http://wiki.pgrpms.org/ticket/77 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

Re: [GENERAL] what Linux to run

2012-03-04 Thread Devrim GÜNDÜZ
. -- 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

Re: [GENERAL] Error installing plpythonu in 9.1

2012-02-28 Thread Devrim GÜNDÜZ
subpackage. Please install -contrib package until I push the new set of RPMs. Created http://wiki.pgrpms.org/ticket/76 if you want to keep track of the bug. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat

Re: [GENERAL] psql: invalid connection option client_encoding

2012-02-28 Thread Devrim GÜNDÜZ
9.1.3-1PGDG.rhel6 @pgdg91 postgresql91-plpython.x86_64 9.1.3-1PGDG.rhel6 @pgdg91 postgresql91-server.x86_649.1.3-1PGDG.rhel6 @pgdg91 There is this thread: http://archives.postgresql.org/pgsql-admin/2011-09/msg00101.php My ldconfig output i -- Devrim GÜNDÜZ

Re: [GENERAL] Error installing postgresq91-python package

2012-02-28 Thread Devrim GÜNDÜZ
? I'd probably add a Conflicts: line, so that the error would appear before the installation. Is that what you want? Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim

Re: [GENERAL] postgresql90-server package for RHEL5

2012-02-15 Thread Devrim GÜNDÜZ
/. (*) http://yum.postgresql.org/rpmchart.php I think it's better to say RHEL/CentOS/Scientific Linux 5 - x86_64 /9.1/redhat/rhel-5-x86_64/repoview Good catch. Thanks, fixed. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL

Re: [GENERAL] postgresql90-server package for RHEL5

2012-02-15 Thread Devrim GÜNDÜZ
that I got about this. Magnus was pestering me well enough for changing it. Let me try to do something before the next minor update releases. It is just a matter of changing a python kid template. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com

Re: [GENERAL] postgresql90-server package for RHEL5

2012-02-15 Thread Devrim GÜNDÜZ
only the last 20 packages that I added to the repo. That's all. Correct list is http://yum.postgresql.org/9.0/redhat/rhel-5-x86_64/repoview/postgresql90-server.html . Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant

Re: [GENERAL] PGAdmin3 for CentOS-5_186_64 and pgdg91

2012-01-11 Thread Devrim GÜNDÜZ
on stock RHEL 5 x86_64. That's why I pushed 32-bit version to the repository, in case it works :( 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

Re: [GENERAL] Dated Version of PostgreSQL

2011-12-30 Thread Devrim GÜNDÜZ
, -- 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

Re: [GENERAL] Dated Version of PostgreSQL

2011-12-30 Thread Devrim GÜNDÜZ
postgresql91* is enough. 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

Re: [GENERAL] psql error: psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams

2011-12-28 Thread Devrim GÜNDÜZ
@CentOS-60-32-minimal ~]# su - postgres -bash-4.1$ psql msdi psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams -bash-4.1$ Are there any os-supplied RPMs? What is the output of: rpm -qa|grep postgresql Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB

Re: [GENERAL] Re: psql error: psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams

2011-12-28 Thread Devrim GÜNDÜZ
On Wed, 2011-12-28 at 02:30 -0800, hosuresh wrote: when i run the command rpm -qa | grep postgresql-9.0 Its not dispalying anything... I did not say postgresql-9.0 -- I said rpm -qa|grep postgresql Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http

Re: [GENERAL] Cannot connect to 2nd cluster database remotely

2011-12-21 Thread Devrim GÜNDÜZ
or not. 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

Re: [GENERAL] Problem installing PG9.1 using yum

2011-12-12 Thread Devrim GÜNDÜZ
On Mon, 2011-12-12 at 16:26 +0100, Wojciech Strzałka wrote: Thanks Devrim - it's a little better now but still not perfect :) There is some problem with libpq messages. Please also remove postgresql90-libs.i386 Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http

Re: [GENERAL] Problem installing PG9.1 using yum

2011-12-11 Thread Devrim GÜNDÜZ
On Sun, 2011-12-11 at 09:17 -0800, wstrzalka wrote: Error: Package postgresql90-devel needs postgresql90 = 9.0.1-4PGDG.rhel5, this is not available. Please remove postgresql90-devel.i386 prior to installation. We don't push -devel.i386 packages to x86_64 repos anymore. Regards, -- Devrim

Re: [GENERAL] Is *.projects.postgresql.org offline?

2011-11-07 Thread Devrim GÜNDÜZ
On Mon, 2011-11-07 at 17:10 -0200, Leonardo Carneiro wrote: Is the pages hosted at http://projects.postgresql.org/ offline? I can't access any of them. http://archives.postgresql.org/pgsql-www/2011-11/msg00016.php -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http

Re: [GENERAL] Why is there no 8.3.16 rpm with _id ?

2011-11-03 Thread Devrim GÜNDÜZ
/repoview/ 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

Re: [GENERAL] Why is there no 8.3.16 rpm with _id ?

2011-10-30 Thread Devrim GÜNDÜZ
/repoview/ Is there any reason for this, and will there be any newer versions built with integer datetimes? I have no intention to build the -id packages again, given the lack of request (first request since 8.3.11...). You can build your own packages quite easily, though. -- Devrim GÜNDÜZ

Re: [GENERAL] Anyone using the solaris 11 precompiled binaries on opensolaris snv_134

2011-10-22 Thread Devrim GÜNDÜZ
snv_134 machines have different libsockets? Thanks for your insight Thomas -- 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

Re: [GENERAL] I need to load mysql dump to postgres...

2011-10-13 Thread Devrim GÜNDÜZ
work fine, you don't need Sun^H^H^HOracle Java. 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

Re: [GENERAL] I need to load mysql dump to postgres...

2011-10-12 Thread Devrim GÜNDÜZ
, there are also RPMs of this in http://yum.postgresql.org -- package name ise mysqlmigrator. 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

Re: [GENERAL] Updating 9.0.4 -- 9.1.1: How best to ???

2011-10-02 Thread Devrim GÜNDÜZ
? Fedora will release 9.1 in F-16. Fedora 15 won't have 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

Re: [GENERAL] how to install 9.1 on non-graphical server?

2011-10-01 Thread Devrim GÜNDÜZ
On Fri, 2011-09-23 at 02:46 +0200, Andreas wrote: is there a way to install the EnterpriseDB V9.1 release on a server without X-Windows? You can run the installer with --mode text parameter. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com

Re: [GENERAL] Is 9.1 considered more stable/robust than 9.0.4 ?

2011-09-22 Thread Devrim GÜNDÜZ
http://blog.2ndquadrant.com/en/2011/09/limitations-removed-in-postgre.html On Thu, 2011-09-22 at 02:36 -0500, Abraham, Danny wrote: Thanks Danny -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified

Re: [GENERAL] upgrade postgres to 8.4.8, centos 5.3

2011-09-21 Thread Devrim GÜNDÜZ
/reporpms/8.4/pgdg-centos-8.4-2.noarch.rpm That will update the repo URL. Now you can run yum update postgresql* to update postgresql packages. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer

Re: [GENERAL] pg-9.1 for fedora 15 available?

2011-09-21 Thread Devrim GÜNDÜZ
/, the only f15 directory I see is fedora-15-x86_64/. Am I doing something wrong, or is f15 32-bit not supported, or is something borked on the site, or...? -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat

Re: [GENERAL] upgrade postgres to 8.4.8, centos 5.3

2011-09-20 Thread Devrim GÜNDÜZ
On Tue, 2011-09-20 at 07:49 -0700, MirrorX wrote: do u mean something like that? - yum list | grep *PGDG*rpm or i shouldn't search in the yum repos? What is the output of: cat /etc/yum.repos.d/pgdg*|grep baseurl Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http

Re: [GENERAL] Pgpool outdated spec

2011-09-12 Thread Devrim GÜNDÜZ
, however I'm waiting for 9.1.0 to be releases first. I will release packages before Thursday. 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

Re: [GENERAL] Has Pg 9.1.0 been released today?

2011-09-12 Thread Devrim GÜNDÜZ
with no warranty ;) -- 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

Re: [GENERAL] Has Pg 9.1.0 been released today?

2011-09-12 Thread Devrim GÜNDÜZ
On Tue, 2011-09-13 at 02:04 +1200, Gavin Flower wrote: PostgreSQL source code ships with no warranty ;) You mean I don't get my money back if I don't like it??? :-) :) FWIW, 9.1.0 was just officially announced. Enjoy! -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http

Re: [GENERAL] 9.0, 9.1 RPM based parallel execution?

2011-09-12 Thread Devrim GÜNDÜZ
between 910 and 920, so that they will be picked up. rpm -q --scripts postgresql90 will give you the scripts that we run for alternatives. Just change 900 with 911 or so. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı

Re: [GENERAL] 8.4 - 9.0 upgrade difficulties

2011-09-08 Thread Devrim GÜNDÜZ
are using CentOS 5, you may not be able to install 8.4 and 9.0 in parallel. I don't have any intention to break current 8.4 RPMs in CentOS 5, and let them to be installed in parallel, because it is the most used package set among all RPMs. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer

Re: [GENERAL] CentOS 6 - www.pgrpms.org - SELinuxi dn

2011-09-04 Thread Devrim GÜNDÜZ
all 3rd party repos do such things. , ...and I'd package libevent 2.0.X for RHEL 6, if I was in charge of it. -HTH. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim

Re: [GENERAL] pgAdmin3 not working with Gnome3

2011-09-02 Thread Devrim GÜNDÜZ
On Fri, 2011-09-02 at 09:30 +0200, Guillaume Lelarge wrote: I guess the bug can be fixed as: If the bug is in pgAdmin3... Could not reproduce any of those issues on Fedora 15. -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı

Re: [GENERAL] Postgresql 9.0.4 SRPMS

2011-08-26 Thread Devrim GÜNDÜZ
On Fri, 2011-08-26 at 13:33 +0100, Brett Maton wrote: Could anyone tell me where to find postgresql 9.0.4 SRPM's? I need to build some RPM's for CentOS 6 - 32 bit. http://yum.postgresql.org/srpms/9.0 Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http

Re: [GENERAL] How to install PGCRYPTO in PostgreSQL9

2011-08-17 Thread Devrim GÜNDÜZ
pgcrypto.sql that comes with the package. If it is the source installation, run make install under contrib/pgcrypto directory. Then again, load pgcrypto.sql to your database. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant

Re: [GENERAL] 9.0 Streaming Replication Problem to two slaves

2011-08-02 Thread Devrim GÜNDÜZ
on slave. So yeah, that could be 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

Re: [GENERAL] PostgreSQL 8.4.8 RPM/SRPM for RHEL4

2011-07-21 Thread Devrim GÜNDÜZ
the changes just never got pushed to the RHEL4 repository? Thanks. -- Justin Pasher -- 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

Re: [GENERAL] Performance Monitoring of PostGRE

2011-07-06 Thread Devrim GÜNDÜZ
On Wed, 2011-07-06 at 14:27 +0530, BangarRaju Vadapalli wrote: We want to monitor the performance of PostGRE database I am not aware of a database called PostGRE. -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat

Re: [GENERAL] failed archive command

2011-07-06 Thread Devrim GÜNDÜZ
of 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

Re: [GENERAL] Preventing OOM kills

2011-05-24 Thread Devrim GÜNDÜZ
' ${PGOPTS} $PGLOG 21 /dev/null 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

Re: [GENERAL] Error compiling sepgsql in PG9.1

2011-05-21 Thread Devrim GÜNDÜZ
in the configure phase. -- 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

Re: [GENERAL] Error compiling sepgsql in PG9.1

2011-05-20 Thread Devrim GÜNDÜZ
, -- 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

Re: [GENERAL] stymied on postgresql upgrade

2011-04-18 Thread Devrim GÜNDÜZ
cannot install PostgreSQL 9.0 and 8.4 with RPMs on the same machine. That functionality is available for RHEL 6 and Fedora 14+. Either upgrade OS, or use sources for one of them. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı

Re: [GENERAL] [ADMIN] Streaming Replication limitations

2011-04-13 Thread Devrim GÜNDÜZ
Hi, On Wed, 2011-04-13 at 23:23 +0530, raghu ram wrote: Is there any limitations to configure streaming replication between different operating systems i.e solaris 64 bit to RHEL 64 bit. It won't work. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http

Re: [GENERAL] RPM for ODBC driver

2011-03-29 Thread Devrim GÜNDÜZ
On Tue, 2011-03-29 at 15:13 -0400, Worgan, Craig (Craig) wrote: I am looking for an RPM to install the ODBC driver for PostgreSQL 9.0.2. did you take a look at http://yum.pgrpms.org/9.0/ ? Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com

Re: [GENERAL] pdf saving into DB vs. saving file location ?

2011-03-23 Thread Devrim GÜNDÜZ
160KB). This question *might* make sense if you were storing 200 new PDFs per day. OS will probably cache the PDFs if you are serving it much enough. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified

Re: [GENERAL] Move From Oracle DB to PostgreSQL DB

2011-03-14 Thread Devrim GÜNDÜZ
port is on the way. and it supports a few more distros IIRC. 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

Re: [GENERAL] mysql 2 pg script...

2011-02-19 Thread Devrim GÜNDÜZ
On Fri, 2011-02-18 at 21:03 -0500, andrew1 wrote: I need to load mysql dump to postgre 8.3 . Is there a script to do that? http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#MySQL Regards, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL

Re: [GENERAL] about PostgreSQL 9.0.3 RPMs

2011-02-09 Thread Devrim GÜNDÜZ
them about 8 hours before. Regards, -- 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

Re: [GENERAL] about PostgreSQL 9.0.3 RPMs

2011-02-08 Thread Devrim GÜNDÜZ
in the current RPM buildfarm that resulted in delay. Regards, -- 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

Re: [GENERAL] yum repo problem

2011-02-01 Thread Devrim GÜNDÜZ
not sure i understand, but not sure it matters, problem solved. I have seen similar issues with old versions of yum, like you are using now :( Glad that it is solved now. -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer

Re: [GENERAL] beginners autovacuum question

2011-01-05 Thread Devrim GÜNDÜZ
not be the exact message, I did not check). 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

[GENERAL] Re: [NOVICE] Loading posgres 9.0 libpq library on Linux versionRed Hat 3.4.6-3

2011-01-03 Thread Devrim GÜNDÜZ
On Mon, 2011-01-03 at 17:23 +0530, Trupti Ghate wrote: I am trying to load the libpq library of PostGreSQL 9.0 version on Linux(Red Hat 3.4.6-3) and it is failing. What is the exact Red Hat release? Please send the output of cat /etc/redhat-release Regards, -- Devrim GÜNDÜZ PostgreSQL

[GENERAL] Re: [NOVICE] Loading posgres 9.0 libpq library on Linux versionRed Hat 3.4.6-3

2011-01-03 Thread Devrim GÜNDÜZ
: http://yum.pgrpms.org/9.0/redhat/rhel-4-x86_64/repoview/letter_p.group.html Grab and install postgresql90-libs for libpq. Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org

Re: [GENERAL] Hot Standby pg_xlog problem

2010-12-14 Thread Devrim GÜNDÜZ
pg_xlog/0001002B (log file 0, segment 43): No such file or directory LOG: invalid checkpoint record I think it was fixed in 9.0.2, which will be released 2 days later. -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http

Re: [GENERAL] postgresql 9 devel rpm

2010-12-13 Thread Devrim GÜNDÜZ
On Tue, 2010-12-14 at 12:38 +0600, AI Rumman wrote: Can anyone tell me please where I can get the postgresql 9 devel rpms? http://yum.pgrpms.org or, directly: http://yum.pgrpms.org/9.0/ Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM

Re: [GENERAL] PostgreSQL 9.0 RPMs for RHEL 6 and Fedora 14 released

2010-12-06 Thread Devrim GÜNDÜZ
, -- 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

Re: [GENERAL] PostgreSQL 9.0 RPMs for RHEL 6 and Fedora 14 released

2010-12-03 Thread Devrim GÜNDÜZ
On Sun, 2010-11-21 at 12:39 +0300, Allan Kamau wrote: I am unable to obtain (using yum) a version of pgAdmin3 that can connect fruitfully to postgreSQL 9.x. My installation reports that the version I do have 1.10.5 is the latest. Should be fixed as of yesterday. Regards, -- Devrim GÜNDÜZ

Re: [GENERAL] PG84 and SELinux

2010-12-02 Thread Devrim GÜNDÜZ
On Wed, 2010-12-01 at 16:54 -0500, Tom Lane wrote: AFAIK, the Red Hat RPMs work out-of-the-box with SELinux; I'm a bit surprised to hear that the PGDG ones don't, because last I heard they use the same file layout. They should -- we are using the same routines for initdb'ing. -- Devrim

Re: [GENERAL] Pg_upgrade question

2010-11-30 Thread Devrim GÜNDÜZ
to a new hardware anyway. 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

Re: [GENERAL] pgadmin story...

2010-11-18 Thread Devrim GÜNDÜZ
On Thu, 2010-11-18 at 16:18 -0500, andrew wrote: I've just read that pgadmin team was hired by some company and the project will be closed... It was a post from 2009. ...and that post was published at Apr 1, 2009 ;) -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified

Re: [GENERAL] postgreSQL-devel 8.3.8

2010-11-15 Thread Devrim GÜNDÜZ
/postgresql-8.3.8-1PGDG.rhel5.i386.rpm 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

[GENERAL] PostgreSQL 9.0 RPMs for RHEL 6 and Fedora 14 released

2010-11-14 Thread Devrim GÜNDÜZ
/fedora-14-x86_64/repoview/ If you find any issues with the repository or packaging, please send an e-mail to me. 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

Re: [GENERAL] PostgreSQL 8.2.3

2010-11-10 Thread Devrim GÜNDÜZ
On Wed, 2010-11-10 at 09:30 -0800, Jason wrote: Is 8.2.3 still available anywhere on the PostgreSQL site? I couldn't find it. Please check ftp-archives.postgresql.org -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http

Re: [GENERAL] server gets slow at certain time

2010-10-29 Thread Devrim GÜNDÜZ
On Fri, 2010-10-29 at 18:24 +0600, AI Rumman wrote: I am using Postgresql 8.1 in 8-cpu cores with 32 gb ram with CestOS 5. snip In addition to what Thom wrote, please note that checkpoints in pre-8.3 negative effect on disk I/O -- you may see spikes during checkpoints. -- Devrim GÜNDÜZ

Re: [GENERAL] Is there a plugin/script for nagios that monitors pitr being up to djavascript:;ate?

2010-10-27 Thread Devrim GÜNDÜZ
passive check results to nagios. We have done it several times. -- 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

Re: [GENERAL] about RPM build options

2010-10-24 Thread Devrim GÜNDÜZ
On Wed, 2010-10-13 at 10:28 -0400, Ray Stell wrote: 1. enable thread safety? --disable-thread-safety is given. Where is the flag given? It is in the RPM spec file. -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http

Re: [GENERAL] Is there a plugin/script for nagios that monitors pitr being up to djavascript:;ate?

2010-10-22 Thread Devrim GÜNDÜZ
/pitrtools/ 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

Re: [GENERAL] pgcluster

2010-10-14 Thread Devrim GÜNDÜZ
;) -- 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

Re: [GENERAL] about RPM build options

2010-10-13 Thread Devrim GÜNDÜZ
error, and fixed in SVN. I will push a new set soon. 2. enable dtrace? --enable-dtrace is not given. I want to give --enable-dtrace, but is there any reason not to give it? I did not include it in PGDG RPMs for various reasons in the past. You may want to recompile srpm for that. -- Devrim

Re: [GENERAL] queriing the version of libpq

2010-10-07 Thread Devrim GÜNDÜZ
On Thu, 2010-10-07 at 12:23 +0300, Peter Eisentraut wrote: This is really something that psycopg2 should work out for you. I suggest you take up a discussion on this on their mailing list. ...which is down over the last 3 weeks or so: http://www.initd.org/ -- Devrim GÜNDÜZ PostgreSQL

Re: [GENERAL] VACUUM FULL for performance

2010-10-07 Thread Devrim GÜNDÜZ
On Thu, 2010-10-07 at 17:38 +0600, AI Rumman wrote: MayVACUUM FULL on a table improve perfromance of the system? No, it will make things worse. -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim

Re: [ADMIN] [GENERAL] Data Not replicating

2010-10-05 Thread Devrim GÜNDÜZ
On Tue, 2010-10-05 at 11:03 +0530, Vishnu S. wrote: Yes. I have written a script file like the following. include preamble.sk; init cluster (id=1, comment='hostname=10.2.26.53 port=5432'); It does not give me the $CLUSTER_NAME information. -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant

Re: [GENERAL] Data Not replicating

2010-10-04 Thread Devrim GÜNDÜZ
On Tue, 2010-10-05 at 10:19 +0530, Vishnu S. wrote: LOG: unexpected EOF on client connection ERROR: schema _testcluster does not exist at character 30 Did you run slonik_init_cluster? -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository

Re: [GENERAL] rotate psql output

2010-09-30 Thread Devrim GÜNDÜZ
'. Is this possible? psql -x ? 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

Re: [GENERAL] pgcluster

2010-09-27 Thread Devrim GÜNDÜZ
in pgreplicate debug: PGRread_query():unexpected EOF PGCluster is no longer developer AFAIK, so you'd better consider testing Postgres-XC: http://postgres-xc.sourceforge.net/ Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository

Re: [GENERAL] pg_filedump binary for CentOS

2010-09-27 Thread Devrim GÜNDÜZ
in the packages. Looks like package was lost during transition. I am rebuilding it, and I'll let you know when I upload it. Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org

Re: [GENERAL] pg_filedump binary for CentOS

2010-09-27 Thread Devrim GÜNDÜZ
in the packages. They are ready: http://yum.pgrpms.org/8.3/redhat/rhel-5-x86_64/repoview/pg_filedump.html http://yum.pgrpms.org/8.3/redhat/rhel-5.0-i386/repoview/pg_filedump.html -HTH Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository

Re: [GENERAL] upgrade postgresql from 8.4.x to 8.4.4

2010-09-09 Thread Devrim GÜNDÜZ
Right. A restart is enough. -- 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 09.Eyl.2010 tarihinde 22:44 saatinde, Chris Barnes

Re: [GENERAL] On-disk size of db increased after restore

2010-09-07 Thread Devrim GÜNDÜZ
For the records, this patch fixed my issue. Just a quick note for the archives/regular users: The client machine that runs pg_dump also needs this patch. Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community

Re: [GENERAL] FC13 RPMs for 9.0 - on postgresql.org ftp, but not in yum repo?

2010-09-06 Thread Devrim GÜNDÜZ
/binary/v9.0rc1/linux/rpms/fedora/fedora-13-x86_64/ but not in the Yum repo on pgsqlrpms.org: http://yum.pgsqlrpms.org/9.0/fedora/ The packages in FTP site are here: http://yum.pgrpms.org Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM

Re: [GENERAL] FC13 RPMs for 9.0 - on postgresql.org ftp, but not in yum repo?

2010-09-06 Thread Devrim GÜNDÜZ
On Mon, 2010-09-06 at 15:53 +0800, Craig Ringer wrote: ... so if yum.pgrpms.org is the new official host. It is not :) Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org

Re: [GENERAL] On-disk size of db increased after restore

2010-09-04 Thread Devrim GÜNDÜZ
or not. As a packager, I am available for new releases after 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

Re: [GENERAL] On-disk size of db increased after restore

2010-09-03 Thread Devrim GÜNDÜZ
custom autovac settings only to that table. This is 8.4.4 btw... So, what should I do now? 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

Re: [GENERAL] On-disk size of db increased after restore

2010-09-03 Thread Devrim GÜNDÜZ
sense to me in here. 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

Re: [GENERAL] On-disk size of db increased after restore

2010-09-01 Thread Devrim GÜNDÜZ
On Tue, 2010-08-31 at 18:08 -0600, Scott Marlowe wrote: ny chance you've restored to different dbs and have two copies? Or double the data in one db? Nope. This is a single database, and I restored only once.. # of rows in tables match to the ones in prod... -- Devrim GÜNDÜZ PostgreSQL

Re: [GENERAL] On-disk size of db increased after restore

2010-09-01 Thread Devrim GÜNDÜZ
? These are generic RPM installations, and locales are the same... 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

Re: [GENERAL] On-disk size of db increased after restore

2010-09-01 Thread Devrim GÜNDÜZ
this affect on-disk size? 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

Re: [GENERAL] On-disk size of db increased after restore

2010-09-01 Thread Devrim GÜNDÜZ
On Wed, 2010-09-01 at 17:32 -0400, Tom Lane wrote: But are you sure there aren't some fillfactor tweaks in there too? I'm sure. fillfactor related changes are on the radar, but I did not commit them yet... -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL

<    1   2   3   4   5   >