Re: Fwd: getting error while parsing log file using pgbadger

On Wed, Jul 26, 2017 at 11:36 PM, <kbrannen(at)pwhome(dot)com> wrote:

> On Wed, Jul 26, 2017 at 3:18 PM, PAWAN SHARMA <er(dot)pawanshr0963(at)gmail(dot)com>
> wrote:
> >
> > On Wed, Jul 26, 2017 at 2:42 PM, Michael Paquier <
> michael(dot)paquier(at)gmail(dot)com> wrote:
> > On Wed, Jul 26, 2017 at 10:59 AM, PAWAN SHARMA
> > <er(dot)pawanshr0963(at)gmail(dot)com> wrote:
> > >
> > > Hi All,
> > >
> > > I am facing below error while parsing log file.
> > >
> > > [postgres(at)abc pgaudit]$ pgbadger -f stderr
> postgres-2017-07-25_121445.csv
> > > Can't locate Text/CSV_XS.pm in @INC (@INC contains:
> /usr/local/lib64/perl5
> > > /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl
> > > /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at
> > > /bin/pgbadger line 2620.
> >
> ...
> > Running make install
> > "/usr/bin/perl" -MExtUtils::Command::MM -e 'cp_nonempty' -- CSV_XS.bs
> blib/arch/auto/Text/CSV_XS/CSV_XS.bs 644
> > Manifying 1 pod document
> > Files found in blib/arch: installing files in blib/lib into architecture
> dependent library tree
> > Installing /root/perl5/lib/perl5/x86_64-linux-thread-multi/auto/Text/
> CSV_XS/CSV_XS.so
> > Installing /root/perl5/lib/perl5/x86_64-linux-thread-multi/Text/CSV_
> XS.pm
> > Installing /root/perl5/man/man3/Text::CSV_XS.3pm
> > Appending installation info to /root/perl5/lib/perl5/x86_64-
> linux-thread-multi/perllocal.pod
> > HMBRAND/Text-CSV_XS-1.31.tgz
> > /bin/make install -- OK
> ...
> > [postgres(at)abc pgaudit]$ pgbadger -f stderr
> postgres-2017-07-26_000000.csv -o abc.html
> > Can't locate Text/CSV_XS.pm in @INC (@INC contains:
> /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl
> /usr/share/perl5/vendor_perl /usr/lib64/ perl5 /usr/share/perl5 .) at
> /bin/pgbadger line 2620.
>
> You have an environment problem in that the 2 different users have a
> different
> PATH and you're getting 2 different perl executables, or at least that's
> what
> it looks like to me. Please note that where you installed the module to is
> not
> listed in the @INC of the other command.
>
> I saw in another post that you have it fixed, but all you've done (from
> what I
> can see) is that you've only put a band-aide on the problem not fixed the
> root issue
> because you've installed the module into 2 different places. The root
> problem should
> still exist.
>
> You can run with a custom perl, we do; but that also means you must make
> sure
> that all apps use it by setting PATH and PERLLIB appropriately, usually by
> changing a system file and making sure all environments source it. If you
> do that,
> then PgBadger will work just fine -and- use the same perl as all of your
> other programs.
>
> HTH,
> Kevin
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

Hi Kevin,

Thanks for Response.

Can you please help me, how can I run this using custom, Perl.