Re: [GENERAL] Can't build ODBC -- odbc_config not found

) > > So it must be looking for a file called "odic_config"? It's not 100% > clear what is needed. You need to install unixODBC package (or equivalent in your distro) for this command. Regards, -- Devrim Gündüz EnterpriseDB: https://www.enterprisedb.com PostgreSQL Consultant, Re

[GENERAL] Announcing PostgreSQL SLES RPM Repository

my time for these packages, so I want to thank EDB. 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: [GENERAL] Installing 9.5 doesn't create 'postgres' unix account on Cent OS 7

paste the full output of the yum install? 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: [GENERAL] plpython2.dll missing from Enterprise DB Postgres distribution

Apologies for that, everyone is important for us. They will contact you. 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: [GENERAL] make postgresql 9.5 default on centos 7

second command will reinstall the packages, and they will create alternatives entries for the binaries, etc. Regards, -- Devrim Gündüz EnterpriseDB: https://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.

Re: [GENERAL] Failed DNF dependency in Fedora

the metadata? dnf clean metadata dnf install python-psycopg2 Thanks! 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: [GENERAL] [ADMIN] How to install pgadmin3 or pgadmin4 on linux machine

essfully on my server. > > what next how to configure it? Run: yum install pgadmin4-v1-web pgadmin4-v1 to install pgadmin4. You can run pgadmin4 from command line, or use the GUI to find it. Regards, -- Devrim Gündüz EnterpriseDB: https://www.enterprisedb.com PostgreSQL Danışmanı/Co

Re: [GENERAL] Download 9.6.3 Binaries

e inconvenience. 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: [GENERAL] Missing folder rhel-6Workstation-x86_64 for 9.6 repo (redhat)

create this? Done. They will appear in next 15 mins. As already noted, they are just a symlink to rhel-6-x86_64. Still, some installations require this path. Regards, -- Devrim Gündüz EnterpriseDB: https://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz

Re: [GENERAL] Installing module for 9.6, not 9.2, on Centos?

atelang createuser dropdb droplang dropuser pg_basebackup pg_dump pg_dumpall pg_restore reindexdb vacuumdb > And if so, what controls that behavior, We control this by using alternatives > is it easily-changeable, and/or can you go back and forth? Yes, you check update-alternatives comman

[GENERAL] PostgreSQL RPMs for PPC64LE are released

/repoview/ for the list of all current packages (use the links on the right top for full list) Please report any packaging related errors to us: pgsql-pkg-...@postgresql.org  Regards, -- Devrim Gündüz EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer

Re: [GENERAL] Help: Installing 9.6 breaks local connections to 9.2 on Centos 6.9

Hi, On Mon, 2017-05-15 at 22:35 -0700, Ken Tanzer wrote: > https://redmine.postgresql.org/issues/2409 Not sure whether we should *fix* this or not on RPM side. This may break some of the existing installations, right? I'm not objecting, just asking for opinions. Regards, -- Devrim Gün

Re: [GENERAL] Help: Installing 9.6 breaks local connections to 9.2 on Centos 6.9

/ld.so.conf.d, so that the latest libpq is picked up. 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: [GENERAL] Help: Installing 9.6 breaks local connections to 9.2 on Centos 6.9

9.4+ are complied with a patch that changes default socket directory from /tmp to /var/run/postgresql, and 9.2 is not aware of that. Workarounds: * You can connect to 9.2 using /usr/pgsql-9.2/bin/psql command. It knows the old socket directory. * Pass -h /tmp to 9.6's psql, so that it connec

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 3 - libraries resolved, still can't compile :(

Hi, On Sun, 2017-05-14 at 12:59 -0700, Adrian Klaver wrote: > > We don't support OpenSuSE, that might be the reason. > > Who is we EnterpriseDB. > and what don't you support? OpenSuSE, as I wrote in the previous email. Regards, -- Devrim Gündüz EnterpriseDB: http://www.e

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 3 - libraries resolved, still can't compile :(

