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

[Devrim Gündüz]

Hi,

On Thu, 2017-10-26 at 23:40 -0700, Chris Albertson wrote:
> I just tried to build Postgres ODBC from source (psqlodbc-10.00..tar.gz)
> 
> I type "./configure"
> 
> Then get this message:
> configure: error: odbc_config not found (required for unixODBC build)
> 
> 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, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR


signature.asc
Description: This is a digitally signed message part

[GENERAL] Announcing PostgreSQL SLES RPM Repository

[Devrim Gündüz]

Hi,

I am proud to announce the new and shiny PostgreSQL RPM repository for SLES 12:
https://zypp.postgresql.org/.

The new repo contains (almost) all of the packages that the PostgreSQL YUM
repository has (https://yum.PostgreSQL.org) . Currently. we support PostgreSQL
10, 9.6 and 9.5, along with more than a hundred packages on each version. There
are a few packages missing, and I will add them in the upcoming days.

I also wrote a basic howto for using PostgreSQL RPMs on SLES, so please read it
first, if you are not that familiar to SLES: https://zypp.postgresql.org/howtoz
ypp.php .

For any questions/comments, please send an email to 
pgsql-pkg-...@postgresql.org , or (preferably)create a ticket at 
https://redmine.postgresql.org/projects/pgrpms/ by using your community
account.

This is a part of EnterpriseDB's contribution to the community: EDB provided
hardware, and let me to 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

[Devrim Gündüz]

Hi,

On Mon, 2017-08-28 at 05:13 +, John Lawlor wrote:

> yum install postgresql95 postgresql95-server.x86_64
> 
> Then I try to switch to the 'postgres' user normally created by installing
> postgres:
> 
> su - postgres
> su: user postgres does not exist

Can you 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

[Devrim Gündüz]

Hi Alan,

On Sun, 2017-08-20 at 16:50 +, Alan Millington wrote:



> I have raised this with EDB. I received an acknowledgment, but I have not
> heard anything more. That is not surprising, as I am a person of no
> importance.

I just raised this again with our support team. 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

[Devrim Gündüz]

Hi,

On Fri, 2017-08-18 at 13:50 -0400, Steve Clark wrote:
> I loaded 9.5 on CentOS 7 but by default every thing wants to use the default
> 9.2 version that comes with CentOS 7.
> 
> Is there a simple way to fix this so the 9.5 version of tools and libraries
> are used.

yum remove postgresql-* 
yum reinstall postgresql95*

will do the trick. Please note that the second one will restart the database,
so make sure that you run these in a maintenance period.

The first command will remove all OS PostgreSQL packages. This is a required
step to remove actual binaries from OS. The 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
Description: This is a digitally signed message part

Re: [GENERAL] Failed DNF dependency in Fedora

[Devrim Gündüz]

Hi Clodoaldo,

On Sat, 2017-07-15 at 08:38 -0300, Clodoaldo Neto wrote:
> While installing Psycopg2 for Python2 in Fedora 26 having Postgresql 9.6:
> 
> # dnf install python-psycopg2
> Last metadata expiration check: 0:01:52 ago on Sat 15 Jul 2017 08:30:26 AM
> -03.
> Error:
>  Problem: conflicting requests
>   - nothing provides postgresql94-libs needed by
> python-psycopg2-2.7.1-1.f26.x86_64
> 
> Psycopg2 for Python3 installs cleanly.

Ouch. I just replaced the packages in the repo. They will sync in next 45 mins.
 Can you please try again, after cleaning 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

[Devrim Gündüz]

Hi,

On Wed, 2017-07-05 at 17:05 +0530, PAWAN SHARMA wrote:
> Please help me to install pgadmin3 or pgadmin4 on Redhat server.
> 
> 
> https://yum.postgresql.org/repopackages.php#pg95
> 
> I have download pgdg-redhat95-9.5-3.noarch.rpm from the above link and
> install successfully 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ı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR


signature.asc
Description: This is a digitally signed message part

Re: [GENERAL] Download 9.6.3 Binaries

[Devrim Gündüz]

Hi,

On Fri, 2017-06-23 at 11:04 -0700, Igal @ Lucee.org wrote:

> I expected to find binaries for 9.6.3 at 
> https://www.enterprisedb.com/download-postgresql-binaries but I only see 
> 9.6.2.
> 
> Am I looking at the wrong place?

Our team at EDB fixed the website, sorry for the 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)

[Devrim Gündüz]

Hi,

On Tue, 2017-06-13 at 10:32 +0200, Sari Thiele wrote:

> it looks like that the folder 'rhel-6Workstation-x86_64' does not exist
> any more for 9.6 (redhat).
> 
> Is this intentional or has this folder just been forgotten?
> 
> Is it possible that someone can 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 , @DevrimGunduzTR


signature.asc
Description: This is a digitally signed message part

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

[Devrim Gündüz]

Hi,

On Tue, 2017-05-23 at 23:39 -0700, Ken Tanzer wrote:

> Can I also ask y'all a more general question about this, specifically
> related to how Postgres is packaged for RHEL/Centos?  I've got both 9.6 and
> 9.2 installed.  In this case though, it seems that the 9.2 version is
> privileged/selected by default. 

It may happen only if 9.2 is installed via Red Hat RPMs. Otherwise, 9.6 will be
the selected by default for many binaries. If that is your case, you need to:

* Stop 9.2
* Uninstall 9.2 RPMs
* Install 9.2 from PGDG
* Start 9.2
* Stop 9.6
* Reinstall 9.6 (so that the binaries are fixed)
* Start 9.6

>  But psql defaults to the 9.6 version.  Are there other similar things that
> will default to either 9.2 or 9.6?  

These are the binaries that defaults to the higher version when there are more
than 1 major version are installed:

psql
clusterdb
createdb
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-alternatives command.

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] PostgreSQL RPMs for PPC64LE are released

[Devrim Gündüz]

The PostgreSQL YUM Repository Project is happy to announce RPMs of PostgreSQL
9.6 and related software for Power8 Little Endian (PPC64LE) platforms on RHEL 7
and CentOS 7. We want to thank IBM and EnterpriseDB for sponsoring hardware and
manpower for this project.

These packages follow the same update and maintenance policies of the packages
already distributed at https://yum.postgresql.org, and will also follow the
lifecycle of the released PostgreSQL versions.

We currently cover more than 110 RPMs, and more will come soon. PostgreSQL 9.5
and PostgreSQL 10 support will also be available soon.

In order to use the RPMs, please first install the repository RPM from:

https://yum.postgresql.org/repopackages.php#pg96

and then run install the PostgreSQL RPMs as usual:

yum install postgresql96-server (and others)

Please visit https://yum.postgresql.org/9.6/redhat/rhel-7-ppc64le/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
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

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

[Devrim Gündüz]

Hi,

On Mon, 2017-05-15 at 16:34 -0400, Tom Lane wrote:
> > bash-4.1$ /usr/pgsql-9.2/bin/psql -p 5432
> > psql: could not connect to server: Connection refused
> >    Is the server running locally and accepting
> >    connections on Unix domain socket
> > "/var/run/postgresql/.s.PGSQL.5432"?
> 
> The default is actually compiled into libpq.so, not psql itself.
> So I'm thinking what's happening here is the 9.2 psql is picking
> up a libpq.so supplied by 9.6.

Yeah, sorry, my bad. I forgot that the RPMs also put a file 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

[Devrim Gündüz]

Hi,

