Re: [GENERAL] [BUGS] Fwd: PostgreSQL 9.4.13 is facing issue in shutting down

On Tue, Aug 22, 2017 at 1:58 PM, Abhijit Gharami wrote: > Recently we have updated our PostgreSQL version from 9.4.12 to 9.4.13. With > version 9.4.13 while trying to stop the PostgreSQL server, database is > facing issues in shutting down. The problem probably occurs

[GENERAL] Fwd: PostgreSQL 9.4.13 is facing issue in shutting down

Hi, Recently we have updated our PostgreSQL version from 9.4.12 to 9.4.13. With version 9.4.13 while trying to stop the PostgreSQL server, database is facing issues in shutting down. The problem probably occurs because of the WAL sender process not getting terminated on shutdown request. ps

Re: [GENERAL] pg_rewind - restore new slave failed to startup during recovery

Thanks Michael. > First things first. What is the version of PostgreSQL involved here? The PostgreSQL is version 9.6. >4 is the number of the last timeline the promoted standby has been using, >right? The history file in pg_xlog, is dated at the time of promotion on the standby (current

[GENERAL] What is the proper query

Hi, ALL, draft=# SELECT * FROM information_schema.key_column_usage WHERE table_schema = 'public' AND table_name = 'leaguescorehitter'; constraint_catalog | constraint_schema |constraint_name | table_catalog | table_schema |table_name | column_name | ordinal_position |

Re: [GENERAL] Porting libpq to QNX 4.25

On Mon, 21 Aug 2017 13:27:56 -0300, marcelo wrote: >Is there a libpq porting to QNX 4.25? I just tried to compile one of the >modules, but was rejected because the QNX's standard library have not an >Int64 type. >TIA QNX 4.25 is very old (mid 90's) - its toolchain

Re: [GENERAL] pg_rewind - restore new slave failed to startup during recovery

On Tue, Aug 22, 2017 at 9:52 AM, Dylan Luong wrote: > I have 1 master and 1 slave wal streaming replication setup and the > Application connects via a load balancer (LTM) where the all connections are > redirected to the master member (master db). > > We have

[GENERAL] Porting libpq to QNX 4.25

Is there a libpq porting to QNX 4.25? I just tried to compile one of the modules, but was rejected because the QNX's standard library have not an Int64 type. TIA -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] Selecting some schema not suported for libpq PQconnectdbParams

Thank you Jerry. I read about "server parameters" as options, but forgotten search_path. On 20/08/17 20:11, Jerry Sievers wrote: marcelo writes: The system I'm building needs to connect some QNX 4.x machines to the Postgres' server (by the way, a Linux machine).

Re: [GENERAL] make postgresql 9.5 default on centos 7

Oops, one correction - instead of systemctl initdb postgresql-9.6 please use /usr/pgsql-9.6/bin/postgresql96-setup initdb as explained at https://wiki.postgresql.org/wiki/YUM_Installation Regards Alex

Re: [GENERAL] make postgresql 9.5 default on centos 7

Hi Steve, On Fri, Aug 18, 2017 at 7:50 PM, 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