Hi Adrian, On Sun, 2017-05-14 at 09:00 -0700, Adrian Klaver wrote: > I understand. I just installed  EDB Postgres 9.6.3 on my openSUSE Leap  > 42.2 machine and tried to compile repmgr against it. No joy. We don't support OpenSuSE, that might be the reason. Regards, -- Devrim

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

config (apologies if you did this already, I did not read the whole thread): Makefile: line 33 sql/Makefile: line 13 and run USE_PGXS=1 make at this point. Regards, -- Devrim Gündüz EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer T

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

l openssl-devel readline-devel libmemcached-devel libicu-devel Once you install their equivalent, you'll be able to compile repmgr against EPAS 9.6. (Hint: Last time I used Ubuntu/Debian, their package names ended with -dev for the development packages) Regards, -- Devrim Gündüz EnterpriseDB: htt

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

a few packaging skills can also easily build package of repmgr against EPAS. That said, I'll reply Martin's email, too. Regards, -- Devrim Gündüz EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signatu

Re: [GENERAL] Error During PostGIS Build From Source on Linux

Hi, On Wed, 2017-04-12 at 16:10 -0700, John R Pierce wrote: > if you install those packages from the yum repository, doesn't postgis  > include raster support? It does. Regards, -- Devrim Gündüz EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Cer

Re: [GENERAL] CenOS 5/Postgresql 9.6

-9.6.2-2PGDG.rhel6.src.rpm I did not test it though, but it should work or less work... You can also contact a PostgreSQL support company, and ask them to provide the RPMs, too. Regards, -- Devrim Gündüz EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified En

Re: [GENERAL] PGSQL 9.6.2 unable to find readline

25 RPMs 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: [GENERAL] Error dumping 9.4: could not parse numeric array

rew, in case he has some ideas on this. 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

[GENERAL] Error dumping 9.4: could not parse numeric array

pg_dump: reading user-defined functions pg_dump: could not parse numeric array "2281": too many numbers === Any idea why this is happening, and how can I find a solution? Thanks! Regards, -- Devrim Gündüz EnterpriseDB: http://w

Re: [GENERAL] Install pgAudit extension

er/9.5/pgaudit.conf -HTH 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: [GENERAL] Postgresql 94 from PostgreSQL RPM Repository (with Yum)

ig file for the above but couldn't find one. > > What am I missing? Can you please run export PKG_CONFIG_PATH=/usr/pgsql-9.4/lib/pkgconfig/ and then run configure script again? Regards, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red

Re: [GENERAL] Problem changing default data_directory in PG 9.6 + CentOS6

======= 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: [GENERAL] Installing pgAdmin 4 in Oracle Enterprise Linux 7

is? yum --enablerepo pgdg96-updates-testing install pgadmin4 pgadmin4-web  Just tested on: $ cat /etc/oracle-release  Oracle Linux Server release 7.2 If it also works for you, I'll push the updated packages to updates repo. Regards, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com Post

Re: [GENERAL] Installing pgAdmin 4 in Oracle Enterprise Linux 7

digest" > > This is also something that I need to test, but it is too late in here now, > > will look tomorrow. Hmm, AFAICS, RHEL and OEL do not have python-debug package. I'll take a look. Regards, --  Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consulta

Re: [GENERAL] Installing pgAdmin 4 in Oracle Enterprise Linux 7

dg96)   Requires: libpython2.7_d.so.1.0()(64bit) >  You could try using --skip-broken to work around the problem >  You could try running: rpm -Va --nofiles --nodigest" This is also something that I need to test, but it is too late in here now, will look tomorrow. Regards, --  D

Re: [GENERAL] [ANNOUNCE] pgAdmin 4 v1.0 Released!

vel >= 5.1 BuildRequires: qt5-qtwebkit-devel BuildRequires: qt-devel >= 4.6 BuildRequires: qtwebkit-devel BuildRequires: python3-devel BuildRequires: python-devel In your case, I think qt-devel and qtwebkit-devel packages are needed. Regards, -- Devrim GÜNDÜZ Enterpris

Re: [GENERAL] Unable to log in current local time EST

ime. > > Postgres keeps log the GMT time. > I want to log EST time.  How can I do that?  What is the value of log_timezone parameter? Regards, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz

