Thread

1. Getting error while running the pg_basebackup through PGBOUNCER

   Raghavendra Rao J S V <raghavendrajsv@gmail.com> — 2019-04-08T13:21:17Z

   Hi All,
   
   We are using PGBOUNCER(connection pool mechanisam). PGBOUNCER uses port
   5433.
   
   Postgres database port number is 6433. By using port 5433 PGBOUNCER is
   connecting to postgres port 6433 database.
   
   Now PGBOUNCER is establishing the connections properly but when I try to
   run the pg_basebackup through port 5433(PGBOUNCER port) we are receiving
   below error. Please guide me.
   
   
    /opt/postgres/9.2/bin/pg_basebackup -p 5433 -U postgres -P -v -x
   --format=tar --gzip --compress=1 --pgdata=- -D /opt/rao
   
   *pg_basebackup: could not connect to server: ERROR:  Unsupported startup
   parameter: replication*
   
   
   -- 
   Regards,
   Raghavendra Rao J S V
   

2. Re: Getting error while running the pg_basebackup through PGBOUNCER

   Pavel Stehule <pavel.stehule@gmail.com> — 2019-04-08T13:46:11Z

   po 8. 4. 2019 v 15:42 odesílatel Raghavendra Rao J S V <
   raghavendrajsv@gmail.com> napsal:
   
   > Hi All,
   >
   > We are using PGBOUNCER(connection pool mechanisam). PGBOUNCER uses port
   > 5433.
   >
   > Postgres database port number is 6433. By using port 5433 PGBOUNCER is
   > connecting to postgres port 6433 database.
   >
   > Now PGBOUNCER is establishing the connections properly but when I try to
   > run the pg_basebackup through port 5433(PGBOUNCER port) we are receiving
   > below error. Please guide me.
   >
   >
   >  /opt/postgres/9.2/bin/pg_basebackup -p 5433 -U postgres -P -v -x
   > --format=tar --gzip --compress=1 --pgdata=- -D /opt/rao
   >
   > *pg_basebackup: could not connect to server: ERROR:  Unsupported startup
   > parameter: replication*
   >
   
   looks like pgbouncer cannot to forward connection parameter "replication"
   
   Why you need pgbouncer for pg_basebackup? It has not too mach sense.
   
   Pavel
   
   
   >
   > --
   > Regards,
   > Raghavendra Rao J S V
   >
   >
   

3. RE: Getting error while running the pg_basebackup through PGBOUNCER

   Scot Kreienkamp <scot.kreienkamp@la-z-boy.com> — 2019-04-08T13:46:13Z

   Replication and several other admin type operations must connect directly to PG.  They are not supported through PGBouncer.
   
   From: Raghavendra Rao J S V [mailto:raghavendrajsv@gmail.com]
   Sent: Monday, April 8, 2019 9:21 AM
   To: pgsql-general@lists.postgresql.org
   Subject: Getting error while running the pg_basebackup through PGBOUNCER
   
   
   ATTENTION:   This email was sent to La-Z-Boy from an external source.     Be vigilant when opening attachments or clicking links.
   Hi All,
   
   We are using PGBOUNCER(connection pool mechanisam). PGBOUNCER uses port 5433.
   
   Postgres database port number is 6433. By using port 5433 PGBOUNCER is connecting to postgres port 6433 database.
   
   Now PGBOUNCER is establishing the connections properly but when I try to run the pg_basebackup through port 5433(PGBOUNCER port) we are receiving below error. Please guide me.
   
   
    /opt/postgres/9.2/bin/pg_basebackup -p 5433 -U postgres -P -v -x --format=tar --gzip --compress=1 --pgdata=- -D /opt/rao
   
   pg_basebackup: could not connect to server: ERROR:  Unsupported startup parameter: replication
   
   
   --
   Regards,
   Raghavendra Rao J S V
   