On Mon, 2017-05-15 at 12:55 -0700, Ken Tanzer wrote:
> Hi.  On a Centos 6.9 server (in the cloud with Rackspace), I'm wanting to
> install PGDG 9.6 alongside the already-running 9.2.  After installing the
> 9.6 packages (and even before doing an initdb), I am no
> longer able to make a local connection to the 9.2 server.  Instead I get
> the message:
> 
> psql: could not connect to server: Connection refused
> Is the server running locally and accepting
> connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
> 
> That socket file does not exist on the server. (And in fact, the
> /var/run/postgresql directory didn't exist before installing 9.6).  When I
> configure 9.6 to use port 5433 and run it, it does create that socket for
> 5433.  I tried creating such a socket manually for 5432, but that didn't
> seem to change anything.
> 
> Any help in getting this working and/or pointing out what I'm missing would
> be great.  I'm also confused conceptually about what is happening here.
> What is it that the installation (but not execution) of 9.6 does that's
> blocking the local 9.2 access?  I'm guessing it's gotta be something in the
> RPM install scripts.

PGDG RPMs use alternatives method, to replace some binaries that can be used
across multiple PostgreSQL versions, and psql is one of them. When you install
9.6, 9.6's psql has higher priority 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.

* Pass -h /tmp to 9.6's psql, so that it connects to 9.2 instance.

-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] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 3 - libraries resolved, still can't compile :(

[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: 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] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 3 - libraries resolved, still can't compile :(

[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,
-- 
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] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

[Devrim Gündüz]

Hi again Martin,

On Fri, 2017-05-12 at 16:13 +0100, Martin Goodson wrote:
> testdb@repm:/postgresql/software/repmgr/repmgr-3.3.1$ sudo make 
> USE_PGXS=1 install

BTW, please patch these two files first and change

PG_CONFIG = pg_config 
to
PG_CONFIG= /postgresql/software/pg/9.6.2/bin/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
Twitter: @DevrimGunduz , @DevrimGunduzTR


signature.asc
Description: This is a digitally signed message part

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

[Devrim Gündüz]

Hi Martin,

On Fri, 2017-05-12 at 16:13 +0100, Martin Goodson wrote:
> /usr/bin/ld: cannot find -lselinux
> /usr/bin/ld: cannot find -lssl
> /usr/bin/ld: cannot find -lcrypto
> /usr/bin/ld: cannot find -lgssapi_krb5
> /usr/bin/ld: cannot find -lz
> collect2: error: ld returned 1 exit status
> Makefile:20: recipe for target 'repmgrd' failed
> make: *** [repmgrd] Error 1

I just tested this on my CentOS 7 box -- FWIW, you need to following
dependencies (these are CentOS/RHEL package names, you can find their Ubuntu
equivalents easily):

systemd
libxslt-devel
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
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] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

[Devrim Gündüz]

Hi Josh,

On Fri, 2017-05-12 at 08:18 -0700, Joshua D. Drake wrote:
> This is your problem. As Adrian already mentioned, you should be running 
> the PGDG apt repos.

I don't think this is a productive answer. I could just compile repmgr on my
CentOS 7 box against EPAS 9.6. Someone 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 , @DevrimGunduzTR


signature.asc
Description: This is a digitally signed message part

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

[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 Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR


signature.asc
Description: This is a digitally signed message part

Re: [GENERAL] CenOS 5/Postgresql 9.6

[Devrim Gündüz]

Hi,

On Fri, 2017-03-17 at 12:15 -0700, Steve Crawford wrote:
> The question remains - does anyone know where I might find packages so I
> don't have to compile them myself?

(I'm the maintainer of the repository)

There are no packages for CentOS 5 / PG 9.6, and it was my decision to drop
support -- as I thought that using CentOS 5 with a new set of PG releases would
not be the best idea.

I still think so.

However, you can still rebuild 9.6 RPMs on your CentOS 5 box, by using this
SRPM:

https://download.postgresql.org/pub/repos/yum/srpms/9.6/redhat/rhel-6-x86_64/postgresql96-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 Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR


signature.asc
Description: This is a digitally signed message part

Re: [GENERAL] PGSQL 9.6.2 unable to find readline

[Devrim Gündüz]

Hi,

On Tue, 2017-03-07 at 15:38 -0500, John Iliffe wrote:
> Trying to compile pgsql 9.6.2 on Fedora 25 
> 
> I get the following message:
> 
> configure:9345: error: readline library not found

Please install readline-devel.

(BTW, https://yum.PostgreSQL.org has 9.6.2 and Fedora 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

[Devrim Gündüz]

Hi Tom,

On Tue, 2017-01-03 at 09:43 -0500, Tom Lane wrote:
> The only conclusion I can draw is that you have a row in pg_proc
> in which proargtypes has more entries than pronargs says there
> should be.  How it got that way is not apparent --- but you could
> start by seeing if you can identify the corrupt row(s).

Thank you! I think these lines looks suspicious:

 proname  | pronargs |  proargtypes  |probin
-
-+--+---+--
 gipr_consistent  | 
   3 | 2281 22793 21 26 2281 | $libdir/ip4r
 gip6r_consistent |3 |
2281 22781 21 26 2281 | $libdir/ip4r
 gip4r_consistent |3 | 2281 22769
21 26 2281 | $libdir/ip4r


They come from ip4r extension, and when I removed them, the error went away.
FWIW, I don't think this is a hardware error, but I'll also put it on the
table. 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

[Devrim Gündüz]

Hi,

I'm trying to take backup on my laptop, but getting an error. This is
PostgreSQL 9.4.10 on Fedora 25, installed using the community RPMS.

pg_dump: could not parse numeric array "2281": too many numbers
 
I can see this string in src/bin/pg_dump/common.c, but no idea why this
happens. gdb also did not give much info:

===
Reading symbols from /usr/pgsql-9.4/bin/pg_dump...Reading symbols from 
/usr/lib/debug/usr/pgsql-9.4/bin/pg_dump.debug...done.
done.
(gdb) run
Starting program: /usr/pgsql-9.4/bin/pg_dump 
Missing separate debuginfos, use: dnf debuginfo-install glibc-2.24-4.fc25.x86_64
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib64/libthread_db.so.1".
pg_dump: could not parse numeric array "2281": too many numbers
[Inferior 1 (process 13625) exited with code 01]
===

pg_dump -v output is:

===
pg_dump: reading extensions
pg_dump: identifying extension members
pg_dump: reading schemas
pg_dump: reading user-defined tables
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://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] Install pgAudit extension

[Devrim Gündüz]

Hi,

On Tue, 2016-12-06 at 05:44 +, Dylan Luong wrote:
> I need some advice on installing the pgAudit extension as I am new to
> PostgreSQL extenstions.

Looks like you installed PostgreSQL via community RPMS, so:

https://yum.postgresql.org/9.5/redhat/rhel-6-x86_64/pgaudit_95-1.0.4-1.rhel6.x8
6_64.rpm

it means, 

yum install pgaudit_95

will do the trick for installing. Then you can create the extension with:

CREATE EXTENSION pgaudit;

You will need to add some lines to postgresql.conf. Sample ones are here:

https://github.com/devrimgunduz/pgextensionconfig/blob/master/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)

[Devrim Gündüz]

Hi Steve,

On Thu, 2016-11-10 at 07:56 -0500, Steve Clark wrote:
> 
> I installed the following package:
> postgresql94-server-9.4.9-1PGDG.rhel6.x86_64
> postgresql94-plperl-9.4.9-1PGDG.rhel6.x86_64
> postgresql94-plpython-9.4.9-1PGDG.rhel6.x86_64
> postgresql94-contrib-9.4.9-1PGDG.rhel6.x86_64
> postgresql94-devel-9.4.9-1PGDG.rhel6.x86_64
> postgresql94-libs-9.4.9-1PGDG.rhel6.x86_64
> postgresql94-9.4.9-1PGDG.rhel6.x86_64
> 
> Then tried to build pmacct and the configure complained it couldn't find the
> libpq library. I looked for
> a package-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ı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR


signature.asc
Description: This is a digitally signed message part

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

[Devrim Gündüz]

Hi,

On Mon, 2016-10-17 at 17:38 -0300, Edilmar LISTAS wrote:
> I have an env running a changed data_directory fine in a devel machine PG 9.4
> using Fedora23. 
> Now, I have a server machine with CentOS where I downloaded the RPMs from
> repo https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-6-x86_64/p
> gdg-centos96-9.6-3.noarch.rpm.
> All the configs run fine if I doesn't change the default data_directory. But
> I need to use the path /sistemas/sat4/bdpg.
> 
> I did these commands:
> 
> mkdir /sistemas/sat4/bdpg
> chown postgres /sistemas/sat4/bdpg
> chmod 700 /sistemas/sat4/bdpg
> su - postgres 
> /usr/pgsql-9.6/bin/initdb -D /sistemas/sat4/bdpg
> exit
> 
> Then, I changed data_directory to /sistemas/sat4/bdpg and tried to restart
> PG:
> service postgresql-9.6 restart
> STOP => OK
> START => FAILED

On CentOS, the appropriate way to do this is described in README file shipped
with the RPMs. Related part is:

===
As an example, let us create a secondary postmaster called, creatively enough,
'secondary'.  Here are the steps:
1.) create a hard link in /etc/rc.d/init.d (or equivalent location)
to postgresql-9.6 named 'secondary-9.6' : ln postgresql
secondary   Pick
a name not already used in /etc/rc.d/init.d!
2.) create a file in /etc/sysconfig/pgsql named secondary.  This file is
a shell script -- typically you would define PGDATA, and PGOPTS
here.  Since $PGDATA/postgresql.conf will override many of these
settings, except PGDATA, you might be surprised on startup.
3.) create the target PGDATA.
4.) Initdb the targe PGDATA as documented in the main documentation.
Automatic initdb may or may not work for you, so a manual one is
preferred.  This must be done as user 'postgres'
5.) Edit postgresql.conf to change the port, address, tcpip settings, etc.
6.) Start the postmaster with 'service 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