Re: [GENERAL] postgresql "init script" for postgres 9.2.15

ql/EL-6/postgresql.init;h=daf436ec39f9038a7e3d73c50f80fc3492be15a1;hb=HEAD You just need to change stuff starting line 92: https://git.postgresql.org/gitweb/?p=pgrpms.git;a=blob;f=rpm/redhat/9.6/postgresql/EL-6/postgresql.init;h=daf436ec39f9038a7e3d73c50f80fc3492be15a1;hb=HEAD#l92 -HTH. Regards, -- Devrim GÜNDÜZ P

Re: [GENERAL] Pg_bulkload for PostgreSql 9.5

to master repo in an hour: https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-5-x86_64/ You can download and use it via RPMs. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Enginee

Re: [GENERAL] Broken after upgrade

Hi, Fedora packages have an executable (not sure about its name, but check a package called postgresql-upgrade or so). That will help you to finish the upgrade process. Regards, Devrim On July 6, 2016 9:13:50 PM GMT+03:00, arnaud gaboury wrote: >I am left today,

Re: [GENERAL] .bash_profile replaced on software updates

Hi John, Can you please create a ticket at redmine.postgresql.org , under pgrpms project? I will look at this soon. Thanks! Regards, Devrim On May 21, 2016 5:09:13 PM GMT+03:00, John DeSoi wrote: >I'm using CentOS and updating Postgres with yum. Whenever Postgres is

Re: [GENERAL] Initdb --data-checksums by default

g data  must be mandatory  set by default.  > Only if someone doesn't care about his data he can manually turn this  > option off. > > What do you think about defaulting --data-checksums in initdb? I think this should be discussed in -hackers, right? Regards, -- Devrim GÜNDÜZ Pr

Re: [GENERAL] Not signed yum repository packages

natures too all 9.4-Fedora 22 RPMs. Pushed them now, they will sync to master repo in an hour. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR

Re: [GENERAL] Trouble installing PostGIS on Amazon Linux server

; > what happens if you try to install libpoppler (it is in the standard > > Amazon repo)? > > > > yum install poppler poppler-devel poppler-cpp poppler-cpp-devel > > > > Bye, > > Chris. > > > > > > -- Devrim GÜNDÜZ Principal Systems E

Re: [GENERAL] Trouble installing PostGIS on Amazon Linux server

Hi, I think you also need to add/enable EPEL repo, too. Regards,Devrim On February 15, 2016 12:09:01 AM GMT+02:00, Augori wrote: >I'm trying to install postgis on an Amazon Linux AMI 2015.09 - x86_64 >machine. I was able to install PostgreSQL 9.3, however, when I try to

Re: [GENERAL] yum packages for 9.5 vs <=9.4

Hi again, On Thu, 2016-01-21 at 21:46 +0200, Devrim GÜNDÜZ wrote: > Sorry about that, but we had to do it. Here is the reason why: https://bugzilla.redhat.com/show_bug.cgi?id=825448 Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com Postgre

Re: [GENERAL] yum packages for 9.5 vs <=9.4

my scripts and stuff, > for  > instance this script invoked from crontab no longer works on the > earlier  > versions... Sorry about that, but we had to do it. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, R

Re: [GENERAL] plpython3 package absent in 9.5 repository

Hi, On Wed, 2016-01-13 at 10:44 -0200, Clodoaldo Neto wrote: > Where to get the plpython3 packages for 9.5? Pushed them to repo now, for Fedora 22+. Thanks for the heads up! Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışm

[GENERAL] Re: [pgsql-pkg-yum] Missing RHEL rpm(pg_catcheck-95) in postgres 9.5 repo.

e for Fedora, we request your help in getting > this rpm for RHEL as well, at the earliest. Thanks for the heads up. Pushed to 9.5 repos. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified E

Re: [GENERAL] plpython3 package absent in 9.5 repository

t; > Or as source: > > https://download.postgresql.org/pub/repos/yum/srpms/9.5/fedora/fedora > -22-x86_64/ > > Where to get the plpython3 packages for 9.5? > > Regards, Clodoaldo -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com Postg

