Re: How to watch for schema changes - Mailing list pgsql-general

On 07/12/2018 05:28 PM, Igor Korot wrote:
> Hi,
>
>
> On Thu, Jul 12, 2018 at 12:16 PM, David G. Johnston
> <david.g.johnston@gmail.com> wrote:
>> On Thu, Jul 12, 2018 at 8:50 AM, Igor Korot <ikorot01@gmail.com> wrote:
>>>> No, see:
>>>>
>>>> https://www.postgresql.org/docs/10/static/sql-createtrigger.html
>>>>
>>>> AFTER trigger on views are STATEMENT level only.
>>> But I do have access to the STATEMENT right?
>>
>> Yes, except nothing in the system actually attempts to directly target
>> information_schema views with updates so there will never be a triggering
>> event.
>>
>> A normal trigger will not work - which is a large reason why event triggers
>> were implemented.
>>
>> All of the alternative ideas (which I think was just log file parsing)
>> you've decided are not viable for your need.  Thus you've seemingly
>> eliminated all viable options and you now need to make a business decision.
> [code]
> MyMac:/ igorkorot$ find . -name postgresql.conf
> find: ./.DocumentRevisions-V100: Permission denied
> find: ./.fseventsd: Permission denied
> find: ./.Spotlight-V100: Permission denied
> find: ./.Trashes: Permission denied
> find: ./dev/fd/3: Not a directory
> find: ./dev/fd/4: Not a directory
> find: ./Library/Application Support/Apple/ParentalControls/Users:
> Permission denied
> find: ./Library/Caches/com.apple.Spotlight/schema.501.plist: Permission denied
> find: ./Library/Caches/com.apple.Spotlight/schema.502.plist: Permission denied
> find: ./Library/Caches/com.apple.Spotlight/schema.89.plist: Permission denied
> find: ./Library/Caches/com.apple.Spotlight: Permission denied
> find: ./Library/PostgreSQL/9.1/data: Permission denied
> find: ./private/etc/cups/certs: Permission denied
> find: ./private/etc/raddb/certs: Permission denied
> find: ./private/etc/raddb/modules: Permission denied
> find: ./private/etc/raddb/sites-available: Permission denied
> find: ./private/etc/raddb/sites-enabled: Permission denied
> find: ./private/etc/raddb/sql: Permission denied
> find: ./private/tmp/launchd-158.ac7XMn: Permission denied
> find: ./private/tmp/launchd-47725.RroMYY: Permission denied
> find: ./private/tmp/launchd-49727.qQpnIz: Permission denied
> find: ./private/var/agentx: Permission denied
> find: ./private/var/at/tabs: Permission denied
> find: ./private/var/at/tmp: Permission denied
> find: ./private/var/audit: Permission denied
> find: ./private/var/backups: Permission denied
> find: ./private/var/db/ConfigurationProfiles/Setup: Permission denied
> find: ./private/var/db/dhcpclient: Permission denied
> find: ./private/var/db/dslocal/nodes/Default: Permission denied
> find: ./private/var/db/geod: Permission denied
> find: ./private/var/db/krb5kdc: Permission denied
> find: ./private/var/db/launchd.db/com.apple.launchd.peruser.0: Permission denied
> find: ./private/var/db/launchd.db/com.apple.launchd.peruser.200:
> Permission denied
> find: ./private/var/db/launchd.db/com.apple.launchd.peruser.202:
> Permission denied
> find: ./private/var/db/launchd.db/com.apple.launchd.peruser.212:
> Permission denied
> find: ./private/var/db/launchd.db/com.apple.launchd.peruser.502:
> Permission denied
> find: ./private/var/db/launchd.db/com.apple.launchd.peruser.88:
> Permission denied
> find: ./private/var/db/launchd.db/com.apple.launchd.peruser.89:
> Permission denied
> find: ./private/var/db/launchd.db/com.apple.launchd.peruser.92:
> Permission denied
> find: ./private/var/db/launchd.db/com.apple.launchd.peruser.97:
> Permission denied
> find: ./private/var/db/locationd: Permission denied
> find: ./private/var/db/Spotlight: Permission denied
> find: ./private/var/db/sudo: Permission denied
> find: ./private/var/folders/r9/_xhmtynj7xj22mwt_dcfbxqr0000gp/C:
> Permission denied
> find: ./private/var/folders/r9/_xhmtynj7xj22mwt_dcfbxqr0000gp/T:
> Permission denied
> find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n0000000000000/0/com.apple.revisiond.temp:
> Permission denied
> find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n0000000000000/C:
> Permission denied
> find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n0000000000000/Cleanup
> At Startup: Permission denied
> find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n0000000000000/T:
> Permission denied
> find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n000003000000r/T:
> Permission denied
> find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n0000084000021/C:
> Permission denied
> find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n0000084000021/T:
> Permission denied
> find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n000008w000027/C:
> Permission denied
> find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n000008w000027/T:
> Permission denied
> find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n00000b000002r/T:
> Permission denied
> find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n00000b400002s/C:
> Permission denied
> find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n00000b400002s/T:
> Permission denied
> find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n00000bh00002w/C:
> Permission denied
> find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n00000bh00002w/T:
> Permission denied
> find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n00000c4000031/C:
> Permission denied
> find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n00000c4000031/T:
> Permission denied
> find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n00000s0000068/C:
> Permission denied
> find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n00000s0000068/T:
> Permission denied
> find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n00000s800006_/C:
> Permission denied
> find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n00000s800006_/T:
> Permission denied
> find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n00000sm00006d/C:
> Permission denied
> find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n00000sm00006d/T:
> Permission denied
> find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n00000th00006m/C:
> Permission denied
> find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n00000th00006m/T:
> Permission denied
> find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n00000tm00006n/T:
> Permission denied
> find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n00000vr00006y/C:
> Permission denied
> find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n00000vr00006y/T:
> Permission denied
> find: ./private/var/jabberd: Permission denied
> find: ./private/var/lib/postfix: Permission denied
> find: ./private/var/log/com.apple.launchd.peruser.0: Permission denied
> find: ./private/var/log/com.apple.launchd.peruser.200: Permission denied
> find: ./private/var/log/com.apple.launchd.peruser.202: Permission denied
> find: ./private/var/log/com.apple.launchd.peruser.212: Permission denied
> find: ./private/var/log/com.apple.launchd.peruser.502: Permission denied
> find: ./private/var/log/com.apple.launchd.peruser.88: Permission denied
> find: ./private/var/log/com.apple.launchd.peruser.89: Permission denied
> find: ./private/var/log/com.apple.launchd.peruser.92: Permission denied
> find: ./private/var/log/com.apple.launchd.peruser.97: Permission denied
> find: ./private/var/log/krb5kdc: Permission denied
> find: ./private/var/log/radius: Permission denied
> find: ./private/var/pgsql_socket_alt: Permission denied
> find: ./private/var/root: Permission denied
> find: ./private/var/run/mds: Permission denied
> find: ./private/var/spool/cups: Permission denied
> find: ./private/var/spool/fax: Permission denied
> find: ./private/var/spool/mqueue: Permission denied
> find: ./private/var/spool/postfix/active: Permission denied
> find: ./private/var/spool/postfix/bounce: Permission denied
> find: ./private/var/spool/postfix/corrupt: Permission denied
> find: ./private/var/spool/postfix/defer: Permission denied
> find: ./private/var/spool/postfix/deferred: Permission denied
> find: ./private/var/spool/postfix/flush: Permission denied
> find: ./private/var/spool/postfix/hold: Permission denied
> find: ./private/var/spool/postfix/incoming: Permission denied
> find: ./private/var/spool/postfix/maildrop: Permission denied
> find: ./private/var/spool/postfix/private: Permission denied
> find: ./private/var/spool/postfix/public: Permission denied
> find: ./private/var/spool/postfix/saved: Permission denied
> find: ./private/var/spool/postfix/trace: Permission denied
> find: ./private/var/tmp/launchd: Permission denied
> find: ./System/Library/Caches/com.apple.coresymbolicationd: Permission denied
> find: ./System/Library/DirectoryServices/DefaultLocalDB/Default:
> Permission denied
> find: ./System/Library/User Template: Permission denied
> find: ./Users/igorkorot/Library/Saved Application
> State/com.adobe.flashplayer.installmanager.savedState: Permission
> denied
> find: ./Users/igorkorot/Library/Saved Application
> State/com.bitrock.appinstaller.savedState: Permission denied
> find: ./usr/sbin/authserver: Permission denied
> [/code]
>
> It looks like I dont have a configuration file.
> Where I should create one? This is on OSX 10.8.
>
> Thank you.
>
>> David J.
>>
>> p.s. Please remove the excess quoted material before hitting send.  At
>> minimum anything after the last text that you write.
Can you try that again as root? Or with sudo?