pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: jv.cyril@gmail.com
Subject: BUG #16508: using multi-host connection string when the first host is starting fails
Date: Wed, 24 Jun 2020 08:17:44 +0000
Message-ID: <16508-1a63222835164566@postgresql.org> (raw)

The following bug has been logged on the website:

Bug reference:      16508
Logged by:          Cyril Jouve
Email address:      jv.cyril@gmail.com
PostgreSQL version: 10.11
Operating system:   rhel7
Description:        

Hello,

I'm connection to pg10 using psql (tried with clients psql 10.11 & psql
12.2) using a connection string such as:
psql 'dbname=xxxxx1,xxxxx2,xxxxx3,xxxxx4 target_session_attrs=read-write'

the connection to first database (xxxxx1) fail with the error:
psql.bin: FATAL:  the database system is starting up

which is correct according to postgres state on that machine,
but then I would expect the psql tries the next server (xxxxx2) with is in
the one acceptiong the connection params (target_session_attrs=read-write)

instead of the error.

If I swap the connection parameters like this: psql
'dbname=xxxxx2,xxxxx1,xxxxx3,xxxxx4 target_session_attrs=read-write'
(swapped xxxx1/xxxx2), psql is able to connect to xxxxx2.



view thread (5+ messages)  latest in thread

Message-ID: <16508-1a63222835164566@postgresql.org>
Permalink:  ../16508-1a63222835164566@postgresql.org/
Also on:    postgresql.org/message-id/16508-1a63222835164566@postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, jv.cyril@gmail.com
  Subject: Re: BUG #16508: using multi-host connection string when the first host is starting fails
  In-Reply-To: <16508-1a63222835164566@postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox