tail -f /usr/local/var/log/postgres.log
/var/log/postgresql/postgresql-9.3-main.log
Here you can find all the informations about logs and how to set them with your preferences: https://www.postgresql.org/docs/9.1/runtime-config-logging.html