4. Re: Getting error while running the pg_basebackup through PGBOUNCER

   Raghavendra Rao J S V <raghavendrajsv@gmail.com> — 2019-04-08T14:19:01Z

   Thank you very much for your prompt response.
   
   Could you explain other admin type operations, which are not supported by
   pgbouncer?
   
   Regards,
   Raghavendra Rao.
   
   On Mon, 8 Apr 2019 at 19:16, Scot Kreienkamp <Scot.Kreienkamp@la-z-boy.com>
   wrote:
   
   > Replication and several other admin type operations must connect directly
   > to PG.  They are not supported through PGBouncer.
   >
   >
   >
   > *From:* Raghavendra Rao J S V [mailto:raghavendrajsv@gmail.com]
   > *Sent:* Monday, April 8, 2019 9:21 AM
   > *To:* pgsql-general@lists.postgresql.org
   > *Subject:* Getting error while running the pg_basebackup through PGBOUNCER
   >
   >
   >
   >
   > *ATTENTION:   This email was sent to La-Z-Boy from an external source.
   > Be vigilant when opening attachments or clicking links.*
   >
   > Hi All,
   >
   >
   >
   > We are using PGBOUNCER(connection pool mechanisam). PGBOUNCER uses port
   > 5433.
   >
   >
   >
   > Postgres database port number is 6433. By using port 5433 PGBOUNCER is
   > connecting to postgres port 6433 database.
   >
   >
   >
   > Now PGBOUNCER is establishing the connections properly but when I try to
   > run the pg_basebackup through port 5433(PGBOUNCER port) we are receiving
   > below error. Please guide me.
   >
   >
   >
   >
   >
   >  /opt/postgres/9.2/bin/pg_basebackup -p 5433 -U postgres -P -v -x
   > --format=tar --gzip --compress=1 --pgdata=- -D /opt/rao
   >
   >
   >
   > *pg_basebackup: could not connect to server: ERROR:  Unsupported startup
   > parameter: replication*
   >
   >
   >
   >
   >
   > --
   >
   > Regards,
   > Raghavendra Rao J S V
   >
   
   
   -- 
   Regards,
   Raghavendra Rao J S V
   Mobile- 8861161425
   

5. RE: Getting error while running the pg_basebackup through PGBOUNCER

   Scot Kreienkamp <scot.kreienkamp@la-z-boy.com> — 2019-04-08T14:40:36Z

   Basically anything that is not written as a sql query should be connected directly to PG.  PGBouncer is really only meant for SQL query type connections.
   
   From: Raghavendra Rao J S V [mailto:raghavendrajsv@gmail.com]
   Sent: Monday, April 8, 2019 10:19 AM
   To: Scot Kreienkamp <Scot.Kreienkamp@la-z-boy.com>
   Cc: pgsql-general@lists.postgresql.org
   Subject: Re: Getting error while running the pg_basebackup through PGBOUNCER
   
   
   ATTENTION:   This email was sent to La-Z-Boy from an external source.     Be vigilant when opening attachments or clicking links.
   Thank you very much for your prompt response.
   
   Could you explain other admin type operations, which are not supported by pgbouncer?
   
   Regards,
   Raghavendra Rao.
   
   On Mon, 8 Apr 2019 at 19:16, Scot Kreienkamp <Scot.Kreienkamp@la-z-boy.com<mailto:Scot.Kreienkamp@la-z-boy.com>> wrote:
   Replication and several other admin type operations must connect directly to PG.  They are not supported through PGBouncer.
   
   From: Raghavendra Rao J S V [mailto:raghavendrajsv@gmail.com<mailto:raghavendrajsv@gmail.com>]
   Sent: Monday, April 8, 2019 9:21 AM
   To: pgsql-general@lists.postgresql.org<mailto:pgsql-general@lists.postgresql.org>
   Subject: Getting error while running the pg_basebackup through PGBOUNCER
   
   
   ATTENTION:   This email was sent to La-Z-Boy from an external source.     Be vigilant when opening attachments or clicking links.
   Hi All,
   
   We are using PGBOUNCER(connection pool mechanisam). PGBOUNCER uses port 5433.
   
   Postgres database port number is 6433. By using port 5433 PGBOUNCER is connecting to postgres port 6433 database.
   
   Now PGBOUNCER is establishing the connections properly but when I try to run the pg_basebackup through port 5433(PGBOUNCER port) we are receiving below error. Please guide me.
   
   
    /opt/postgres/9.2/bin/pg_basebackup -p 5433 -U postgres -P -v -x --format=tar --gzip --compress=1 --pgdata=- -D /opt/rao
   
   pg_basebackup: could not connect to server: ERROR:  Unsupported startup parameter: replication
   
   
   --
   Regards,
   Raghavendra Rao J S V
   
   
   --
   Regards,
   Raghavendra Rao J S V
   Mobile- 8861161425
   

6. Re: Getting error while running the pg_basebackup through PGBOUNCER

   Adrian Klaver <adrian.klaver@aklaver.com> — 2019-04-08T18:02:02Z

   On 4/8/19 7:19 AM, Raghavendra Rao J S V wrote:
   > Thank you very much for your prompt response.
   > 
   > Could you explain other admin type operations, which are not supported 
   > by pgbouncer?
   
   I would say anything you could not run through psql.
   
   > 
   > Regards,
   > Raghavendra Rao.
   
   
   
   -- 
   Adrian Klaver
   adrian.klaver@aklaver.com