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

2017-10-27 Thread Devrim Gündüz
) > > 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 Consultan

[GENERAL] Announcing PostgreSQL SLES RPM Repository

2017-10-26 Thread Devrim Gündüz
o use 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

2017-08-28 Thread Devrim Gündüz
ou please 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

2017-08-24 Thread Devrim Gündüz
ogies 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

2017-08-22 Thread Devrim Gündüz
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.asc De

Re: [GENERAL] Failed DNF dependency in Fedora

2017-07-16 Thread Devrim Gündüz
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

2017-07-05 Thread Devrim Gündüz
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

2017-06-29 Thread Devrim Gündüz
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)

2017-06-21 Thread Devrim Gündüz
reate 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: @De

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

2017-05-24 Thread Devrim Gündüz
eatedb createlang 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-alternati

[GENERAL] PostgreSQL RPMs for PPC64LE are released

2017-05-16 Thread Devrim Gündüz
/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

2017-05-16 Thread Devrim Gündüz
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, -- Devri

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

2017-05-15 Thread Devrim Gündüz
under /etc/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

2017-05-15 Thread Devrim Gündüz
riority than 9.2, so that one is used -- and 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. *

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

2017-05-14 Thread Devrim Gündüz
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: ht

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

2017-05-14 Thread Devrim Gündüz
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, -- De

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

2017-05-14 Thread Devrim Gündüz
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.

2017-05-14 Thread Devrim Gündüz
l pam-devel 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 En

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

2017-05-14 Thread Devrim Gündüz
with 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 , @DevrimGun

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

2017-04-17 Thread Devrim Gündüz
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 Ha

Re: [GENERAL] CenOS 5/Postgresql 9.6

2017-03-18 Thread Devrim Gündüz
stgresql96-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 Ce

Re: [GENERAL] PGSQL 9.6.2 unable to find readline

2017-03-07 Thread Devrim Gündüz
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

2017-01-03 Thread Devrim Gündüz
CC'ing Andrew, 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

2017-01-03 Thread Devrim Gündüz
ables 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: htt

Re: [GENERAL] Install pgAudit extension

2016-12-05 Thread Devrim Gündüz
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)

2016-11-10 Thread Devrim Gündüz
-config 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ı/Consul

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

2016-10-18 Thread Devrim Gündüz
vice secondary-9.6 start'. 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

2016-10-05 Thread Devrim Gündüz
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

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

2016-10-03 Thread Devrim Gündüz
; > > 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ı/Con

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

2016-10-02 Thread Devrim Gündüz
x86_64 > (pgdg96)   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.

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

2016-09-30 Thread Devrim Gündüz
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

2016-08-25 Thread Devrim Gündüz
ost is running EST time. > > 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 Tw

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

2016-07-14 Thread Devrim Gündüz
6/postgresql/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, -- Devri

Re: [GENERAL] Pg_bulkload for PostgreSql 9.5

2016-07-13 Thread Devrim Gündüz
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

2016-07-06 Thread Devrim Gündüz
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, after an upgrade I th

Re: [GENERAL] .bash_profile replaced on software updates

2016-05-21 Thread Devrim Gündüz
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 >updated

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

2016-04-20 Thread Devrim Gündüz
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

Re: [GENERAL] Not signed yum repository packages

2016-04-05 Thread Devrim Gündüz
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

2016-02-15 Thread Devrim GÜNDÜZ
Hi, Just checked my RHEL 6 and RHEL 7 boxes. RHEL 6 provides libpoppler.so.5, and RHEL 7 provides libpoppler.so.46 . I cannot find any reference to .37 :( Where did you get it from? I am not an Amazon AMI user -- is your version based on RHEL 6 or RHEL 7? Regards, Devrim On Mon, 2016-02-15 at

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

2016-02-14 Thread Devrim Gündüz
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 >insta

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

2016-01-21 Thread Devrim GÜNDÜZ
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

2016-01-21 Thread Devrim GÜNDÜZ
ipts 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

2016-01-19 Thread Devrim GÜNDÜZ
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.

2016-01-18 Thread Devrim GÜNDÜZ
s available 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 C

Re: [GENERAL] plpython3 package absent in 9.5 repository

2016-01-13 Thread Devrim GÜNDÜZ
Hi Clodoaldo, It is a shame that I totally skipped that. Thanks for the report. I am working on the patch now. I will commit it as soon as it is ready. Regards, Devrim  On Wed, 2016-01-13 at 10:44 -0200, Clodoaldo Neto wrote: > I don't know the policy of package inclusion in the repo

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

2015-10-21 Thread Devrim GÜNDÜZ
"/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

2015-09-22 Thread Devrim GÜNDÜZ
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] pgsql-95 repo in rsync