Re: [GENERAL] [ADMIN] $libdir/mysql_fdw

"/usr/pgsql-9.4/share/extension/mysql_fdw.control": No such file or > directory > > What needs to be installed for this to work? Looks like you installed PostgreSQL using the community RPMs -- so make sure that you used the RPM of mysql_fdw: yum install mysql_fdw_94 would do the trick. Reg

Re: [GENERAL] pgsql-95 repo in rsync

Hi, On Mon, 2015-09-21 at 12:46 +, Kjetil Nygård wrote: > > 1. rsync > Would it be possible to have PostgreSQL 9.5 in the rsync-repo? This is now done. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consul

Re: [GENERAL] looking for old rpm

uild the RPMs by yourself. ftp://ftp.postgresql.org/pub/source/v9.3.6/ are the sources, and http://people.planetpostgresql.org/devrim/index.php?/archives/44-How-To -Build-Your-Own-PostgreSQL-and-related-software-RPMs-on -CentOSRHELFedora.html is the guide. Regards, -- Devrim GÜNDÜZ P

Re: [GENERAL] pgsql-95 repo in rsync

postgresql.org/devrim/index.php?/archives/44-How-To -Build-Your-Own-PostgreSQL-and-related-software-RPMs-on -CentOSRHELFedora.html I believe you can use Fedora 22 stuff on Fedora 23, too. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL

Re: [GENERAL] pgsql-95 repo in rsync

Hi, On Mon, 2015-09-21 at 15:46 -0700, Adrian Klaver wrote: > In other words not sure what Postgres has to do with rsync? I think OP refers to the YUM repo. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant,

Re: [GENERAL] instr detail

Hi, On Wed, 2015-07-29 at 22:03 +0530, Ramesh T wrote: is instr available in postgres 9.3..? in oracle instr('12.32.42','.',-1) ,any help appreciated Orafce extension includes instr function: https://github.com/orafce/orafce Regards, -- Devrim GÜNDÜZ Principal Systems

Re: [GENERAL] plv8 package in PostgreSQL 9.4 Yum repositories

/supported packages, plv8 is mentioned on http://yum.postgresql.org/news-packagelist.php and it was available up to PostgreSQL 9.3. Pushed 1.4.4 to 9.4 and 9.5 repositories. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı

Re: [GENERAL] 9.4.2 - 9.4.3

Hi, On Thu, 2015-05-28 at 10:37 +0200, Chris Mair wrote: Will 9.4.3 be exactly like 9.4.2 except for the permission bug, or will there be other fixes too? There are a few more fixes available in the queue, including another multixact fix. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer

Re: [GENERAL] PostgreSQL OGC compliant

Hi, On Wed, 2015-05-13 at 07:49 -0400, Stephen Frost wrote: http://www.postgis.org The URL is actually http://www.postgis.net Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter

Re: [GENERAL] PGFoundry Sample databases (particularly world)?

are using RPM based platform, pagila and usda are already packaged at http://yum.PostgreSQL.org . Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR

Re: [GENERAL] pgadmin3 installation on Oracle Linux 6.6 64-bit ?

-- 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: [GENERAL] Two instances of Postgres with single data directory

/different-replication-solutions.html It is not a replication -- it is HA solution. That particular one can be used along with Red Hat Cluster Suite (now called Red Hat High Availability Addon). A presentation is here: http://www.gunduz.org/download.php?dlid=208 Regards, -- Devrim GÜNDÜZ Principal

Re: [GENERAL] Testing on Power 8 systems

Hi, On Mon, 2014-11-03 at 10:35 -0800, John R Pierce wrote: oooh, did someone donate a build host?cool! It is not finalized, but we are close to that. what about AIX ? No idea. I just build RPMs :) Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http

Re: [GENERAL] Testing on Power 8 systems

Hi, On Mon, 2014-11-03 at 18:45 +0100, Georges Racinet wrote: Didn't find many ppc64 ou ppc64el binary packages online, though: yum.postgresql.org For the archives: We will support Power 7 and Power 8 systems on RHEL 6 and RHEL 7 in the upcoming weeks. Regards, -- Devrim GÜNDÜZ Principal

