From: | alanhi <tnguyen3(at)honolulu(dot)gov> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Pgpool2 Service Won't Start |
Date: | 2020-10-20 23:56:12 |
Message-ID: | 1603238172107-0.post@n3.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Bo,
I replaced the pgpool.conf file with the original file, reconfigured and it
works now. Interesting because it was pretty much the same settings after
reconfiguring again. Must be a setting that I missed.
Thanks,
Alan
Bo Peng wrote
> Hi,
>
> On Fri, 16 Oct 2020 14:33:33 -0700 (MST)
> alanhi <
> tnguyen3@
> > wrote:
>
>> Hi,
>>
>> Hi, my pgpool status indicates that it failed even after trying to
>> restart
>> the service. What can I check to see what configurations may be causing
>> this? Thanks.
>>
>> Alan
>>
>> ● pgpool2.service - pgpool-II
>> Loaded: loaded (/lib/systemd/system/pgpool2.service; enabled; vendor
>> preset: enabled)
>> Active: failed (Result: exit-code) since Fri 2020-10-16 10:16:21 HST;
>> 10min ago
>> Docs: man:pgpool(8)
>> Process: 20052 ExecStart=/usr/sbin/pgpool -n (code=exited, status=3)
>> Main PID: 20052 (code=exited, status=3)
>
> You may go to https://www.pgpool.net/mailman/listinfo/pgpool-general to
> ask questions.
> Could you share the result of "systemctl status pgpool" and pgpool log?
>
>> --
>> Sent from:
>> https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
>>
>>
>
>
> --
> Bo Peng <
> pengbo(at)(dot)co
> >
> SRA OSS, Inc. Japan
Bo Peng wrote
> Hi,
>
> On Fri, 16 Oct 2020 14:33:33 -0700 (MST)
> alanhi <
> tnguyen3@
> > wrote:
>
>> Hi,
>>
>> Hi, my pgpool status indicates that it failed even after trying to
>> restart
>> the service. What can I check to see what configurations may be causing
>> this? Thanks.
>>
>> Alan
>>
>> ● pgpool2.service - pgpool-II
>> Loaded: loaded (/lib/systemd/system/pgpool2.service; enabled; vendor
>> preset: enabled)
>> Active: failed (Result: exit-code) since Fri 2020-10-16 10:16:21 HST;
>> 10min ago
>> Docs: man:pgpool(8)
>> Process: 20052 ExecStart=/usr/sbin/pgpool -n (code=exited, status=3)
>> Main PID: 20052 (code=exited, status=3)
>
> You may go to https://www.pgpool.net/mailman/listinfo/pgpool-general to
> ask questions.
> Could you share the result of "systemctl status pgpool" and pgpool log?
>
>> --
>> Sent from:
>> https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
>>
>>
>
>
> --
> Bo Peng <
> pengbo(at)(dot)co
> >
> SRA OSS, Inc. Japan
Bo Peng wrote
> Hi,
>
> On Fri, 16 Oct 2020 14:33:33 -0700 (MST)
> alanhi <
> tnguyen3@
> > wrote:
>
>> Hi,
>>
>> Hi, my pgpool status indicates that it failed even after trying to
>> restart
>> the service. What can I check to see what configurations may be causing
>> this? Thanks.
>>
>> Alan
>>
>> ● pgpool2.service - pgpool-II
>> Loaded: loaded (/lib/systemd/system/pgpool2.service; enabled; vendor
>> preset: enabled)
>> Active: failed (Result: exit-code) since Fri 2020-10-16 10:16:21 HST;
>> 10min ago
>> Docs: man:pgpool(8)
>> Process: 20052 ExecStart=/usr/sbin/pgpool -n (code=exited, status=3)
>> Main PID: 20052 (code=exited, status=3)
>
> You may go to https://www.pgpool.net/mailman/listinfo/pgpool-general to
> ask questions.
> Could you share the result of "systemctl status pgpool" and pgpool log?
>
>> --
>> Sent from:
>> https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
>>
>>
>
>
> --
> Bo Peng <
> pengbo(at)(dot)co
> >
> SRA OSS, Inc. Japan
--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
From | Date | Subject | |
---|---|---|---|
Next Message | John the Scott | 2020-10-21 06:55:22 | Re: rum index supported on pg13? |
Previous Message | Olivier Gautherot | 2020-10-20 15:32:26 | Re: RITM18130676_Query_PostgreSQL support subscription |