[Devrim Gündüz]

Hi again,

On Mon, 2016-10-03 at 00:18 +, Edson Richter wrote:
> It is not working, I get the following error:
> 
> [root@backup1 yum.repos.d]# LANG=C yum install pgadmin4 pgadmin4-web
> Loaded plugins: ulninfo
> epel/x86_64/metalink | 2.6 kB  00:00:00
> ol7_UEKR3 | 1.2 kB  00:00:00
> ol7_latest | 1.4 kB  00:00:00
> pgdg96 | 4.1 kB  00:00:00
> https://download.postgresql.org/pub/repos/yum/testing/9.6/redhat/rhel-7Server
> -x86_64/repodata/repomd.xml: 
> [Errno 14] HTTPS Error 404 - Not Found
> Trying other mirror.

Can you please try again with this?

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

[Devrim Gündüz]

Hi Edson,

On Mon, 2016-10-03 at 00:18 +, Edson Richter wrote:
> https://download.postgresql.org/pub/repos/yum/testing/9.6/redhat/rhel-7Server
> -x86_64/repodata/repomd.xml: 
> [Errno 14] HTTPS Error 404 - Not Found
> Trying other mirror.

Fixed this error, sorry for that.

> >
> >> Error: Package: python-psycopg2-debug-2.6.2-2.rhel7.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.

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ı/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

[Devrim Gündüz]

Hi,

On Sun, 2016-10-02 at 17:52 +, Edson Richter wrote:
> I'm trying to install pgAdmin4 in Oracle EL 7.
> 
> I've already installed PostgreSQL 9.6 final in same server (have EPEL
> enabled, as well pgdg 9.6 repos).
> 
> Running "yum install pgadmin4-web" I get the following result:
> Error: Package: pgadmin4-web-1.0-1.rhel7.noarch (pgdg96)
>    Requires: python-blinker >= 1.3

I've tested pgadmin4 RPMs on CentOS 7 so far, it seems even though Fedora git
says something different, blinker does not seem to appear in the RHEL and OEL
repos.

So, just added blinker to PGDG repo, under testing. If you have the latest
repository file, you can test this package with:

yum --enablerepo pgdg96-updates-testing install pgadmin4-web 

(the package will appear in next hour)

> Error: Package: python-psycopg2-debug-2.6.2-2.rhel7.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.

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] [ANNOUNCE] pgAdmin 4 v1.0 Released!

[Devrim Gündüz]

Hi,

On Fri, 2016-09-30 at 18:10 +0100, Tim Clarke wrote:
> WebViewWindow.h:20:20: fatal error: QWebView: No such file or directory

These are the -devel packages that I installed to build pgadmin4 RPMs:

BuildRequires:  mesa-libGL-devel
BuildRequires:  gcc-c++
BuildRequires:  qt5-qtbase-devel >= 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
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] Unable to log in current local time EST

[Devrim Gündüz]

Hi,

On Thu, 2016-08-25 at 11:36 -0400, Alex Lai wrote:
> I have my log_line_prefix set to
> log_line_prefix = '[%d]%p %x %c[%l] %t %i'
> in postgresql.conf
> 
> psql -c 'show timezone'
>   TimeZone
> 
>  US/Eastern
> 
> tail -2 omi_acps.log ; date
> [sipsdb]20180 0 57ab7dcd.4ed4[11895717] 2016-08-25 15:32:45 GMT
> SELECTLOG:  duration: 0.326 ms
> [sipsdb]20180 0 57ab7dcd.4ed4[11895718] 2016-08-25 15:32:45 GMT idle in
> transactionLOG:  statement: fetch all in ""
> Thu Aug 25 11:32:45 EDT 2016
> My host 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
Twitter: @DevrimGunduz , @DevrimGunduzTR


signature.asc
Description: This is a digitally signed message part

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

[Devrim Gündüz]

Hi,

On Wed, 2016-07-13 at 20:56 +, Steve Langlois wrote:
> I've been searching for a 9.2.15 version of the postgresql script for "init
> script for starting up the PostgreSQL". I have managed to find older versions
> than what we are currently using, 8.2.5 but haven't had any luck finding a
> new version in the postgres 9.2.15 rpms. We are moving from CentOS 5 to
> CentOS 7 and need to update postgres from 8.2.5 to 9.2.15.

Here is the 9.6 version: 

https://git.postgresql.org/gitweb/?p=pgrpms.git;a=blob;f=rpm/redhat/9.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,
--
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] Pg_bulkload for PostgreSql 9.5

[Devrim Gündüz]

Hi,

On Fri, 2016-06-17 at 13:29 +0200, Job wrote:
> i have some problems about compiling pg_bulkload-3.1.8 on a CentOS 5 with
> Postgresql 9.5.
> If i use a previous version of Psql it compile and works.

I just built and pushed 3.1.9 packages to yum repo for CentOS 5. They will sync
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 Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR


signature.asc
Description: This is a digitally signed message part