Re: [GENERAL] DBlink, postgres to DB2

Hi, On Thu, 2014-10-30 at 00:47 -0700, Postgres India wrote: configure: error: odbc_config not found (required for unixODBC build) I think you need to install unixODBC-devel rpm via yast. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com

Re: [GENERAL] PgAgent binary distribution for Centos 6.5

://yum.postgresql.org 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: [GENERAL] Help related to Postgresql for RHEL 6.5

use 9.3, for example. 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: [GENERAL] PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb

Hi, On Mon, 2014-06-09 at 14:23 +0530, Bhushan Pathak wrote: A core file was not generated. Can you please also install the -debuginfo package? Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified

Re: [GENERAL] PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb

can find out the issue. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http

Re: [GENERAL] CentOS 6 and Postgresql 9.3.4 from PGDG

, -- 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: [GENERAL] RHEL 7 and Postgres 9.3.4

Hi, It works fine. We already branched RHEL 7 RPMs. I am using them on my testing instance. Regards, On April 1, 2014 5:21:25 PM EEST, Dev Kumkar devdas.kum...@gmail.com wrote: Hello, RHEL 7 will be in market by June 2014. I just wanted to check here RHEL 7 and Postgres 9.3.4 compatibility?

Re: [GENERAL] configure errors on Fedora 20

with BuildRequires Still, why do you compile? We have the RPMs already: http://yum.postgresql.org Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR

Re: [GENERAL] CREATE EXTENSION does not seem to work in 9.2

don't need it with 9.2) 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: [GENERAL] Fwd: postgresql redhat

* are thse versions are compliant ? I think you are missing gcc-c++ package. Still, we have RPMs for RHEL 5 + PostgreSQL 9.3: http://yum.postgresql.org/9.3/redhat/rhel-5-x86_64/ Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı

Re: [GENERAL] pg_config problems on PG9.3/Centos?

’: table_log.c:134: warning: implicit declaration of function ‘RelationGetNamespace’ snip table_log is not being maintained anymore -- you can use emaj. It is already available in the same RPM repo: http://yum.postgresql.org/9.3/redhat/rhel-6-x86_64/repoview/emaj.html Regards, -- Devrim GÜNDÜZ

Re: [GENERAL] pg_config problems on PG9.3/Centos?

. Alternatively, while building the RPMs, we add a patch to makefiles like this: http://svn.pgrpms.org/repo/rpm/redhat/9.3/ip4r/F-20/Makefile-pgxs.patch Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer

Re: [GENERAL] [HACKERS] using rpmbuild with PostgreSQL 9.2.6 source code

. 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

Re: [GENERAL] using rpmbuild with PostgreSQL 9.2.6 source code

=pgdg92-source postgresql92 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: [GENERAL] [HACKERS] [pgrpm-HACKERS]SPEC file for PostgreSQL

spec files and patches. 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] Can't find /var/lib/pgsql/9.3/data/global/pg_auth

years before. You can use mkauth.py to generate the auth file. Here is a blog post about how to do it: http://www.depesz.com/2010/12/04/auto-refreshing-password-file-for-pgbouncer/ Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı

Re: [GENERAL] Can't find /var/lib/pgsql/9.3/data/global/pg_auth

://pgbouncer.projects.pgfoundry.org/doc/config.html#_authentication_file_format 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] postgresql93-devel-9.3beta2-1PGDG.rhel5.x86_64 missed pg_config

install postgresql92-devel package? If yes, then pg_config is not under $PATH. It is located under /usr/pgsql-9.2/bin/pg_config, to avoid issues when multiple versions are installed together. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL

Re: [GENERAL] Build RPM from Postgres Source

the RPM. You can add your own patches, and build your own RPMs like this. 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] [Maintainers] REL/Centos4 release of 8.4.17?

and uploaded the RPMs. Still, please upgrade your OS :) 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] CVE-2013-1899 security issue and limited IP addresses in pg_hba.conf

addresses of the clients. But does anyone know if CVE-2013-1899 allows an arbitrary attacker to use the exploits described in [1]? We are using PostgreSQL 8.4. Best regards, Mads [1] http://www.postgresql.org/support/security/faq/2013-04-04/ -- Devrim Gündüz

