On Wed, Jul 26, 2017 at 5:38 PM, Michael Paquier <michael.paqu...@gmail.com> wrote:
> On Wed, Jul 26, 2017 at 2:01 PM, PAWAN SHARMA <er.pawanshr0...@gmail.com> > wrote: > > For root user its working fine > > > > [root@abc :/opt/PostgreSQL/9.5/data/pgaudit]# > > #-> pgbadger -f stderr postgres-2017-07-26_000000.csv -o abc.html > > [======================> ] Parsed 1873673 bytes of 1991998 (94.06%), > > queries: 0, events: 845 > > LOG: Ok, generating html report... > > > > but for the Postgres user, its showing the below error. > > There is no way to be sure what's wrong as this depends on the > environment you are using and the packaging system that you have, but > at short glance, I think that you should first try to update PERL5LIB > so as it points to the location where the module has been installed. > Good luck! It does not sound complicated to me to address anyway. > -- > Michael > Hi Michal, Thanks for your support. finally, it's done. I have installed Text::CSV_XS using PostgreSQL user. [postgres@abcpgaudit]$ perl -MCPAN -e shell cpan> install Text::CSV_XS CPAN: Storable loaded ok Going to read /root/.cpan/Metadata Warning: Found only 0 objects in /root/.cpan/Metadata CPAN: LWP::UserAgent loaded ok Fetching with LWP: ftp://ftp.perl.org/pub/CPAN/authors/01mailrc.txt.gz Going to read /root/.cpan/sources/authors/01mailrc.txt.gz CPAN: Compress::Zlib loaded ok Fetching with LWP: ftp://ftp.perl.org/pub/CPAN/modules/02packages.details.txt.gz Going to read /root/.cpan/sources/modules/02packages.details.txt.gz Database was generated on Thu, 28 Nov 2013 08:17:03 GMT There's a new CPAN.pm version (v2.00) available! [Current version is v1.7602] You might want to try install Bundle::CPAN reload cpan without quitting the current session. It should be a seamless upgrade while we are running... Fetching with LWP: ftp://ftp.perl.org/pub/CPAN/modules/03modlist.data.gz Going to read /root/.cpan/sources/modules/03modlist.data.gz Going to write /root/.cpan/Metadata Running install for module Text::CSV_XS Running make for H/HM/HMBRAND/Text-CSV_XS-1.02.tgz Fetching with LWP: ftp://ftp.perl.org/pub/CPAN/authors/id/H/HM/HMBRAND/Text-CSV_XS-1.02.tgz CPAN: Digest::MD5 loaded ok Fetching with LWP: ftp://ftp.perl.org/pub/CPAN/authors/id/H/HM/HMBRAND/CHECKSUMS Checksum for /root/.cpan/sources/authors/id/H/HM/HMBRAND/Text-CSV_XS-1.02.tgz ok Scanning cache /root/.cpan/build for sizes Text-CSV_XS-1.02/ Text-CSV_XS-1.02/examples/ Text-CSV_XS-1.02/examples/parser-xs.pl Text-CSV_XS-1.02/examples/speed.pl Text-CSV_XS-1.02/examples/csv2xls Text-CSV_XS-1.02/examples/csvdiff Text-CSV_XS-1.02/examples/csv-check Text-CSV_XS-1.02/ChangeLog Text-CSV_XS-1.02/META.yml Text-CSV_XS-1.02/MANIFEST Text-CSV_XS-1.02/ppport.h Text-CSV_XS-1.02/Makefile.PL Text-CSV_XS-1.02/CSV_XS.xs Text-CSV_XS-1.02/files/ Text-CSV_XS-1.02/files/macosx.csv Text-CSV_XS-1.02/files/utf8.csv Text-CSV_XS-1.02/README Text-CSV_XS-1.02/META.json Text-CSV_XS-1.02/t/ Text-CSV_XS-1.02/t/46_eol_si.t Text-CSV_XS-1.02/t/20_file.t Text-CSV_XS-1.02/t/76_magic.t Text-CSV_XS-1.02/t/81_subclass.t Text-CSV_XS-1.02/t/util.pl Text-CSV_XS-1.02/t/40_misc.t Text-CSV_XS-1.02/t/70_rt.t Text-CSV_XS-1.02/t/22_scalario.t Text-CSV_XS-1.02/t/21_lexicalio.t Text-CSV_XS-1.02/t/77_getall.t Text-CSV_XS-1.02/t/12_acc.t Text-CSV_XS-1.02/t/00_pod.t Text-CSV_XS-1.02/t/60_samples.t Text-CSV_XS-1.02/t/01_pod.t Text-CSV_XS-1.02/t/75_hashref.t Text-CSV_XS-1.02/t/65_allow.t Text-CSV_XS-1.02/t/50_utf8.t Text-CSV_XS-1.02/t/41_null.t Text-CSV_XS-1.02/t/30_types.t Text-CSV_XS-1.02/t/51_utf8.t Text-CSV_XS-1.02/t/10_base.t Text-CSV_XS-1.02/t/55_combi.t Text-CSV_XS-1.02/t/80_diag.t Text-CSV_XS-1.02/t/45_eol.t Text-CSV_XS-1.02/t/15_flags.t Text-CSV_XS-1.02/CSV_XS.pm CPAN.pm: Going to build H/HM/HMBRAND/Text-CSV_XS-1.02.tgz Checking if your kit is complete... Looks good Writing Makefile for Text::CSV_XS cp CSV_XS.pm blib/lib/Text/CSV_XS.pm /usr/bin/perl /usr/lib/perl5/5.8.8/ExtUtils/xsubpp -typemap /usr/lib/perl5/5.8.8/ExtUtils/typemap CSV_XS.xs > CSV_XS.xsc && mv CSV_XS.xsc CSV_XS.c gcc -c -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -DVERSION=\"1.02\" -DXS_VERSION=\"1.02\" -fPIC "-I/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/CORE" CSV_XS.c CSV_XS.xs: In function 'cx_Print': CSV_XS.xs:627: warning: unused variable 'l' CSV_XS.xs: In function 'cx_c_xsParse': CSV_XS.xs:1450: warning: unused variable 'sp' CSV_XS.c: In function 'XS_Text__CSV_XS_error_input': CSV_XS.xs:1665: warning: unused variable 'hv' CSV_XS.c: At top level: CSV_XS.xs:1546: warning: 'cx_av_free' defined but not used Running Mkbootstrap for Text::CSV_XS () chmod 644 CSV_XS.bs rm -f blib/arch/auto/Text/CSV_XS/CSV_XS.so gcc -shared -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic CSV_XS.o -o blib/arch/auto/Text/CSV_XS/CSV_XS.so \ \ chmod 755 blib/arch/auto/Text/CSV_XS/CSV_XS.so cp CSV_XS.bs blib/arch/auto/Text/CSV_XS/CSV_XS.bs chmod 644 blib/arch/auto/Text/CSV_XS/CSV_XS.bs Manifying blib/man3/Text::CSV_XS.3pm /usr/bin/make -- OK Running make test PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t t/00_pod..........skipped all skipped: Test::Pod 1.00 required for testing POD t/01_pod..........skipped all skipped: Test::Pod::Coverage required for testing POD Coverage t/10_base.........ok t/12_acc..........ok t/15_flags........ok t/20_file.........ok t/21_lexicalio....ok t/22_scalario.....ok t/30_types........ok t/40_misc.........ok t/41_null.........ok t/45_eol..........ok t/46_eol_si.......ok t/50_utf8.........ok t/51_utf8.........ok t/55_combi........ok t/60_samples......ok t/65_allow........ok t/70_rt...........ok 20000/20453 skipped: Encode is too old for these tests t/75_hashref......ok t/76_magic........ok t/77_getall.......ok t/80_diag.........ok t/81_subclass.....ok All tests successful, 2 tests and 20000 subtests skipped. Files=24, Tests=33652, 4 wallclock secs ( 2.29 cusr + 0.33 csys = 2.62 CPU) /usr/bin/make test -- OK Running make install Installing /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/Text/CSV_XS/CSV_XS.bs Installing /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/Text/CSV_XS/CSV_XS.so Files found in blib/arch: installing files in blib/lib into architecture dependent library tree Installing /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/Text/CSV_XS.pm Installing /usr/share/man/man3/Text::CSV_XS.3pm Writing /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/Text/CSV_XS/.packlist Appending installation info to /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/perllocal.pod /usr/bin/make install -- OK cpan> quit Terminal does not support GetHistory. Lockfile removed. [postgres@abc pgaudit]$ pgbadger -f stderr postgres-2017-07-26_000000.csv -o xyz.html [======================> ] Parsed 1873673 bytes of 1991998 (94.06%), queries: 0, events: 845 LOG: Ok, generating html report... Thanks :)
