How to test if Dataloader is working correctly, we are going to turn on server logging in order to see how many queries are being made to our db. If Dataloader is setup correctly, we should only see one hit on our db perrequest, even if duplicate data is being requested. Here's how to enable logging on postgresql. Note - This is the Mac way to enable logging.
-
subl /usr/local/var/postgres/postgresql.conf
-
around line 434
log_statement = 'all'
uncomment and set to alllog_statement = 'all'
-
then
brew service restart postgresql