2015-09-21 Thread Devrim GÜNDÜZ
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] pgsql-95 repo in rsync

2015-09-21 Thread Devrim GÜNDÜZ
edora 23-repo for PostgreSQL? Especially 9.4 > and 9.5. >*** Is there anything I can do, to help with this? > We don't provide repos for alpha/beta Fedora releases. Sorry about that. You can check back when F23 is stable. Still, you can build your own RPMs using the guide here: http://peo

Re: [GENERAL] looking for old rpm

2015-09-21 Thread Devrim GÜNDÜZ
you can build 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, -- Devri

Re: [GENERAL] instr detail

2015-07-29 Thread Devrim GÜNDÜZ
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, --

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

2015-07-23 Thread Devrim GÜNDÜZ
t of available/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

Re: [GENERAL] 9.4.2 -> 9.4.3

2015-05-28 Thread Devrim GÜNDÜZ
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 S

Re: [GENERAL] PostgreSQL OGC compliant

2015-05-13 Thread Devrim Gündüz
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 Twit

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

2015-05-05 Thread Devrim Gündüz
at pgfoundry? FWIW, if you 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: @DevrimG

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

2015-03-29 Thread Devrim Gündüz
Hi, http://yum.postgresql.org/ has all the packages for pgadmin3 and its dependencies for Oracle Linux 6.X. Regards, Devrim On Sat, 2015-03-28 at 12:14 +1100, Yuri Budilov wrote: > Hello everyone. > I am new to PostgreSQL and Linux (coming across from Microsoft SQL Server). > I

Re: [GENERAL] Two instances of Postgres with single data directory

2014-11-14 Thread Devrim Gündüz
ostgresql.org/docs/9.3/static/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 Rega

Re: [GENERAL] Testing on Power 8 systems

2014-11-07 Thread Devrim Gündüz
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

Re: [GENERAL] Testing on Power 8 systems

2014-11-03 Thread Devrim Gündüz
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Ü

Re: [GENERAL] DBlink, postgres to DB2

2014-10-30 Thread Devrim Gündüz
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.

Re: [GENERAL] PgAgent binary distribution for Centos 6.5

2014-10-17 Thread Devrim Gündüz
epo today: 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 signature.asc Description: This is a digitally signed message part

Re: [GENERAL] Help related to Postgresql for RHEL 6.5

2014-08-28 Thread Devrim Gündüz
org You can 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

2014-06-09 Thread Devrim Gündüz
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

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

2014-06-04 Thread Devrim Gündüz
y give input to the people who 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 Eng

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

2014-04-14 Thread Devrim GÜNDÜZ
isfied. 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] RHEL 7 and Postgres 9.3.4

2014-04-01 Thread Devrim Gündüz
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 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? > >Regards... -- Se

Re: [GENERAL] configure errors on Fedora 20

2014-03-22 Thread Devrim GÜNDÜZ
start 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 ,

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

2014-02-17 Thread Devrim GÜNDÜZ
here (still, you 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

2014-02-13 Thread Devrim GÜNDÜZ
cannot create executables* > > 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.enterp

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

2014-01-21 Thread Devrim GÜNDÜZ
PG_CONFIG does the trick. 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ı/Cons

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

2014-01-21 Thread Devrim GÜNDÜZ
gt; > table_log.c: In function ‘table_log’: > table_log.c:134: warning: implicit declaration of function > ‘RelationGetNamespace’ 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

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

2014-01-20 Thread Devrim GÜNDÜZ
ing. For the archives: It should be yumdownloader --enablerepo=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 si

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

2014-01-20 Thread Devrim GÜNDÜZ
s email do not belong to -hackers. You don't need to cross-post here) Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Des

Re: [GENERAL] [HACKERS] [pgrpm-HACKERS]SPEC file for PostgreSQL

2013-12-06 Thread Devrim GÜNDÜZ
SVN repo for 9.3 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:/

Re: [GENERAL] Install pg_trgm from source

2013-11-15 Thread Devrim GÜNDÜZ
;a=tree;f=contrib/pg_trgm;hb=refs/heads/master 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 Twit

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

2013-11-13 Thread Devrim GÜNDÜZ
two columns actually -- pgbouncer ignores the rest: http://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 Engin

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

2013-11-13 Thread Devrim GÜNDÜZ
? It was removed about 4 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.ente

Re: [GENERAL] postgresql93-devel-9.3beta2-1PGDG.rhel5.x86_64 missed pg_config

2013-07-25 Thread Devrim GÜNDÜZ
is this a bug? Did you 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

Re: [GENERAL] Build RPM from Postgres Source

2013-07-17 Thread Devrim GÜNDÜZ
esql/EL-6/postgresql-9.2.spec#L89 * Build 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~PostgreSQ

Re: [GENERAL] [Maintainers] REL/Centos4 release of 8.4.17?

2013-04-07 Thread Devrim GÜNDÜZ
;) I just built 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:/