Re: [GENERAL] Broken after upgrade

[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 think (Fedora 23 --> 24) with a
>broken postgresql.
>
>It used to work very well. The service is started with the systemd
>unit file. I have now this error:
>
>-
>postgres@thetradinghall ➤➤ systemd/system %
>/usr/libexec/postgresql-ctl start -D /db/pgsql/data -s -w -t 270
>FATAL:  22023: database files are incompatible with server
>DETAIL:  The data directory was initialized by PostgreSQL version 9.4,
>which is not compatible with this version 9.5.3.
>---
>
>Googling it gave me some entries, but I couldn't find any clear
>explanation and how to solve. It seems I need to initiate a new
>database, but thereafter is not clear (how to use my old data and conf
>files pg_hba and pg_ident).
>
>Thank you for hints/links how to solve this issue.
>-- 
>
>google.com/+arnaudgabourygabx
>
>
>-- 
>Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-general

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.

Re: [GENERAL] .bash_profile replaced on software updates

[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 (even minor updates) the .bash_profile is replaced with the
>lines below. I was happy to see the idea of the .psql_profile added
>fairly recently, but I don't understand why the last line is commented
>out. I still have to remember to uncomment the last line in this file
>every time I update Postgres which seems to defeat the purpose.
>
>The reason I need .pgsql_profile is that lots of useful Postgres
>executables (e.g. pg_archivecleanup) are not in the postgres path. Does
>everyone just use the full path name and change this in the
>configuration file for major updates?
>
>[ -f /etc/profile ] && source /etc/profile
>PGDATA=/var/lib/pgsql/9.5/data
>export PGDATA
># If you want to customize your settings,
># Use the file below. This is not overridden
># by the RPMS.
>#[ -f /var/lib/pgsql/.pgsql_profile ] && source
>/var/lib/pgsql/.pgsql_profile
>
>
>John DeSoi, Ph.D.
>
>
>
>-- 
>Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-general

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.

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

[Devrim Gündüz]

Hi,

On Wed, 2016-04-20 at 10:43 +0300, Alex Ignatov wrote:
> Today in Big Data epoch silent data corruption becoming more and more 
> issue to afraid of. With uncorrectable read error rate ~ 10^-15  on 
> multiterabyte disk bit rot is the real issue.
> I think that today checksumming 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
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] Not signed yum repository packages

[Devrim Gündüz]

Hi,

On Tue, 2016-04-05 at 08:39 -0300, Clodoaldo Neto wrote:
> Trying to upgrade 9.4 and 9.5 in Fedora 22:
> 
> # dnf upgrade
> ...
> Error: Package postgresql94-9.4.7-1PGDG.f22.x86_64.rpm is not signed

Sorry about that, I think we are hitting a bug there. Just added missing
signatures 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




signature.asc
Description: This is a digitally signed message part

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

[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 10:05 -0500, Augori wrote:
> It installed poppler successfully but still gives the same error.  I did
> notice that it installed libpoppler 37 and the postgis2_93 install error
> seems to be looking for version 5
> [root@ip-user]# ls /usr/lib64/libpo*
> /usr/lib64/libpoppler-cpp.so/usr/lib64/libpoppler.so
> /usr/lib64/libpoppler-cpp.so.0  /usr/lib64/libpoppler.so.37
> /usr/lib64/libpoppler-cpp.so.0.2.0  /usr/lib64/libpoppler.so.37.0.0
> 
> [root@ip-ec2-user]# yum install postgis2_93 --enablerepo=epel   (same
> results both with and without the enable repo flag)
> .
> . (lots of stuff not included here)
> .
> Error: Package: gdal-libs-1.9.2-6.rhel6.x86_64 (pgdg93)
>    Requires: libpoppler.so.5()(64bit)
>  You could try using --skip-broken to work around the problem
>  You could try running: rpm -Va --nofiles --nodigest
> 
> Perhaps I should uninstall the 37 version and install the 5.0 version?  Any
> idea how to get it to install the 5.0 version?
> 
> Thanks
> 
> 
> On Sun, Feb 14, 2016 at 11:14 PM, Chris Mair <ch...@1006.org> wrote:
> 
> > 
> > Error: Package: gdal-libs-1.9.2-6.rhel6.x86_64 (pgdg93)
> > > Requires: libpoppler.so.5()(64bit)
> > >   You could try using --skip-broken to work around the problem
> > >   You could try running: rpm -Va --nofiles --nodigest
> > > 
> > 
> > Hi,
> > 
> > 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 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] Trouble installing PostGIS on Amazon Linux server

