[pgpool-general: 4827] Re: pgpool log file location
Bo Peng
pengbo at sraoss.co.jp
Wed Jul 27 15:54:11 JST 2016
Hi,
In CentOS7, by default configuration, the log messages will be written to syslog,
and "pgpool.log" file will not be created.
On Mon, 25 Jul 2016 11:22:09 +0000
"Souza, Belinda" <Belinda.Souza at Staples.com> wrote:
> 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
> **********************************************
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
--
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan
More information about the pgpool-general
mailing list