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

2012-09-12 Thread Devrim GÜNDÜZ
his issue 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:/

Re: [GENERAL] CentOS initd Script

2012-09-12 Thread Devrim GÜNDÜZ
revents there. There are some reasons for having 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. R

Re: [GENERAL] CentOS initd Script

2012-09-12 Thread Devrim GÜNDÜZ
Hi, On Wed, 2012-09-12 at 10:58 +0200, Albe Laurenz wrote: > You should ask the people who roll the RPMs for CentOS, > they are the ones who created that script. It is actually Tom and me who are responsible for those init scripts, CentOS does not roll their own packages. Regards, --

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

2012-09-11 Thread Devrim GÜNDÜZ
s an open build service: 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

Re: [GENERAL] SEPostgreSQL alive?

2012-09-04 Thread Devrim GÜNDÜZ
; http://wiki.postgresql.org/wiki/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 H

Re: [GENERAL] PostgreSQL 8.4 download for RHEL6

2012-06-05 Thread Devrim GÜNDÜZ
Linux-x64 in .bin format? Why don't you install 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

Re: [GENERAL] Extreme PostgreSQL?

2012-05-23 Thread Devrim GÜNDÜZ
ails about SSD, please look 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ı/Co

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

Re: [GENERAL] yum repo issue

2012-04-22 Thread Devrim GÜNDÜZ
DG.rhel6.x86_64 > (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ışma

Re: [GENERAL] compilation info without pg_config

2012-03-26 Thread Devrim GÜNDÜZ
#x27;s a known bug (IMO) with most distros: 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 Engi

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

2012-03-14 Thread Devrim GÜNDÜZ
, but could not close yet. You can see the progress from 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

Re: [GENERAL] what Linux to run

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

Re: [GENERAL] Error installing postgresq91-python package

2012-02-28 Thread Devrim GÜNDÜZ
al here? 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

Re: [GENERAL] psql: invalid connection option "client_encoding"

2012-02-28 Thread Devrim GÜNDÜZ
ives.postgresql.org/pgsql-admin/2011-09/msg00101.php > > My ldconfig output i -- 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] Error installing plpythonu in 9.1

2012-02-28 Thread Devrim GÜNDÜZ
file is installed with -contrib 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

Re: [GENERAL] postgresql90-server package for RHEL5

2012-02-15 Thread Devrim GÜNDÜZ
just wrote, that list contains 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.enterprise

Re: [GENERAL] postgresql90-server package for RHEL5

2012-02-15 Thread Devrim GÜNDÜZ
not the first complaint 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.ent

Re: [GENERAL] postgresql90-server package for RHEL5

2012-02-15 Thread Devrim GÜNDÜZ
Hi, On Thu, 2012-02-16 at 11:21 +0900, Tomonari Katsumata wrote: > I'm looking for postgresql90-server-9.0.6 RPM package for RHEL5. > I can't find it bellow site. > "http://yum.postgresql.org/9.0/redhat/rhel-5-x86_64/repoview/"; > "http://yum.postgresql.org/9.0/redhat/rhel-5-i386/repoview/";. >

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

2012-01-11 Thread Devrim GÜNDÜZ
built 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~

Re: [GENERAL] Dated Version of PostgreSQL

2011-12-30 Thread Devrim GÜNDÜZ
cial repository? yum update 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 Twitt

Re: [GENERAL] Dated Version of PostgreSQL

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

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 @ Ent

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

