Re: How to watch for schema changes

Hi,

On Thu, Jul 12, 2018 at 7:45 PM, Rob Sargent <robjsargent(at)gmail(dot)com> wrote:
>
>> [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.
>>

> Can you try that again as root? Or with sudo?

Yes, it did show up.
But now it looks like I have 2 places to set the logging:

log_statement_stats which I presume is just for statistics and
log_statement which I presume I should change.

Am I right?
Also, I had to turn on logging - use csvlog, and enable the directory
and filename.
I presume that this will not require the restart of the server, correct?

Thank you.

>
>