[pgpool-general: 4815] Re: pgpool log file location
Souza, Belinda
Belinda.Souza at Staples.com
Mon Jul 25 20:22:09 JST 2016
Hi,
Here are the rpm's that were installed by our Linux Admin:
[postgres at lododndbv05 ~]$ rpm -qa | grep pgpool
pgpool-II-pg95-extensions-3.5.3-1pgdg.rhel7.x86_64
pgpoolAdmin-3.5.3-1pgdg.rhel7.noarch
pgpool-II-pg95-devel-3.5.3-1pgdg.rhel7.x86_64
pgpool-II-pg95-3.5.3-1pgdg.rhel7.x86_64
pgpool-II-pg95-debuginfo-3.5.3-1pgdg.rhel7.x86_64
Thanks,
Belinda
-----Original Message-----
From: pgpool-general-bounces at pgpool.net [mailto:pgpool-general-bounces at pgpool.net] On Behalf Of pgpool-general-request at pgpool.net
Sent: Friday, July 22, 2016 11:00 PM
To: pgpool-general at pgpool.net
Subject: pgpool-general Digest, Vol 57, Issue 21
Send pgpool-general mailing list submissions to
pgpool-general at pgpool.net
To subscribe or unsubscribe via the World Wide Web, visit
http://www.sraoss.jp/mailman/listinfo/pgpool-general
or, via email, send a message with subject or body 'help' to
pgpool-general-request at pgpool.net
You can reach the person managing the list at
pgpool-general-owner at pgpool.net
When replying, please edit your Subject line so it is more specific
than "Re: Contents of pgpool-general digest..."
Today's Topics:
1. [pgpool-general: 4805] Re: pgpool log file location (Bo Peng)
2. [pgpool-general: 4806] Re: pgpool log file location (Bo Peng)
3. [pgpool-general: 4807] Re: pgpool log file location
(Souza, Belinda)
4. [pgpool-general: 4808] log destinations (Dan Foster)
5. [pgpool-general: 4809] Incosistency between "show pool_nodes"
and pcp_node_info. (Tema Zelikin)
----------------------------------------------------------------------
Message: 1
Date: Fri, 22 Jul 2016 12:31:48 +0900
From: Bo Peng <pengbo at sraoss.co.jp>
To: "Souza, Belinda" <Belinda.Souza at Staples.com>
Cc: "pgpool-general at pgpool.net" <pgpool-general at pgpool.net>
Subject: [pgpool-general: 4805] Re: pgpool log file location
Message-ID: <20160722123148.d726ee3c05d9e7a9a9ae0c3e at sraoss.co.jp>
Content-Type: text/plain; charset=US-ASCII
Hi,
Which version of pgpool-II rpm are you using?
On Thu, 21 Jul 2016 20:20:53 +0000
"Souza, Belinda" <Belinda.Souza at Staples.com> wrote:
> Hello:
>
> I am setting up my first pgpool server, and not able to figure out where the pgpool log is located. I would like to view the log with all of the pgpool messaging activity.
>
> The log_destination = 'stderr' in the pgpool.conf file, but there isn't a log directory parameter to specify where the output should go.
>
> To start pgpool, we use a service : sudo service pgpool start
>
> Could someone point out what I'm missing ?
>
>
> Thank you,
> Belinda
> ________________________________________________
> Belinda L. Souza
> Consultant Database Engineer | Database Engineering
> Staples, Inc. | 500 Staples Drive | Framingham, MA 01702
> belinda.souza at staples.com<mailto:belinda.souza at staples.com> | 508.253.7835
> This message (including any attachments) may contain confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited.
>
--
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan
------------------------------
Message: 2
Date: Fri, 22 Jul 2016 13:28:30 +0900
From: Bo Peng <pengbo at sraoss.co.jp>
To: "Souza, Belinda" <Belinda.Souza at Staples.com>
Cc: "pgpool-general at pgpool.net" <pgpool-general at pgpool.net>
Subject: [pgpool-general: 4806] Re: pgpool log file location
Message-ID: <20160722132830.57f64ba1f6aab25cc3f32264 at sraoss.co.jp>
Content-Type: text/plain; charset=US-ASCII
Hi,
Could you the fowwling command to start pgpool?
$ pgpool -n -d > /var/log/pgpool/pgpool.log 2>&1 &
The -d option enables debug messages to be generated.
The log messages can be written to log file /var/log/pgpool/pgpool.log.
On Thu, 21 Jul 2016 20:20:53 +0000
"Souza, Belinda" <Belinda.Souza at Staples.com> wrote:
> Hello:
>
> I am setting up my first pgpool server, and not able to figure out where the pgpool log is located. I would like to view the log with all of the pgpool messaging activity.
>
> The log_destination = 'stderr' in the pgpool.conf file, but there isn't a log directory parameter to specify where the output should go.
>
> To start pgpool, we use a service : sudo service pgpool start
>
> Could someone point out what I'm missing ?
>
>
> Thank you,
> Belinda
> ________________________________________________
> Belinda L. Souza
> Consultant Database Engineer | Database Engineering
> Staples, Inc. | 500 Staples Drive | Framingham, MA 01702
> belinda.souza at staples.com<mailto:belinda.souza at staples.com> | 508.253.7835
> This message (including any attachments) may contain confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited.
>
--
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan
------------------------------
Message: 3
Date: Fri, 22 Jul 2016 15:01:27 +0000
From: "Souza, Belinda" <Belinda.Souza at Staples.com>
To: Bo Peng <pengbo at sraoss.co.jp>
Cc: "pgpool-general at pgpool.net" <pgpool-general at pgpool.net>
Subject: [pgpool-general: 4807] Re: pgpool log file location
Message-ID:
<CY1PR0301MB21231149CDC9FDFAB1EA9AEBEC0A0 at CY1PR0301MB2123.namprd03.prod.outlook.com>
Content-Type: text/plain; charset="us-ascii"
Hello,
I am able to execute the below, and capture the log results. I will need to get logging to happen through the use of the service.
Thank you !
Belinda
-----Original Message-----
From: Bo Peng [mailto:pengbo at sraoss.co.jp]
Sent: Friday, July 22, 2016 12:29 AM
To: Souza, Belinda
Cc: pgpool-general at pgpool.net
Subject: Re: [pgpool-general: 4804] pgpool log file location
Hi,
Could you the fowwling command to start pgpool?
$ pgpool -n -d > /var/log/pgpool/pgpool.log 2>&1 &
The -d option enables debug messages to be generated.
The log messages can be written to log file /var/log/pgpool/pgpool.log.
On Thu, 21 Jul 2016 20:20:53 +0000
"Souza, Belinda" <Belinda.Souza at Staples.com> wrote:
> Hello:
>
> I am setting up my first pgpool server, and not able to figure out where the pgpool log is located. I would like to view the log with all of the pgpool messaging activity.
>
> The log_destination = 'stderr' in the pgpool.conf file, but there isn't a log directory parameter to specify where the output should go.
>
> To start pgpool, we use a service : sudo service pgpool start
>
> Could someone point out what I'm missing ?
>
>
> Thank you,
> Belinda
> ________________________________________________
> Belinda L. Souza
> Consultant Database Engineer | Database Engineering
> Staples, Inc. | 500 Staples Drive | Framingham, MA 01702
> belinda.souza at staples.com<mailto:belinda.souza at staples.com> | 508.253.7835
> This message (including any attachments) may contain confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited.
>
--
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan
------------------------------
Message: 4
Date: Fri, 22 Jul 2016 17:00:49 +0100
From: Dan Foster <Dan.Foster at bristol.ac.uk>
To: pgpool-general at pgpool.net
Subject: [pgpool-general: 4808] log destinations
Message-ID:
<CALRUX+gJhHNMoPeARGncABCuzMDHZfzcxEMEbpFFHi57nxT-Ug at mail.gmail.com>
Content-Type: text/plain; charset=UTF-8
Hi,
We're running postgresql-pgpool-II-3.4.6-1.el7.x86_64 and trying to
get logs to only go to syslog facility local0. We have the following
in pgpool.conf:
log_destination = 'syslog'
log_per_node_statement = on
syslog_facility = 'local0'
syslog_ident = 'pgpool'
Logs go to the correct place in syslog as expected, but queries are
also output to either stdout or stderr. Is it possible to stop this
output on stdout/stderr?
Thanks,
Dan.
--
Dan Foster | Senior Storage Systems Administrator
Advanced Computing Research Centre, University of Bristol
------------------------------
Message: 5
Date: Fri, 22 Jul 2016 22:11:55 +0300
From: Tema Zelikin <gunslinger at nightflame.info>
To: pgpool-general at pgpool.net
Subject: [pgpool-general: 4809] Incosistency between "show pool_nodes"
and pcp_node_info.
Message-ID: <56838e50-6de2-d383-dff5-fc87d6c684b4 at nightflame.info>
Content-Type: text/plain; charset=utf-8; format=flowed
Hello.
I've found a strange inconsistency between result of the query "show
pool_nodes" and result of execution of pcp_node_info.
While both show degraded backends with status "3", for normally working
nodes "show pool_nodes" displays status "2", and pcp_node_info for the
same node number shows "1". It begs the question: which one is actually
correct?
------------------------------
_______________________________________________
pgpool-general mailing list
pgpool-general at pgpool.net
http://www.pgpool.net/mailman/listinfo/pgpool-general
End of pgpool-general Digest, Vol 57, Issue 21
**********************************************
More information about the pgpool-general
mailing list