[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
>install postgis2_93, I get a notice that gdal requires a libpopper
>library.  When I --skip-broken it misses a whole bunch of dependencies
>and
>though it doesn't throw any errors,  it doesn't install.I found
>people
>complaining about this problem back in Apr 2015, but I couldn't find
>any
>resolution.  Do you folks have any suggestions?
>
># yum install postgis2_93
>Loaded plugins: priorities, update-motd, upgrade-helper
>955 packages excluded due to repository priority protections
>Resolving Dependencies
>--> Running transaction check
>---> Package postgis2_93.x86_64 0:2.1.8-1.rhel6 will be installed
>--> Processing Dependency: postgis-client = 2.1.8-1.rhel6 for package:
>postgis2_93-2.1.8-1.rhel6.x86_64
>--> Processing Dependency: geos >= 3.4.2 for package:
>postgis2_93-2.1.8-1.rhel6.x86_64
>--> Processing Dependency: proj for package:
>postgis2_93-2.1.8-1.rhel6.x86_64
>--> Processing Dependency: json-c for package:
>postgis2_93-2.1.8-1.rhel6.x86_64
>--> Processing Dependency: hdf5 for package:
>postgis2_93-2.1.8-1.rhel6.x86_64
>--> Processing Dependency: libproj.so.0()(64bit) for package:
>postgis2_93-2.1.8-1.rhel6.x86_64
>--> Processing Dependency: libjson-c.so.2()(64bit) for package:
>postgis2_93-2.1.8-1.rhel6.x86_64
>--> Processing Dependency: libgeos_c.so.1()(64bit) for package:
>postgis2_93-2.1.8-1.rhel6.x86_64
>--> Processing Dependency: libgdal.so.1()(64bit) for package:
>postgis2_93-2.1.8-1.rhel6.x86_64
>--> Running transaction check
>---> Package gdal-libs.x86_64 0:1.9.2-6.rhel6 will be installed
>--> Processing Dependency:
>libmysqlclient.so.16(libmysqlclient_16)(64bit)
>for package: gdal-libs-1.9.2-6.rhel6.x86_64
>--> Processing Dependency: libxerces-c-3.0.so()(64bit) for package:
>gdal-libs-1.9.2-6.rhel6.x86_64
>--> Processing Dependency: libtiff.so.3()(64bit) for package:
>gdal-libs-1.9.2-6.rhel6.x86_64
>--> Processing Dependency: libspatialite.so.2()(64bit) for package:
>gdal-libs-1.9.2-6.rhel6.x86_64
>--> Processing Dependency: libpoppler.so.5()(64bit) for package:
>gdal-libs-1.9.2-6.rhel6.x86_64
>--> Processing Dependency: libodbcinst.so.2()(64bit) for package:
>gdal-libs-1.9.2-6.rhel6.x86_64
>--> Processing Dependency: libodbc.so.2()(64bit) for package:
>gdal-libs-1.9.2-6.rhel6.x86_64
>--> Processing Dependency: libnetcdf.so.6()(64bit) for package:
>gdal-libs-1.9.2-6.rhel6.x86_64
>--> Processing Dependency: libmysqlclient.so.16()(64bit) for package:
>gdal-libs-1.9.2-6.rhel6.x86_64
>--> Processing Dependency: liblzma.so.0()(64bit) for package:
>gdal-libs-1.9.2-6.rhel6.x86_64
>--> Processing Dependency: libjasper.so.1()(64bit) for package:
>gdal-libs-1.9.2-6.rhel6.x86_64
>--> Processing Dependency: libgta.so.0()(64bit) for package:
>gdal-libs-1.9.2-6.rhel6.x86_64
>--> Processing Dependency: libgeotiff.so.2()(64bit) for package:
>gdal-libs-1.9.2-6.rhel6.x86_64
>--> Processing Dependency: libfreexl.so.1()(64bit) for package:
>gdal-libs-1.9.2-6.rhel6.x86_64
>--> Processing Dependency: libdapserver.so.7()(64bit) for package:
>gdal-libs-1.9.2-6.rhel6.x86_64
>--> Processing Dependency: libdapclient.so.3()(64bit) for package:
>gdal-libs-1.9.2-6.rhel6.x86_64
>--> Processing Dependency: libdap.so.11()(64bit) for package:
>gdal-libs-1.9.2-6.rhel6.x86_64
>--> Processing Dependency: libcfitsio.so.0()(64bit) for package:
>gdal-libs-1.9.2-6.rhel6.x86_64
>--> Processing Dependency: libarmadillo.so.4()(64bit) for package:
>gdal-libs-1.9.2-6.rhel6.x86_64
>--> Processing Dependency: libCharLS.so.1()(64bit) for package:
>gdal-libs-1.9.2-6.rhel6.x86_64
>---> Package geos.x86_64 0:3.4.2-1.4.amzn1 will be installed
>---> Package hdf5.x86_64 0:1.8.5.patch1-9.el6 will be installed
>---> Package json-c.x86_64 0:0.11-6.8.amzn1 will be installed
>---> Package postgis2_93-client.x86_64 0:2.1.8-1.rhel6 will be
>installed
>---> Package proj.x86_64 0:4.8.0-2.rhel6 will be installed
>--> Running transaction check
>---> Package CharLS.x86_64 0:1.0-1.el6 will be installed
>---> Package armadillo.x86_64 0:4.550.2-1.el6 will be installed
>--> Processing Dependency: liblapack.so.3()(64bit) for package:
>armadillo-4.550.2-1.el6.x86_64
>--> Processing Dependency: libclapack.so.3()(64bit) for package:
>armadillo-4.550.2-1.el6.x86_64
>--> Processing Dependency: libcblas.so.3()(64bit) for package:
>armadillo-4.550.2-1.el6.x86_64
>--> Processing Dependency: libblas.so.3()(64bit) for package:
>armadillo-4.550.2-1.el6.x86_64
>--> Processing Dependency: libarpack.so.2()(64bit) for package:
>armadillo-4.550.2-1.el6.x86_64
>---> Package cfitsio.x86_64 0:3.240-3.el6 will be installed
>---> Package compat-libtiff3.x86_64 0:3.9.4-10.13.amzn1 will be
>installed
>---> Package freexl.x86_64 0:1.0.0d-1.el6 will be installed
>---> Package 

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

[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
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR




signature.asc
Description: This is a digitally signed message part

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

[Devrim GÜNDÜZ]

Hi,

On Thu, 2016-01-21 at 10:09 -0800, John R Pierce wrote:
> the yum packages for 9.5 apparently changed the path of the socket
> from  /tmp to /var/run/postgresql

I think we use both now. If not, that must be a packaging bug. On my
boxes, I can see that the unix_socket_directory points to both.

> I have several versions installed on the same dev system running on 
> different ports  for 9.1 through 9.4 this was no problem, but
> since  I installed 9.5, I now have to specify -h /tmp -p  to
> connect to an 
> earlier version, this has raised havoc with 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, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR




signature.asc
Description: This is a digitally signed message part

Re: [GENERAL] plpython3 package absent in 9.5 repository

[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ışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR




signature.asc
Description: This is a digitally signed message part

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

[Devrim GÜNDÜZ]

Hi,

On Mon, 2016-01-18 at 06:26 +, Kaliappa, Karthic wrote:
> We are looking to upgrade our application from postgres 9.4 to 9.5,
> but we are unable to find the RPM named 'pg_catcheck-95' for RHEL (ht
> tp://yum.postgresql.org/9.5/redhat/rhel-6-x86_64/).
> Whereas it is 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 Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR




signature.asc
Description: This is a digitally signed message part

Re: [GENERAL] plpython3 package absent in 9.5 repository

[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 repositories. The
> plpython3 package exists in the Fedora repository:
> 
> http://mirror.globo.com/fedora/linux/updates/22/x86_64/p/
> 
> But it does not exist in the Postgresql repository:
> 
> https://download.postgresql.org/pub/repos/yum/9.5/fedora/fedora-22-x8
> 6_64/
> 
> 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
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR




signature.asc
Description: This is a digitally signed message part

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

[Devrim GÜNDÜZ]

Hi,

On Thu, 2015-08-27 at 12:46 -0500, Ryan King - NOAA Affiliate wrote:
> ERROR:  could not access file "$libdir/mysql_fdw": No such file or
> directory
> 
> dbname=# CREATE EXTENSION mysql_fdw;
> 
> ERROR:  could not open extension control file
> "/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.

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] pgsql-95 repo in rsync

[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ı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR





-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] looking for old rpm

[Devrim GÜNDÜZ]

Hi,

On Mon, 2015-09-21 at 09:31 +0200, Etienne Champetier wrote:
> 
> I'm looking for old postgres rpm, like
> postgresql93-server-9.3.6-1PGDG.rhel6.x86_64.rpm
> 
> (one of our software is "certified" with this minor version ...)

We don't keep those RPMS, but 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,
-- 
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR





-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pgsql-95 repo in rsync

[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?

Emailed PostgreSQL.org sysadmins, and I'll let you know when that is
done.

> 2. yum repo for Fedora 23
> Is it possible to have fedora 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://people.planetpostgresql.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 Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR





-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pgsql-95 repo in rsync

[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, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR





-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] instr detail

[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,
-- 
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR




-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

[Devrim GÜNDÜZ]

Hi,

On Thu, 2015-07-23 at 13:09 +0200, Jens Depuydt wrote:
 Is there a specific reason why plv8 doesn't get distributed anymore 
 with the Yum repositories for PostgreSQL 9.4?

I was not aware that 1.4.4 is released and it can be built cleanly.
Sorry about that.

 In the list 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
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR




-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] 9.4.2 - 9.4.3

[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 Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR




-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] PostgreSQL OGC compliant

[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
Twitter: @DevrimGunduz , @DevrimGunduzTR



signature.asc
Description: This is a digitally signed message part

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

[Devrim Gündüz]

Hi,

On Mon, 2015-05-04 at 23:05 -0700, Guyren Howe wrote:
 PGFoundry's own link to their Sample databases gives me a 404 error.
 
 http://pgfoundry.org/projects/dbsamples/
 
 Does anyone know of an alternative source for the sample databases?
 And what is going on 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: @DevrimGunduz , @DevrimGunduzTR



signature.asc
Description: This is a digitally signed message part

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

[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 installed PostgreSQL 9.4 on Oracle Linux 6.6 and its working ok (psql, 
 etc). Now I try to install pgadmin3 on the same OS.
 
 I am having problems installing pdadmin3 rpms on Oracle Linux 6.6 64-bit.I 
 selected the RedHat compatible installation i.e. without the Oracle 
 enterprise kernel.It complains about missing libwx_gtk* packages when I try 
 to do yum install pgadmin3*.86_64.rpm.
 The ISO file for Oracle Linux 6.6 (Packages directory of the distribution) 
 does not have libwx* rpms and the gtk* rpms are already installed on my 
 Oracle Linux 6.6 if I try to install them again. Perhaps I am looking in the 
 wrong place??
 Is there any document or web site which clearly tells me what i need to 
 pre-install so that I can install pgadmin3 on Oracle Linux 6.x 64-bit ?
 I prefer not downloading the source code and trying to build it all in-place, 
 so looking for binaries ready to be installed using rpm or yum. I dont have 
 Red Hat support contract, hoping to make it work on Oracle Linux 6.6 with 
 RHEL kernel.
 If this is the wrong forum for this question - please tell me where to ask 
 this question.
 many thanks in advanceYuri BudilovAUstralia   
   


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

[Devrim Gündüz]

Hi,

On Fri, 2014-11-14 at 02:57 -0700, dineshkaarthick wrote:
 I would like to know how is the Shared Disk Failover replication
 achieved if it is not possible to share the data directory ? I am
 referring to the 1st solution in the mentioned link,
 http://www.postgresql.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

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] Testing on Power 8 systems

[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: 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] Testing on Power 8 systems

[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Ü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] DBlink, postgres to DB2

[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.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR



signature.asc
Description: This is a digitally signed message part

Re: [GENERAL] PgAgent binary distribution for Centos 6.5

[Devrim Gündüz]

Hi,

On Mon, 2014-08-11 at 19:33 +0800, Jen Sing Choe wrote:
 does anyone have link to download pgagent binary distribution for centos ?
 i tried on building the tar source but stuck on resolving the wxGTK
 (wxWidget) dependencies.

I pushed pgagent 3.4.0 RPMs to PostgreSQL RPM repo 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

[Devrim Gündüz]

Hi,

On Thu, 2014-08-28 at 03:22 +, Yogesh. Sharma wrote:

 I want to upgrade RHEL 5.4 to RHEL 6.5.
 So, could you please let me know, which postgresql version is stable
 for RHEL 6.5?

Any supported PostgreSQL version is available in the yum repository: 

http://yum.postgresql.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

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

[Devrim Gündüz]

Hi,
On Wed, 2014-06-04 at 17:50 +0530, Bhushan Pathak wrote:

 The RPM get installed successfully, but when I issue the service
 postgresql-9.2 initdb command, it gets stuck for 5-10 minutes  then
 says failed. The pgstartup.log file has only 1 line -
 Segmentation fault (core dumped)

Can you please edit /etc/init.d/postgresql-9.2, go to line 235 which is
like this:

http://svn.pgrpms.org/browser/rpm/redhat/9.2/postgresql/EL-6/postgresql.init#L235

and then add -d parameter after initdb, and run it again? This will
throw debug messages to log file, which may 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 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] CentOS 6 and Postgresql 9.3.4 from PGDG

[Devrim GÜNDÜZ]

Hi,

On Mon, 2014-04-14 at 09:13 -0400, Steve Clark wrote:
 How did you deal with binaries and libraries, as well as third party
 apps like perl modules or php/apache modules?

I added Provides: to each package, along with a ldconfig file, so that
the dependencies are satisfied.

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

[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 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?

Regards...

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.

Re: [GENERAL] configure errors on Fedora 20

[Devrim GÜNDÜZ]

Hi,

On Fri, 2014-03-21 at 17:30 -0600, CS_DBA wrote:

 when I try to compile postgresql 9.3.4 I get the below errors, anyone 
 know if / which devel packages I need?

http://svn.pgrpms.org/browser/rpm/redhat/9.3/postgresql/F-20/postgresql-9.3.spec#L95
 

and the rest of the lines that 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 , @DevrimGunduzTR




signature.asc
Description: This is a digitally signed message part

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

[Devrim GÜNDÜZ]

Hi,

On Wed, 2014-01-22 at 11:07 -0800, Susan Cassidy wrote:
 It wasn't installed in the yum package that we used to install
 postgres 9.2. 

This has nothing to do with the RPMs -- PL/pgSQL is installed by
defaults since 9.0. As Adrian wrote, you will need to omit the file path
there (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

[Devrim GÜNDÜZ]

Hi,

On Tue, 2014-02-11 at 21:07 +, Brahim SABIRI wrote:

 During installation of installation of postgresql9.3.2 on red hat 5.5
 64bits, I have the problem with C compiler :
 
 *configure: error: in '/root/postgresql-9.3.2':*
 *configure: error: C compiler 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.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] pg_config problems on PG9.3/Centos?

[Devrim GÜNDÜZ]

Hi,

On Tue, 2014-01-21 at 13:18 -0800, Ken Tanzer wrote:

 Oddly, there was a pg_config in /usr/bin that was not a symlink and
 not owned by any package.  I'm really puzzled as to how it got there,
 but I removed it, and symlinked the one from /usr/pgsql-9.3/bin.  It
 puts out better information.

Please don't do it. PGDG RPMs are designed for parallel installation
(like 9.2 and 9.3 on the same machine), and then the pg_config in
regular $PATH might be tricky. 

Anyway:

 I know the table_log packages are kind of ancient, but they do the
 trick!
 
 table_log.c: In function ‘table_log’:
 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
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] pg_config problems on PG9.3/Centos?

[Devrim GÜNDÜZ]

Hi,

On Tue, 2014-01-21 at 18:00 -0800, Ken Tanzer wrote:
 It didn't seem like a great idea to me either, but what's the better
 alternative?  Without the symlink I get lots of errors:
 
 make USE_PGXS=1
 make: pg_config: Command not found

Sometimes exporting 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ı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR




signature.asc
Description: This is a digitally signed message part

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

[Devrim GÜNDÜZ]

Hi,

On Mon, 2014-01-20 at 15:46 +0800, Sameer Kumar wrote:

 I have downloaded the tar source code of PostgreSQL and also the SPEC file.
 I am trying to use rpmbuild command but I always get below error:
 
 error: Failed build dependencies:
 uuid-devel is needed by postgresql92-9.2.6-1PGDG.el6.ppc64
 selinux-policy = 3.9.13 is needed by
 postgresql92-9.2.6-1PGDG.el6.ppc64

You are not using the correct spec file -- the one you are using is for
Fedora. Use RHEL spec file:

http://svn.pgrpms.org/repo/rpm/redhat/9.2/postgresql/EL-6/

(Also, this email do not belong to -hackers. You don't need to
cross-post here)

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




signature.asc
Description: This is a digitally signed message part

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

[Devrim GÜNDÜZ]

Hi,

On Mon, 2014-01-20 at 17:05 +0800, Craig Ringer wrote:

 Rather than attempting to build PostgreSQL packages, why not use the
 existing PGDG packages from http://yum.postgresql.org/ for RHEL /
 CentOS 6?

I think Sameer is working on a ppc build, which we do not support (yet,
at least).

 If you need to patch them, then you should be able to just yum
 install yum-utils, yumdownloader --source postgres to get the srpm,
 rpm -i the srpm into your ~/RPMBUILD directory, and make any
 appropriate modifications before rebuilding.

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




signature.asc
Description: This is a digitally signed message part

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

[Devrim GÜNDÜZ]

Hi,

On Fri, 2013-12-06 at 10:30 +, Albe Laurenz wrote:
 Start looking here:
 http://yum.postgresql.org/srpms/9.3/redhat/rhel-6-x86_64/repoview/postgresql93.html
 
 The source RPMs contain the spec file.

Also, http://svn.pgrpms.org/browser/rpm/redhat/9.3/postgresql/ is the
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://twitter.com/devrimgunduz


signature.asc
Description: This is a digitally signed message part

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

[Devrim GÜNDÜZ]

Hi,

On Wed, 2013-11-13 at 12:28 +0100, Alexander Farber wrote:
 Hello,
 
 on CentOS 6.4 I'm moving from 8.4 to 9.3, but can not find the file
 /var/lib/pgsql/9.3/data/global/pg_auth which I need for the pg_bouncer.
 
 Does anybody please know where to find that file?

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.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz


signature.asc
Description: This is a digitally signed message part

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

[Devrim GÜNDÜZ]

Hi,

On Wed, 2013-11-13 at 12:58 +0100, Alexander Farber wrote:

 The man 5 pgbouncer is slightly outdated then,
 it doesn't explain the auth_file format in detail:
 
auth_file
The name of the file to load user names and passwords from. The
 file format is the same as the PostgreSQL
pg_auth/pg_pwd file, so this setting can be pointed directly to
 one of those backend files.
 
 What is the 3rd column of the file used for?
 (the 1st being username and
 the 2nd being md5 hashed password)

There are 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 Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz


signature.asc
Description: This is a digitally signed message part

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

[Devrim GÜNDÜZ]

Hi,

On Fri, 2013-07-05 at 17:47 +0800, guxiaobo1982 wrote:
 I installed postgreSQL 9.3 beta 2 from
 http://yum.postgresql.org/repopackages.php#pg92 following
 http://www.postgresonline.com/journal/archives/203-postgresql90-yum.html
 
 
 But I cann't find pg_config, 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://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz


signature.asc
Description: This is a digitally signed message part

Re: [GENERAL] Build RPM from Postgres Source

[Devrim GÜNDÜZ]

Hi,

On Fri, 2013-07-12 at 14:37 -0700, ktewari1 wrote:
 Hi,
 I need to have some different settings(like NAMEDATALEN  etc.) and
 that's why I'm trying to build postgres from the source and to create an rpm
 to be send for install. 
 
 Now, the build works fine but, I don't see a way to create an RPM.

Here is how we build the community RPMs:

* Fetch patches and spec files from SVN. For example:

http://svn.pgrpms.org/browser/rpm/redhat/9.2/postgresql/EL-6/

* Add any patches to spec file:

http://svn.pgrpms.org/browser/rpm/redhat/9.2/postgresql/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~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz


signature.asc
Description: This is a digitally signed message part

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

[Devrim GÜNDÜZ]

Hi,

On Sat, 2013-04-06 at 17:16 -0400, Jared Beck wrote:
 I know Centos 4 is EOL, but will there be a REL/Centos 4 release of
 postgres 8.4.17?  The latest here is 8.4.16:
 
 http://yum.postgresql.org/8.4/redhat/rhel-4-i386/repoview/
 

One of our aims is making people happy ;) 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://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz


signature.asc
Description: This is a digitally signed message part

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

[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 pg_hba.conf have limited the allowed IP
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

[Devrim Gündüz]

Hi,

No idea what happened, but fixed. Thanks for the report.

Regards, Devrim

René Romero Benavides ichbinr...@gmail.com 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.xml?

-- 
René 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

[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, postgresql 
 yapılandırması nasıl olmaldır? Devrim Bey'in postgresql konferansında 
 saniyede 200.000 gibi bir rakamdan bahsettiğini hatırlıyorum ama 
 detayları nasıldır bilmiyorum.
 Herkese merhaba,
 Saniyede 10 bin kayıt alacak bir sistem kurmam gerekiyor. Bunu
 PostgreSQL ile nasıl yapabilirim? Donanım konfigürasyonu, postgresql
 yapılandırması nasıl olmaldır? Devrim Bey'in postgresql konferansında
 saniyede 200.000 gibi bir rakamdan bahsettiğini hatırlıyorum ama
 detayları nasıldır bilmiyorum.
 -- 
 Melik YÜCEL
 Araştırmacı
 Siber Güvenlik Enstitüsü
 TÜBİTAK BİLGEM 
 41470 
 GEBZE / KOCAELİ 
 T +90 262 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 @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz


signature.asc
Description: This is a digitally signed message part

[GENERAL] PostgreSQL Live CD for 9.2.3 released

[Devrim GÜNDÜZ]

I released fifth version of PostgreSQL live CD, which is based
on PostgreSQL 9.2 and CentOS 6.3. It includes many of the PostgreSQL
related packages that I build for http://yum.postgresql.org , along with
PostgreSQL 9.2.3.

Details are here:

http://pglivecd.org
http://yum.postgresql.org/livecd.php

You can add an encrypted home directory while burning iso to USB stick,
which helps you to keep your personal data in your USB stick.

This live CD has current versions of many software, like pgAdmin
III, phpPgAdmin, Apache, PHP, GNOME, Pidgin, Firefox etc., along with
tons of PostgreSQL related 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://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz


signature.asc
Description: This is a digitally signed message part

Re: [GENERAL] PostgreSQL Live CD for 9.2.3 released

[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 Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz


signature.asc
Description: This is a digitally signed message part

Re: [GENERAL] 9.2 RHEL6 yum Repository broken?

[Devrim GÜNDÜZ]

Hi,

On Wed, 2013-02-13 at 12:03 +0900, Jeffrey Jones wrote:

 As I can tell the PostgreSQL 9.2 yum repository for use with RHEL6 
 (64bit) is broken.
 
 On a fresh RHEL6.3 (64-bit) installation, as root, run the following 
 commands:
 
 rpm -i 
 http://yum.postgresql.org/9.2/redhat/rhel-6-x86_64/pgdg-redhat92-9.2-7.noarch.rpm
 yum update
 
 (As stated in the instructions on 
 http://www.postgresql.org/download/linux/redhat/)
 
 The yum update command fails with the following message (had to copy by 
 hand; please forgive formatting strangeness):
 
 pgdg92| 2.8 kb 00:00
 pgdg92/primary_db | 103 kb 00:00
 http://yum.postgresql.org/9.2/redhat/rhel-6Server-x86_64/repodata/primary.sqlite.bz2:
  
 [Errno -1] Metadata file does not match checksum
 Trying other mirror

That should not 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 times. You were probably
caught between them.

Regards,

-- 
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz


signature.asc
Description: This is a digitally signed message part

Re: [GENERAL] 9.2 RHEL6 yum Repository broken?

[Devrim GÜNDÜZ]

Hi,

On Wed, 2013-02-13 at 17:27 +0900, Jeffrey Jones wrote:

 I have run the commands as you specified but unfortunately the error 
 pops up again when I run yum makecache.

Same error? That is *almost* impossible -- makecache is the parameter to
get rid of that error, not to see that 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  Twitter: http://twitter.com/devrimgunduz


signature.asc
Description: This is a digitally signed message part

Re: [GENERAL] 9.2 RHEL6 yum Repository broken?

[Devrim GÜNDÜZ]

Hi,

On Wed, 2013-02-13 at 17:49 +0900, Jeffrey Jones wrote:
 I had to type from console to so maintain formatting I put it on a
 paste  site:
 
 https://gist.github.com/rurounijones/4943156
This is interesting:

Error: failure: repodata/primary.sqlite.bz2 from pgsg92: [Errno] No 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~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz


signature.asc
Description: This is a digitally signed message part

Re: [GENERAL] undefined symbol: SPI_plan_get_cached_plan

[Devrim GÜNDÜZ]

Hi,

On Mon, 2013-02-11 at 09:47 -0500, Tom Lane wrote:
  After restarting the postgres service, the error went away.
 
 So you had upgraded, but not actually restarted the server ...
 just for future reference, SLES apparently doesn't do a service
 restart automatically 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 Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz


signature.asc
Description: This is a digitally signed message part

Re: [GENERAL] PG V9 on NFS

[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
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz


signature.asc
Description: This is a digitally signed message part

[GENERAL] Replacement for Oracle Workspace Manager

[Devrim GÜNDÜZ]

Hi,

Oracle has a product called Oracle Workspace Manager:

http://www.oracle.com/technetwork/database/enterprise-edition/index-087067.html

Website says:

Workspace Manager, a feature of Oracle Database, enables application
developers and DBAs to manage current, proposed and historical versions
of data in the same database.

Applications and DBA operations often work with more than one version of
the data. Three common reasons to have multiple data versions are
concurrency, auditing and scenario creation. Oracle Workspace Manager
provides workspaces as a virtual environment to isolate a collection of
changes to production data, keep a history of changes to data and create
multiple data scenarios for “what if” analysis. It can save money, time
and labor over traditional approaches.

Does anyone know any approach to replace this product with something in
PostgreSQL world? 

Regards,
-- 
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz


signature.asc
Description: This is a digitally signed message part

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

[Devrim GÜNDÜZ]

Hi,

On Thu, 2013-01-17 at 10:03 -0800, Paul Jungwirth wrote:
 Is there any way to determine, by querying pg_index and other pg_* tables,
 whether an index was created as `USING something`? I've already got a big
 query joining pg_class, pg_index, etc. to pull out various attributes 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.

Regards,
-- 
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz


signature.asc
Description: This is a digitally signed message part

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

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

listen_addresses = 'pgsql-dbms.hamilton.harte-lyne.ca, localhost'
#port = 5432   # (change requires restart)
port = 5433

However, I am getting this error when I try to start the new version
while the old one is still running.  Is there something else I must do
to accomplish this?  Why is the lock file using the default port
number for this instance?

cat ../pgstartup.log
2012-12-14 09:13:41 EST: LOG:  XX000: could not bind IPv4 socket:
Address already in use
2012-12-14 09:13:41 EST: HINT:  Is another postmaster already
running on port 5432? If not, wait a few seconds and retry.
2012-12-14 09:13:41 EST: LOCATION:  StreamServerPort, pqcomm.c:438
2012-12-14 09:13:41 EST: WARNING:  01000: could not create listen
socket for pgsql-dbms.hamilton.harte-lyne.ca
2012-12-14 09:13:41 EST: LOCATION:  PostmasterMain,
postmaster.c:892
2012-12-14 09:13:41 EST: FATAL:  F0001: lock file
/tmp/.s.PGSQL.5432.lock already exists
2012-12-14 09:13:41 EST: HINT:  Is another postmaster (PID 1299)
using socket file /tmp/.s.PGSQL.5432?
2012-12-14 09:13:41 EST: LOCATION:  CreateLockFile, miscinit.c:822


-- 
***  E-Mail is NOT a SECURE channel  ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte  Lyne Limited  http://www.harte-lyne.ca
9 Brockley Drive  vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada  L8E 3C3



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

-- 
Sent from my Android phone with K-9 Mail. Please excuse my brevity.

Re: [GENERAL] 9.2.2 RH, Fedora

[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: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz


signature.asc
Description: This is a digitally signed message part

Re: [GENERAL] Mailing list Question

[Devrim GÜNDÜZ]

Hi,

On Fri, 2012-11-30 at 10:21 -0500, Bijelic, Aleksandra (Lexi) wrote:
 Is possible to create a shared-storage postgresql server cluster?

If you want both nodes as active, then you need to use Postgres-XC:

http://postgres-xc.sourceforge.net/

If you want active/passive solution, then you 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.org  Twitter: http://twitter.com/devrimgunduz


signature.asc
Description: This is a digitally signed message part

Re: [GENERAL] Fuzzystrmatch contrib module on RHEL63

[Devrim GÜNDÜZ]

Hi,

On Sun, 2012-11-18 at 21:13 -0500, Ike Nnabugwu wrote:
 I am building an rpm package fuzzystrmatch to be installed on RHEL63 but  I
 do not know  where to get the modules for it.I will appreciate any pointers
 that will assist with this task.

All contrib modules are already available in -contrib subpackage,
including fuzzystrmatch, which is available for RHEL 6.3. If you want a
package that contains only that module for some reason, take a look at
this spec file:

http://svn.pgrpms.org/browser/rpm/redhat/9.2/postgresql/EL-6/postgresql-9.2.spec

It will give you some idea 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://twitter.com/devrimgunduz


signature.asc
Description: This is a digitally signed message part

Re: [GENERAL] remote connection refused

[Devrim GÜNDÜZ]

Hi,

On Mon, 2012-11-19 at 13:08 +0100, Yvon Thoraval wrote:
 in such  a situation what is your checklist in order to find what I've
 missed ? 

What is listen_addresses in postgresql.conf ? It should be * or so.
Also, I would make sure that there is not a firewall on the machine
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


signature.asc
Description: This is a digitally signed message part

Re: [GENERAL] Understanding streaming replication

[Devrim GÜNDÜZ]

Hi,

On Tue, 2012-11-13 at 09:40 +0100, Albe Laurenz wrote:
 
 The only thing I have seen is RedHat's Cluster Suite, which
 is commercial.  

Depends. It is open source, and all components are also available in
CentOS and Scientific Linux, and there are companies out there who
support 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.com/devrimgunduz


signature.asc
Description: This is a digitally signed message part

Re: [GENERAL] shared memory settings

[Devrim GÜNDÜZ]

Hi,

On Wed, 2012-09-26 at 13:39 +0400, Alexander Shutyaev wrote:

 We need to increase max_connections to 3000. When we tried to do this
 we got an error 

snip

Not an answer to your question but: Are you talking about 3k
*concurrent* connections? What are the server specs? I am not sure you
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 Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz


signature.asc
Description: This is a digitally signed message part

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

[Devrim GÜNDÜZ]

Hi,

On Wed, 2012-09-12 at 20:51 -0700, Mike Christensen wrote:
 In file included from ../pgadmin/include/pgAdmin3.h:24:0,
  from ./pgAdmin3.cpp:13:
 ../pgadmin/include/ctl/ctlSQLBox.h:17:24: fatal error: wx/stc/stc.h:
 No such file or directory
 compilation terminated. 

Here is the buildRequires that I found on a SuSE spec for pgadmin3:

BuildRequires:  automake
BuildRequires:  gcc-c++
BuildRequires:  libopenssl-devel
BuildRequires:  libxml2-devel
BuildRequires:  libxslt-devel
BuildRequires:  postgresql-devel
BuildRequires:  update-desktop-files
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
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz


signature.asc
Description: This is a digitally signed message part

Re: [GENERAL] CentOS initd Script

[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,
-- 
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz


signature.asc
Description: This is a digitally signed message part