Re: [GENERAL] Fedora 18 x86_64 repodata/repomd.xml: [Errno 14] curl#22 - The requested URL returned error: 404 Not Found on PostgreSQL 9.2

Romero Benavides @iCodeiExist @PgsqlMx Postgresql Tips en español para la comunidad de México e Hispanoamérica. http://postgresql.org.mx -- Devrim Gündüz

Re: [GENERAL] PosgreSQL Konfigürasyonu

648 1567 F +90 262 648 1100 www.bilgem.tubitak.gov.tr melik.yu...@tubitak.gov.tr Sorumluluk Reddi -- Devrim GÜNDÜZ Principal Systems Engineer

[GENERAL] PostgreSQL Live CD for 9.2.3 released

packages. Kickstart file is configurable, so you can also create your own PostgreSQL Live CD's fairly easily. Please let me know if you have any questions regarding this live CD. Sincerely, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http

Re: [GENERAL] PostgreSQL Live CD for 9.2.3 released

Hi, On Thu, 2013-02-21 at 12:58 +0200, Victor Yegorov wrote: Description mentions PostgreSQL 9.1.3 all around, is this correct? Ooops, fixed. Thanks! Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat

Re: [GENERAL] 9.2 RHEL6 yum Repository broken?

machine. Still, I refreshed metadata cache. Could you please run yum clean all; yum makecache and then install the package? Between Saturday and Tuesday, I added various new packages to the repository several times. You were probably caught between them. Regards, -- Devrim GÜNDÜZ Principal Systems

Re: [GENERAL] 9.2 RHEL6 yum Repository broken?

. Could you please paste the makecache output? 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] 9.2 RHEL6 yum Repository broken?

to try. What is pgsg92? Maybe there is a firewall or proxy or satellite server or misconfigured repo around? -- 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] undefined symbol: SPI_plan_get_cached_plan

. I think Roger is referring to Scientific Linux with SL, and my packages. I don't see any reason why package updates don't restart themselves, unless they are installed without running post scripts... Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com

Re: [GENERAL] PG V9 on NFS

Hi, On Mon, 2013-02-11 at 22:22 +, Gauthier, Dave wrote: Can PG V9.1* support a DB that's on an NFS disk? http://www.postgresql.org/message-id/25517.1191038...@sss.pgh.pa.us Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL

[GENERAL] Replacement for Oracle Workspace Manager

, -- 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] Determine if an index is a B-tree, GIST, or something else?

the indexes in my database, and I'd like to include whether it's a GIST index, a B-Tree, or whatever was in the USING clause when the index was created. You can either look at pg_indexes, or use pg_get_indexdef(oid) function, where oid is index's oid. Regards, -- Devrim GÜNDÜZ Principal Systems

Re: [GENERAL] Problem starting PG-9.2 on non-default port

Hi, Is this an RPM installation? If so, you also need to change the port in the init script, too. Regards, Devrim James B. Byrne byrn...@harte-lyne.ca wrote: I wish to run an instance of PG-9.2 concurrently with our production version (9.1). I have changed the listening port number.

Re: [GENERAL] 9.2.2 RH, Fedora

Hi, On Mon, 2012-12-10 at 20:09 +0200, Gražvydas Valeika wrote: Could somebody tell if or when 9.2.2 packages will arrive to the PGDG yum repository? Pretty soon. Packages are ready, they are under rsync process. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http

Re: [GENERAL] Mailing list Question

use RHCS: http://www.gunduz.org/download.php?dlid=190 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] Fuzzystrmatch contrib module on RHEL63

building a module-only package. 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] remote connection refused

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

Re: [GENERAL] Understanding streaming replication

on these two. 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] shared memory settings

can handle that many connections, unless you are using HP DL 980 or HP Superdome or so. You also may want to consider using connection pooler, namely pgbouncer. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red

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

BuildRequires: wxWidgets-wxcontainer-devel So, you probably need the last two packages for the error you wrote. 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] CentOS initd Script

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, -- Devrim

  1   2   3   4   5   >