2011-12-28 Thread Devrim GÜNDÜZ
its showing the error like: > > [root@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, --

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

2011-12-21 Thread Devrim GÜNDÜZ
ccessible remotely 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://twitte

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 @ Ente

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,

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 @ Ente

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

2011-11-03 Thread Devrim GÜNDÜZ
rg/8.3/redhat/rhel-5-i386-id/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://twit

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

2011-10-30 Thread Devrim GÜNDÜZ
.org/8.3/redhat/rhel-5-x86_64-id/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

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

2011-10-22 Thread Devrim GÜNDÜZ
SUNWprivate_1.1; > > So my libc has only the interfaces up to SUNW_1.6. How can this happen > that two snv_134 machines have different libsockets? > > Thanks for your insight > > Thomas > -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.en

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

2011-10-13 Thread Devrim GÜNDÜZ
ar openjdk will just 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://w

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

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

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

2011-10-02 Thread Devrim GÜNDÜZ
g_dump. * Start 9.1 > - Wait for the 9.1 packages to appear in the Fedora Core repo? 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 Cer

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

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 Cer

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

2011-09-21 Thread Devrim GÜNDÜZ
eed, in http://yum.postgresql.org/9.1/fedora/, 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.ent

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

2011-09-21 Thread Devrim GÜNDÜZ
p://yum.pgrpms.org/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,

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 Eng

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

2011-09-12 Thread Devrim GÜNDÜZ
ives, and set 9.0's priority something 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.ente

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 System

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

2011-09-12 Thread Devrim GÜNDÜZ
d! PostgreSQL source code ships 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

Re: [GENERAL] Pgpool outdated spec

2011-09-12 Thread Devrim GÜNDÜZ
at I will need to update, 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:

Re: [GENERAL] 8.4 -> 9.0 upgrade difficulties

2011-09-08 Thread Devrim GÜNDÜZ
ince you 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

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

2011-09-04 Thread Devrim GÜNDÜZ
ould never ever conflict with the libevent package on the OS, but... I actually did not bother it, since almost 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 @ Enterpris

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.enterpris

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 @

Re: [GENERAL] How to install PGCRYPTO in PostgreSQL9

2011-08-17 Thread Devrim GÜNDÜZ
crypto using 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 PostgreS

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

2011-08-02 Thread Devrim GÜNDÜZ
WAL files. * Disks were also slow 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://

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

2011-07-21 Thread Devrim GÜNDÜZ
; > If I switch over to the RHEL5 repository, it has 8.4.8, so perhaps 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ı

Re: [GENERAL] failed archive command

2011-07-06 Thread Devrim GÜNDÜZ
d use just %p instead 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://twi

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

Re: [GENERAL] Preventing OOM kills

2011-05-24 Thread Devrim GÜNDÜZ
; > /proc/self/oom_adj $SU -l postgres -c "$PGENGINE/postmaster -p '$PGPORT' -D '$PGDATA' ${PGOPTS} &" >> "$PGLOG" 2>&1 < /dev/null Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enter

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

2011-05-20 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/devrim

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

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

Re: [GENERAL] stymied on postgresql upgrade

2011-04-18 Thread Devrim GÜNDÜZ
y help would be appreciated. You 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.

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 @ Enterpr

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.enterpr

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

2011-03-23 Thread Devrim GÜNDÜZ
e saved into DB (each around 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

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

2011-03-14 Thread Devrim GÜNDÜZ
Oracle to PostgreSQL? Please see http://spacewalk.redhat.com/ PostgreSQL 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 C

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 Post

Re: [GENERAL] about PostgreSQL 9.0.3 RPMs

2011-02-09 Thread Devrim GÜNDÜZ
; When is they available? I uploaded 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: ht

Re: [GENERAL] about PostgreSQL 9.0.3 RPMs

2011-02-08 Thread Devrim GÜNDÜZ
2 days. There is an issue 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

Re: [GENERAL] yum repo problem

2011-02-01 Thread Devrim GÜNDÜZ
8.4.6-1PGDG.rhel4 pgdg84 > > > 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ı

Re: [GENERAL] beginners autovacuum question

2011-01-05 Thread Devrim GÜNDÜZ
RROR: cancelling autovacuum task" or so (this may 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

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

2011-01-03 Thread Devrim GÜNDÜZ
For 64-bit: 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~PostgreS

[GENERAL] Re: [NOVICE] Loading "posgres 9.0" libpq library on Linux version"Red 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-rel

Re: [GENERAL] pg_statsinfo problem

2010-12-20 Thread Devrim GÜNDÜZ
Sorry for breaking the thread a bit -- but where is that specfile? I cannot find it in the tarball. Also SRPMs are missing on the website. Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~Post

Re: [GENERAL] Hot Standby pg_xlog problem

2010-12-14 Thread Devrim GÜNDÜZ
t; LOG: could not open file "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 Certi

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

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

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

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

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 init

Re: [GENERAL] Pg_upgrade question

2010-11-30 Thread Devrim GÜNDÜZ
grade here -- you will be moving 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:/

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 Ha

Re: [GENERAL] postgreSQL-devel 8.3.8

2010-11-15 Thread Devrim GÜNDÜZ
edhat/rhel-5-i386/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:/

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

2010-11-14 Thread Devrim GÜNDÜZ
ms.org/9.0/fedora/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~Post

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 Re

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. 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 Postgre

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

2010-10-26 Thread Devrim GÜNDÜZ
os, you can send 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.or

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 H

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
https://public.commandprompt.com/projects/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://twitte

Re: [GENERAL] pgcluster

2010-10-14 Thread Devrim GÜNDÜZ
e either. :-( That's why I wrote "testing" ;) -- 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://twitt

Re: [GENERAL] about RPM build options

2010-10-13 Thread Devrim GÜNDÜZ
RPMs for various reasons in the past. You may want to recompile srpm for that. -- 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 Twitte

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: dev

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 Post

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 ; > 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

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 PostgreSQ

Re: [GENERAL] rotate psql output

2010-09-30 Thread Devrim GÜNDÜZ
'wrapped'. > 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: htt

Re: [GENERAL] pg_filedump binary for CentOS

2010-09-27 Thread Devrim GÜNDÜZ
is no > binary hidden somewhere 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 Certifie

Re: [GENERAL] pg_filedump binary for CentOS

2010-09-27 Thread Devrim GÜNDÜZ
is no > binary hidden somewhere 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 Co

Re: [GENERAL] pgcluster

2010-09-27 Thread Devrim GÜNDÜZ
hile > process the request > > 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 Ha

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
is patch: > > 2010-06-06 23:01 itagaki 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 Po

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~PostgreS

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

2010-09-05 Thread Devrim GÜNDÜZ
GDG RPMs appear here: > > http://www.postgresql.org/ftp/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

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

2010-09-04 Thread Devrim GÜNDÜZ
like to see whether multiple version installation really works 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~PostgreS

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

2010-09-03 Thread Devrim GÜNDÜZ
VACUUM FULL does not make any 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/dev

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

2010-09-02 Thread Devrim GÜNDÜZ
. I applied 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.

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

2010-09-01 Thread Devrim GÜNDÜZ
325824 bytes tbl4|8910422016 bytes tbl5|10814955520 bytes Almost all relations are smaller on backup. 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.t

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 Engine

<    1   2   3   4   5   >