[pgpool-general: 3864] Re: pgpool-general Digest, Vol 45, Issue 12

Muhammad Usama m.usama at gmail.com
Thu Jul 9 06:22:57 JST 2015


Hi

As per the script the pgpool log goes in "/var/log/pgpool.log' file. Check
if the user(postgres) running the pgpool have the correct write permisions
on /var/log/' directory

Thanks
Best regards
Muhammad Usama


On Wed, Jul 8, 2015 at 8:12 PM, Praveena Jogi <pjogi at soasta.com> wrote:

> There is no pgpool.sh file in the /etc/init.d
>
> On Wed, Jul 8, 2015 at 6:56 AM, <pgpool-general-request at pgpool.net> wrote:
>
>> 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: 3858] Re: pgpool-general Digest, Vol 45,
>>       Issue 4 (Muhammad Usama)
>>    2. [pgpool-general: 3859] Re: pgpool-general Digest, Vol 45,
>>       Issue 4 (Praveena Jogi)
>>
>>
>> ----------------------------------------------------------------------
>>
>> Message: 1
>> Date: Wed, 8 Jul 2015 13:19:49 +0500
>> From: Muhammad Usama <m.usama at gmail.com>
>> To: Praveena Jogi <pjogi at soasta.com>
>> Cc: pgpool-general <pgpool-general at pgpool.net>
>> Subject: [pgpool-general: 3858] Re: pgpool-general Digest, Vol 45,
>>         Issue 4
>> Message-ID:
>>         <
>> CAEJvTzWRv_XjQOC+NHsbi3rF2wRV75XTBnjm4+19F2TbDs76xA at mail.gmail.com>
>> Content-Type: text/plain; charset="utf-8"
>>
>> Hi
>>
>> Can you please share the /etc/init.d/pgpool.sh script you have installed.
>>
>> You can also check start pgpool-II command in the script if it is
>> redirecting the log to some file
>>
>> Thanks
>> Best regards
>> Muhammad Usama
>>
>> On Wed, Jul 8, 2015 at 8:55 AM, Praveena Jogi <pjogi at soasta.com> wrote:
>>
>> > I did reply
>> >
>> > ---
>> > I am not redirecting. Using 'Sudo /etc/init.d/pgpool start' to start the
>> > service.
>> >
>> > On Tue, Jul 7, 2015 at 8:33 PM, Tatsuo Ishii <ishii at postgresql.org>
>> wrote:
>> >
>> >> Muhammad Usama has sent you a question [pgpool-general: 3849] but you
>> >> didn't reply it.
>> >>
>> >> Best regards,
>> >> --
>> >> Tatsuo Ishii
>> >> SRA OSS, Inc. Japan
>> >> English: http://www.sraoss.co.jp/index_en.php
>> >> Japanese:http://www.sraoss.co.jp
>> >>
>> >> > Any update this issue?
>> >> >
>> >> > On Fri, Jul 3, 2015 at 11:17 PM, Praveena Jogi <pjogi at soasta.com>
>> >> wrote:
>> >> >
>> >> >> pgpool-II version 3.2.1 (namameboshi)
>> >> >>
>> >> >> Attached the pgpool.conf file.
>> >> >>
>> >> >>
>> >> >> Pgpool works but it does not write to the log.
>> >> >>
>> >> >>
>> >> >> Thanks,
>> >> >>
>> >> >> -Praveena
>> >> >>
>> >> >> On Fri, Jul 3, 2015 at 8:00 PM, <pgpool-general-request at pgpool.net>
>> >> wrote:
>> >> >>
>> >> >>> 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: 3847] Re: Pgpool log (Muhammad Usama)
>> >> >>>
>> >> >>>
>> >> >>>
>> ----------------------------------------------------------------------
>> >> >>>
>> >> >>> Message: 1
>> >> >>> Date: Fri, 3 Jul 2015 14:53:17 +0500
>> >> >>> From: Muhammad Usama <m.usama at gmail.com>
>> >> >>> To: Praveena Jogi <pjogi at soasta.com>
>> >> >>> Cc: pgpool-general-owner at pgpool.net, pgpool-general
>> >> >>>         <pgpool-general at pgpool.net>
>> >> >>> Subject: [pgpool-general: 3847] Re: Pgpool log
>> >> >>> Message-ID:
>> >> >>>         <
>> >> >>> CAEJvTzVJbDUO3opQ_PdM42pouKtoAg6Bu_zH_veMH90HdG617w at mail.gmail.com
>> >
>> >> >>> Content-Type: text/plain; charset="utf-8"
>> >> >>>
>> >> >>> Hi
>> >> >>>
>> >> >>> Which version of pgpool-II are you using and also please share the
>> >> >>> pgpool-II conf file.
>> >> >>>
>> >> >>> Thanks
>> >> >>> Best regards
>> >> >>> Muhammad Usama
>> >> >>>
>> >> >>> On Fri, Jul 3, 2015 at 2:36 AM, Praveena Jogi <pjogi at soasta.com>
>> >> wrote:
>> >> >>>
>> >> >>> > I have registered. this is urgent issue.
>> >> >>> >
>> >> >>> > PGPOOL working but it is not writing to the log.
>> >> >>> > All I can see this message in the log file and /var/lib/pgsql
>> does
>> >> not
>> >> >>> > exists. Postgres is running on different server.
>> >> >>> >
>> >> >>> > runuser: warning: cannot change directory to /var/lib/pgsql: No
>> such
>> >> >>> file
>> >> >>> > or directory
>> >> >>> >
>> >> >>> >
>> >> >>> > Any help appreciated.
>> >> >>> >
>> >> >>> > On Thu, Jul 2, 2015 at 11:53 AM, <
>> pgpool-general-owner at pgpool.net>
>> >> >>> wrote:
>> >> >>> >
>> >> >>> >> You are not allowed to post to this mailing list, and your
>> message
>> >> has
>> >> >>> >> been automatically rejected.  If you think that your messages
>> are
>> >> >>> >> being rejected in error, contact the mailing list owner at
>> >> >>> >> pgpool-general-owner at pgpool.net.
>> >> >>> >>
>> >> >>> >>
>> >> >>> >>
>> >> >>> >> ---------- Forwarded message ----------
>> >> >>> >> From: Praveena Jogi <pjogi at soasta.com>
>> >> >>> >> To: pgpool-general at pgpool.net
>> >> >>> >> Cc:
>> >> >>> >> Date: Thu, 2 Jul 2015 11:52:57 -0700
>> >> >>> >> Subject: Pgppol log
>> >> >>> >> Hi,
>> >> >>> >> PGPOOL working but it is not writing to the log.
>> >> >>> >> All I can see this message in the log file and /var/lib/pgsql
>> does
>> >> not
>> >> >>> >> exists. Postgres is running on different server.
>> >> >>> >>
>> >> >>> >> runuser: warning: cannot change directory to /var/lib/pgsql: No
>> >> such
>> >> >>> file
>> >> >>> >> or directory
>> >> >>> >>
>> >> >>> >>
>> >> >>> >> Any help appreciated.
>> >> >>> >>
>> >> >>> >> Thanks,
>> >> >>> >>
>> >> >>> >> -Praveena
>> >> >>> >>
>> >> >>> >>
>> >> >>> >>
>> >> >>> >>
>> >> >>> >
>> >> >>> > _______________________________________________
>> >> >>> > pgpool-general mailing list
>> >> >>> > pgpool-general at pgpool.net
>> >> >>> > http://www.pgpool.net/mailman/listinfo/pgpool-general
>> >> >>> >
>> >> >>> >
>> >> >>> -------------- next part --------------
>> >> >>> An HTML attachment was scrubbed...
>> >> >>> URL: <
>> >> >>>
>> >>
>> http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150703/3d286bb6/attachment-0001.html
>> >> >>> >
>> >> >>>
>> >> >>> ------------------------------
>> >> >>>
>> >> >>> _______________________________________________
>> >> >>> pgpool-general mailing list
>> >> >>> pgpool-general at pgpool.net
>> >> >>> http://www.pgpool.net/mailman/listinfo/pgpool-general
>> >> >>>
>> >> >>>
>> >> >>> End of pgpool-general Digest, Vol 45, Issue 4
>> >> >>> *********************************************
>> >> >>>
>> >> >>
>> >> >>
>> >>
>> >
>> >
>> > _______________________________________________
>> > pgpool-general mailing list
>> > pgpool-general at pgpool.net
>> > http://www.pgpool.net/mailman/listinfo/pgpool-general
>> >
>> >
>> -------------- next part --------------
>> An HTML attachment was scrubbed...
>> URL: <
>> http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150708/b6ca6f73/attachment-0001.html
>> >
>>
>> ------------------------------
>>
>> Message: 2
>> Date: Wed, 8 Jul 2015 06:55:58 -0700
>> From: Praveena Jogi <pjogi at soasta.com>
>> To: Muhammad Usama <m.usama at gmail.com>
>> Cc: pgpool-general <pgpool-general at pgpool.net>
>> Subject: [pgpool-general: 3859] Re: pgpool-general Digest, Vol 45,
>>         Issue 4
>> Message-ID:
>>         <
>> CAEW7oBm-ZQoDXxYkL2naw_Ac+awZyNP+1GhSsZjw2xJjwfXXZQ at mail.gmail.com>
>> Content-Type: text/plain; charset="utf-8"
>>
>> Attached the pgpool file.
>>
>> $SU -l postgres -c "$PGPOOLDAEMON -f $PGPOOLCONF $OPTS & " >> "$PGPOOLLOG"
>> 2>&1 < /dev/null
>>
>> On Wed, Jul 8, 2015 at 1:19 AM, Muhammad Usama <m.usama at gmail.com> wrote:
>>
>> > Hi
>> >
>> > Can you please share the /etc/init.d/pgpool.sh script you have
>> installed.
>> >
>> > You can also check start pgpool-II command in the script if it is
>> > redirecting the log to some file
>> >
>> > Thanks
>> > Best regards
>> > Muhammad Usama
>> >
>> > On Wed, Jul 8, 2015 at 8:55 AM, Praveena Jogi <pjogi at soasta.com> wrote:
>> >
>> >> I did reply
>> >>
>> >> ---
>> >> I am not redirecting. Using 'Sudo /etc/init.d/pgpool start' to start
>> the
>> >> service.
>> >>
>> >> On Tue, Jul 7, 2015 at 8:33 PM, Tatsuo Ishii <ishii at postgresql.org>
>> >> wrote:
>> >>
>> >>> Muhammad Usama has sent you a question [pgpool-general: 3849] but you
>> >>> didn't reply it.
>> >>>
>> >>> Best regards,
>> >>> --
>> >>> Tatsuo Ishii
>> >>> SRA OSS, Inc. Japan
>> >>> English: http://www.sraoss.co.jp/index_en.php
>> >>> Japanese:http://www.sraoss.co.jp
>> >>>
>> >>> > Any update this issue?
>> >>> >
>> >>> > On Fri, Jul 3, 2015 at 11:17 PM, Praveena Jogi <pjogi at soasta.com>
>> >>> wrote:
>> >>> >
>> >>> >> pgpool-II version 3.2.1 (namameboshi)
>> >>> >>
>> >>> >> Attached the pgpool.conf file.
>> >>> >>
>> >>> >>
>> >>> >> Pgpool works but it does not write to the log.
>> >>> >>
>> >>> >>
>> >>> >> Thanks,
>> >>> >>
>> >>> >> -Praveena
>> >>> >>
>> >>> >> On Fri, Jul 3, 2015 at 8:00 PM, <pgpool-general-request at pgpool.net
>> >
>> >>> wrote:
>> >>> >>
>> >>> >>> 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: 3847] Re: Pgpool log (Muhammad Usama)
>> >>> >>>
>> >>> >>>
>> >>> >>>
>> >>> ----------------------------------------------------------------------
>> >>> >>>
>> >>> >>> Message: 1
>> >>> >>> Date: Fri, 3 Jul 2015 14:53:17 +0500
>> >>> >>> From: Muhammad Usama <m.usama at gmail.com>
>> >>> >>> To: Praveena Jogi <pjogi at soasta.com>
>> >>> >>> Cc: pgpool-general-owner at pgpool.net, pgpool-general
>> >>> >>>         <pgpool-general at pgpool.net>
>> >>> >>> Subject: [pgpool-general: 3847] Re: Pgpool log
>> >>> >>> Message-ID:
>> >>> >>>         <
>> >>> >>>
>> CAEJvTzVJbDUO3opQ_PdM42pouKtoAg6Bu_zH_veMH90HdG617w at mail.gmail.com>
>> >>> >>> Content-Type: text/plain; charset="utf-8"
>> >>> >>>
>> >>> >>> Hi
>> >>> >>>
>> >>> >>> Which version of pgpool-II are you using and also please share the
>> >>> >>> pgpool-II conf file.
>> >>> >>>
>> >>> >>> Thanks
>> >>> >>> Best regards
>> >>> >>> Muhammad Usama
>> >>> >>>
>> >>> >>> On Fri, Jul 3, 2015 at 2:36 AM, Praveena Jogi <pjogi at soasta.com>
>> >>> wrote:
>> >>> >>>
>> >>> >>> > I have registered. this is urgent issue.
>> >>> >>> >
>> >>> >>> > PGPOOL working but it is not writing to the log.
>> >>> >>> > All I can see this message in the log file and /var/lib/pgsql
>> does
>> >>> not
>> >>> >>> > exists. Postgres is running on different server.
>> >>> >>> >
>> >>> >>> > runuser: warning: cannot change directory to /var/lib/pgsql: No
>> >>> such
>> >>> >>> file
>> >>> >>> > or directory
>> >>> >>> >
>> >>> >>> >
>> >>> >>> > Any help appreciated.
>> >>> >>> >
>> >>> >>> > On Thu, Jul 2, 2015 at 11:53 AM, <
>> pgpool-general-owner at pgpool.net>
>> >>> >>> wrote:
>> >>> >>> >
>> >>> >>> >> You are not allowed to post to this mailing list, and your
>> >>> message has
>> >>> >>> >> been automatically rejected.  If you think that your messages
>> are
>> >>> >>> >> being rejected in error, contact the mailing list owner at
>> >>> >>> >> pgpool-general-owner at pgpool.net.
>> >>> >>> >>
>> >>> >>> >>
>> >>> >>> >>
>> >>> >>> >> ---------- Forwarded message ----------
>> >>> >>> >> From: Praveena Jogi <pjogi at soasta.com>
>> >>> >>> >> To: pgpool-general at pgpool.net
>> >>> >>> >> Cc:
>> >>> >>> >> Date: Thu, 2 Jul 2015 11:52:57 -0700
>> >>> >>> >> Subject: Pgppol log
>> >>> >>> >> Hi,
>> >>> >>> >> PGPOOL working but it is not writing to the log.
>> >>> >>> >> All I can see this message in the log file and /var/lib/pgsql
>> >>> does not
>> >>> >>> >> exists. Postgres is running on different server.
>> >>> >>> >>
>> >>> >>> >> runuser: warning: cannot change directory to /var/lib/pgsql: No
>> >>> such
>> >>> >>> file
>> >>> >>> >> or directory
>> >>> >>> >>
>> >>> >>> >>
>> >>> >>> >> Any help appreciated.
>> >>> >>> >>
>> >>> >>> >> Thanks,
>> >>> >>> >>
>> >>> >>> >> -Praveena
>> >>> >>> >>
>> >>> >>> >>
>> >>> >>> >>
>> >>> >>> >>
>> >>> >>> >
>> >>> >>> > _______________________________________________
>> >>> >>> > pgpool-general mailing list
>> >>> >>> > pgpool-general at pgpool.net
>> >>> >>> > http://www.pgpool.net/mailman/listinfo/pgpool-general
>> >>> >>> >
>> >>> >>> >
>> >>> >>> -------------- next part --------------
>> >>> >>> An HTML attachment was scrubbed...
>> >>> >>> URL: <
>> >>> >>>
>> >>>
>> http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150703/3d286bb6/attachment-0001.html
>> >>> >>> >
>> >>> >>>
>> >>> >>> ------------------------------
>> >>> >>>
>> >>> >>> _______________________________________________
>> >>> >>> pgpool-general mailing list
>> >>> >>> pgpool-general at pgpool.net
>> >>> >>> http://www.pgpool.net/mailman/listinfo/pgpool-general
>> >>> >>>
>> >>> >>>
>> >>> >>> End of pgpool-general Digest, Vol 45, Issue 4
>> >>> >>> *********************************************
>> >>> >>>
>> >>> >>
>> >>> >>
>> >>>
>> >>
>> >>
>> >> _______________________________________________
>> >> pgpool-general mailing list
>> >> pgpool-general at pgpool.net
>> >> http://www.pgpool.net/mailman/listinfo/pgpool-general
>> >>
>> >>
>> >
>> -------------- next part --------------
>> An HTML attachment was scrubbed...
>> URL: <
>> http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150708/eb65a7d1/attachment.html
>> >
>> -------------- next part --------------
>> A non-text attachment was scrubbed...
>> Name: pgpool
>> Type: application/octet-stream
>> Size: 3940 bytes
>> Desc: not available
>> URL: <
>> http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150708/eb65a7d1/attachment.obj
>> >
>>
>> ------------------------------
>>
>> _______________________________________________
>> pgpool-general mailing list
>> pgpool-general at pgpool.net
>> http://www.pgpool.net/mailman/listinfo/pgpool-general
>>
>>
>> End of pgpool-general Digest, Vol 45, Issue 12
>> **********************************************
>>
>
>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150709/d5276da2/attachment-0001.html>


More information about the pgpool-general mailing list