Re: [GENERAL] CVE-2013-1899 security issue and limited IP addresses in pg_hba.conf

2013-04-04 Thread Devrim Gündüz
Hi, pg_hba.conf does not have protection for this security issue. Regards, Devrim mads.tand...@schneider-electric.com wrote: >Hi All > > >I'm trying to understand the implications of the latest security fix to >postgresql [1]. > > >We have a setup were we in

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

2013-03-14 Thread Devrim Gündüz
Hi, No idea what happened, but fixed. Thanks for the report. Regards, Devrim "René Romero Benavides" wrote: >Using the yum repository for PostgreSQL 9.2, does anybody know what >happened >to >http://yum.postgresql.org/9.2/fedora/fedora-18-x86_64/repodata/repomd.xm

Re: [GENERAL] PosgreSQL Konfigürasyonu

2013-02-26 Thread Devrim GÜNDÜZ
Hi, I asked OP to send this email to pgsql-tr-general mailing list. Regards, Devrim On Mon, 2013-02-25 at 20:42 +0200, Melik Yücel wrote: > Herkese merhaba, > Saniyede 10 bin kayıt alacak bir sistem kurmam gerekiyor. Bunu > PostgreSQL ile nasıl yapabilirim? Donanım konfigürasyonu, p

Re: [GENERAL] PostgreSQL Live CD for 9.2.3 released

2013-02-21 Thread Devrim GÜNDÜZ
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

[GENERAL] PostgreSQL Live CD for 9.2.3 released

2013-02-21 Thread Devrim GÜNDÜZ
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:

Re: [GENERAL] 9.2 RHEL6 yum Repository broken?

2013-02-13 Thread Devrim GÜNDÜZ
more mirrors 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~Po

Re: [GENERAL] 9.2 RHEL6 yum Repository broken?

2013-02-13 Thread Devrim GÜNDÜZ
error. 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 T

Re: [GENERAL] 9.2 RHEL6 yum Repository broken?

2013-02-13 Thread Devrim GÜNDÜZ
happen, and I could not reproduce this in build machines, staging machine and my own 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 t

Re: [GENERAL] PG V9 on NFS

2013-02-11 Thread Devrim GÜNDÜZ
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 Po

Re: [GENERAL] undefined symbol: SPI_plan_get_cached_plan

2013-02-11 Thread Devrim GÜNDÜZ
atically during package upgrade. 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 Syst

[GENERAL] Replacement for Oracle Workspace Manager

2013-01-23 Thread Devrim GÜNDÜZ
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 sig

Re: [GENERAL] Determine if an index is a B-tree, GIST, or something else?

2013-01-17 Thread Devrim GÜNDÜZ
tributes about > 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. Regard

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

2012-12-14 Thread Devrim Gündüz
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" 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

2012-12-10 Thread Devrim GÜNDÜZ
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

Re: [GENERAL] Mailing list Question

2012-11-30 Thread Devrim GÜNDÜZ
can 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.

Re: [GENERAL] remote connection refused

2012-11-19 Thread Devrim GÜNDÜZ
hine itself. 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 si

Re: [GENERAL] Fuzzystrmatch contrib module on RHEL63

2012-11-19 Thread Devrim GÜNDÜZ
dea about 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://tw

Re: [GENERAL] Understanding streaming replication

2012-11-14 Thread Devrim GÜNDÜZ
pport clusters 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.co

Re: [GENERAL] shared memory settings

2012-09-26 Thread Devrim GÜNDÜZ
ou 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, R

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

2012-09-13 Thread Devrim GÜNDÜZ
s BuildRequires: wxWidgets 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 Co

  1   2   3   4   5   6   7   >