[pgpool-general: 8339] authentication error
Todd Stein
todd.stein at microfocus.com
Thu Jul 14 00:33:19 JST 2022
I've seen this before and gotten past it, but don't remember how I did it.
-bash-4.2$ psql -h 10.78.121.250 -p 9999 -U pgpool postgres -c "show pool_nodes"
Password for user pgpool:
psql: error: ERROR: backend authentication failed
DETAIL: backend response with kind 'E' when expecting 'R'
ERROR: backend authentication failed
DETAIL: backend response with kind 'E' when expecting 'R'
-bash-4.2$ yum list installed | grep pgpool
pgpool-II-pg13.x86_64 4.3.2-1pgdg.rhel7 @pgpool43
pgpool-II-pg13-debuginfo.x86_64 4.3.2-1pgdg.rhel7 @pgpool43
pgpool-II-pg13-devel.x86_64 4.3.2-1pgdg.rhel7 @pgpool43
pgpool-II-pg13-extensions.x86_64 4.3.2-1pgdg.rhel7 @pgpool43
pgpool-II-release.noarch 4.3-1 @/pgpool-II-release-4.3-1.noarch
-bash-4.2$ yum list installed | grep postgres
postgresql13.x86_64 13.7-1PGDG.rhel7 @pgdg13
postgresql13-contrib.x86_64 13.7-1PGDG.rhel7 @pgdg13
postgresql13-libs.x86_64 13.7-1PGDG.rhel7 @pgdg13
postgresql13-server.x86_64 13.7-1PGDG.rhel7 @pgdg13
Regards,
Todd Stein
-----Original Message-----
From: pgpool-general <pgpool-general-bounces at pgpool.net> On Behalf Of Tatsuo Ishii
Sent: Tuesday, July 12, 2022 9:55 PM
To: dcristini at gmail.com
Cc: pgpool-general at pgpool.net
Subject: [pgpool-general: 8337] Re: Problems starting pgpgool
Glad to hear that!
> That was exactly the problem. Thanks a lot
>
> On Tue, Jul 12, 2022 at 9:37 PM Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
>
>> Not reproduced here (Ubuntu 20). Maybe OS setting problem?
>>
>>
>> https://stackoverflow.com/questions/39482704/why-do-i-get-duplicate-a
>> ddrinfo-objects-in-the-linked-list-returned-by-getaddrin
>>
>> > Hi
>> >
>> > I am using pgpool_setup to test if it's working. So I am using
>> > localhost
>> >
>> > On Tue, Jul 12, 2022 at 9:20 PM Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
>> >
>> >> What is the setting for "listen_addresses" of pgpool.conf?
>> >> --
>> >> Tatsuo Ishii
>> >> SRA OSS, Inc. Japan
>> >> English: http://www.sraoss.co.jp/index_en.php
>> >> Japanese:http://www.sraoss.co.jp
>> >>
>> >> > Hi all
>> >> >
>> >> > I am trying to install pgpool and I am having problems testing
>> >> > with pgpool-setup it can't bind to a port and it refuses to
>> >> > start. I've
>> tried
>> >> > multiple ports and of course checked that those ports are free
>> >> >
>> >> > Here's the log. I am using RHEL8 with postgres 13 installed from
>> >> > the
>> >> Redhat
>> >> > Repository and installed pgpool 4.3.2 from source code
>> >> >
>> >> > 2022-07-12 14:54:20.040: main pid 3683880: DEBUG: initializing
>> >> > pool configuration
>> >> > 2022-07-12 14:54:20.040: main pid 3683880: DETAIL:
>> >> > num_backends: 2
>> >> > total_weight: 2.000000
>> >> > 2022-07-12 14:54:20.040: main pid 3683880: DEBUG: initializing
>> >> > pool configuration
>> >> > 2022-07-12 14:54:20.040: main pid 3683880: DETAIL: backend 0 weight:
>> >> > 1073741823.500000 flag: 0000
>> >> > 2022-07-12 14:54:20.040: main pid 3683880: DEBUG: initializing
>> >> > pool configuration
>> >> > 2022-07-12 14:54:20.040: main pid 3683880: DETAIL: backend 1 weight:
>> >> > 1073741823.500000 flag: 0000
>> >> > 2022-07-12 14:54:20.045: main pid 3683880: LOG: Backend status
>> >> > file /var/lib/pgsql2/log/pgpool_status discarded
>> >> > 2022-07-12 14:54:20.046: main pid 3683880: DEBUG: pool_coninfo_size:
>> >> > num_init_children (32) * max_pool (4) * MAX_NUM_BACKENDS (128) *
>> >> > sizeof(ConnectionInfo) (160) = 2621440 bytes requested for
>> >> > shared
>> memory
>> >> > 2022-07-12 14:54:20.046: main pid 3683880: LOG:
>> >> > health_check_stats_shared_memory_size: requested size: 12288
>> >> > 2022-07-12 14:54:20.046: main pid 3683880: LOG: memory cache
>> initialized
>> >> > 2022-07-12 14:54:20.046: main pid 3683880: DETAIL: memcache
>> >> > blocks
>> :64
>> >> > 2022-07-12 14:54:20.046: main pid 3683880: LOG: allocating
>> (136981824)
>> >> > bytes of shared memory segment
>> >> > 2022-07-12 14:54:20.046: main pid 3683880: LOG: allocating
>> >> > shared
>> memory
>> >> > segment of size: 136981824
>> >> > 2022-07-12 14:54:20.139: main pid 3683880: DEBUG: pool_coninfo_size:
>> >> > num_init_children (32) * max_pool (4) * MAX_NUM_BACKENDS (128) *
>> >> > sizeof(ConnectionInfo) (160) = 2621440 bytes requested for
>> >> > shared
>> memory
>> >> > 2022-07-12 14:54:20.139: main pid 3683880: LOG:
>> >> > health_check_stats_shared_memory_size: requested size: 12288
>> >> > 2022-07-12 14:54:20.139: main pid 3683880: LOG:
>> >> > health_check_stats_shared_memory_size: requested size: 12288
>> >> > 2022-07-12 14:54:20.139: main pid 3683880: LOG: memory cache
>> initialized
>> >> > 2022-07-12 14:54:20.139: main pid 3683880: DETAIL: memcache
>> >> > blocks
>> :64
>> >> > 2022-07-12 14:54:20.139: main pid 3683880: DEBUG: memory cache
>> request
>> >> > size : 67108864
>> >> > 2022-07-12 14:54:20.144: main pid 3683880: LOG:
>> pool_discard_oid_maps:
>> >> > discarded memqcache oid maps
>> >> > 2022-07-12 14:54:20.161: main pid 3683880: LOG: Setting up
>> >> > socket for
>> >> > ::1:11000
>> >> > 2022-07-12 14:54:20.161: main pid 3683880: LOG: Setting up
>> >> > socket for
>> >> > ::1:11000
>> >> > 2022-07-12 14:54:20.161: main pid 3683880: FATAL: failed to
>> >> > create
>> INET
>> >> > domain socket
>> >> > 2022-07-12 14:54:20.161: main pid 3683880: DETAIL: bind on
>> >> > socket
>> failed
>> >> > with error "Address already in use"
>> >> > 2022-07-12 14:54:20.164: main pid 3683880: LOG: shutting down
>> >> >
>> >> > Regards
>> >> >
>> >> > Daniel Cristini
>> >>
>>
_______________________________________________
pgpool-general mailing list
pgpool-general at pgpool.net
http://www.pgpool.net/mailman/listinfo/pgpool-general
More information about the pgpool-general
mailing list