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

2017-08-21 Thread Abhijit Gharami
The client is a Hot Standby server. Regards, Abhijit On Tue, Aug 22, 2017 at 11:05 AM, Michael Paquier wrote: > 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 th

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

2017-08-21 Thread Michael Paquier
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 because of the > WAL sender p

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

2017-08-21 Thread Abhijit Gharami
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 outpu

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

2017-08-21 Thread Dylan Luong
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 maste

[GENERAL] What is the proper query

2017-08-21 Thread Igor Korot
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 | position_in

Re: [GENERAL] Porting libpq to QNX 4.25

2017-08-21 Thread George Neuner
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 compiler would be C90 unless

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

2017-08-21 Thread Michael Paquier
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 archive_mode enabled. First things fi

[GENERAL] Porting libpq to QNX 4.25

2017-08-21 Thread marcelo
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: http://www.postgresql.or

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

2017-08-21 Thread marcelo
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). Of course, it will be done t