tag:blogger.com,1999:blog-8091710565846343105.post8169951447662596074..comments2024-03-28T15:13:36.664+08:00Comments on Donghua's Blog - DBAGlobe: Install and Configure PGAUDIT in PostgreSQL 9.6 step by stepLuo Donghuahttp://www.blogger.com/profile/09892213541160033846noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-8091710565846343105.post-69896776757016076662020-07-09T04:24:28.649+08:002020-07-09T04:24:28.649+08:00I use only high quality materials - you can see th...I use only high quality materials - you can see them at: <a href="https://freshapps.com/page/349/" rel="nofollow">https://freshapps.com/page/349/</a><br />skhttps://www.blogger.com/profile/17946763906641178538noreply@blogger.comtag:blogger.com,1999:blog-8091710565846343105.post-55493296435230959352020-06-09T23:22:20.438+08:002020-06-09T23:22:20.438+08:00Thanks for this. It was a big help.Thanks for this. It was a big help.Ronhttps://www.blogger.com/profile/02996835638461310078noreply@blogger.comtag:blogger.com,1999:blog-8091710565846343105.post-85561395461071071042020-03-17T23:07:31.275+08:002020-03-17T23:07:31.275+08:00Hi GUys please provide vids plsssHi GUys please provide vids plsssJay_Cloudhttps://www.blogger.com/profile/11667816571762301036noreply@blogger.comtag:blogger.com,1999:blog-8091710565846343105.post-59274389613595497012020-01-07T23:26:26.514+08:002020-01-07T23:26:26.514+08:00Hi , How you install pgaudit without git clone?
Hi , How you install pgaudit without git clone?<br />Daniel Princehttps://www.blogger.com/profile/07636271314804047642noreply@blogger.comtag:blogger.com,1999:blog-8091710565846343105.post-36749910916997742352020-01-05T18:59:32.211+08:002020-01-05T18:59:32.211+08:00Thank you very much for this great post. PostgreSQ...Thank you very much for this great post. <a href="https://www.welookups.com/postgres...resql-alias.html" rel="nofollow">PostgreSQL alias</a>UsamaAkhttps://www.blogger.com/profile/13967471967400289326noreply@blogger.comtag:blogger.com,1999:blog-8091710565846343105.post-7275065194523131832019-10-02T05:19:02.441+08:002019-10-02T05:19:02.441+08:00Hey, dude, thanks MUCHO! This would have taken for...Hey, dude, thanks MUCHO! This would have taken forever otherwise.billiamhttps://www.blogger.com/profile/16065637631101729863noreply@blogger.comtag:blogger.com,1999:blog-8091710565846343105.post-46702562935944932382019-10-02T05:17:29.981+08:002019-10-02T05:17:29.981+08:00One small fix to the procedure and you are golden....One small fix to the procedure and you are golden...<br />cd pgaudit<br />[root@centos6-dev pgaudit]# git checkout REL9_6_STABLE<br />Branch REL9_6_STABLE set up to track remote branch REL9_6_STABLE from origin.<br />Switched to a new branch 'REL9_6_STABLE'<br />[root@centos6-dev pgaudit]# make check USE_PGXS=1<br />make: pg_config: Command not found<br />make: *** No rule to make target `check'. Stop.<br />[root@centos6-dev pgaudit]# make <br />gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -g -O2 -fPIC -I. -I. -I../../src/include -D_GNU_SOURCE -c -o pgaudit.o pgaudit.c<br />gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -g -O2 -fPIC -shared -o pgaudit.so pgaudit.o -L../../src/port -L../../src/common -Wl,--as-needed -Wl,-rpath,'/var/lib/pgsql/pgsql_latest/lib',--enable-new-dtags <br />[root@centos6-dev pgaudit]# <br /><br />billiamhttps://www.blogger.com/profile/16065637631101729863noreply@blogger.comtag:blogger.com,1999:blog-8091710565846343105.post-83339537960719136142019-05-06T15:40:24.651+08:002019-05-06T15:40:24.651+08:00Encountered this error
In file included from pgau...Encountered this error<br /><br />In file included from pgaudit.c:39:0:<br />../../src/include/utils/varlena.h:19:14: error: conflicting types for ‘varstr_cmp’<br /> extern int varstr_cmp(const char *arg1, int len1, const char *arg2, int len2, Oid collid);<br /> ^<br />In file included from pgaudit.c:32:0:<br />../../src/include/utils/builtins.h:848:12: note: previous declaration of ‘varstr_cmp’ was here<br /> extern int varstr_cmp(char *arg1, int len1, char *arg2, int len2, Oid collid);<br /> ^<br />In file included from pgaudit.c:39:0:<br />../../src/include/utils/varlena.h:20:14: error: conflicting types for ‘varstr_sortsupport’<br /> extern void varstr_sortsupport(SortSupport ssup, Oid typid, Oid collid);<br /> ^<br />In file included from pgaudit.c:32:0:<br />../../src/include/utils/builtins.h:849:13: note: previous declaration of ‘varstr_sortsupport’ was here<br /> extern void varstr_sortsupport(SortSupport ssup, Oid collid, bool bpchar);<br /> ^<br />pgaudit.c:1361:29: error: unknown type name ‘QueryEnvironment’<br /> QueryEnvironment *queryEnv,<br /> ^<br />Anonymousnoreply@blogger.com