Pgpool2 Service Won't Start

Hi,

On Fri, 16 Oct 2020 14:33:33 -0700 (MST)
alanhi <tnguyen3@honolulu.gov> 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@sraoss.co.jp>
SRA OSS, Inc. Japan

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 &lt;

tnguyen3@

&gt; 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 &lt;

pengbo@.co

&gt;
SRA OSS, Inc. Japan

Bo Peng wrote

Hi,

On Fri, 16 Oct 2020 14:33:33 -0700 (MST)
alanhi &lt;

tnguyen3@

&gt; 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 &lt;

pengbo@.co

&gt;
SRA OSS, Inc. Japan

Bo Peng wrote

Hi,

On Fri, 16 Oct 2020 14:33:33 -0700 (MST)
alanhi &lt;

tnguyen3@

&gt; 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 &lt;

pengbo@.co

&gt;
SRA OSS, Inc. Japan

--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html