title: Pg_cron crontab log
body: <p>We're trying to configure periodic jobs in Postgresql.
  To do this, we have installed on linux machine, with postgres 9.6 running, the
  citusdata pg_cron project.</p>
  
  <p><strong>System information</strong></p>
  
  <ul>
  <li>OS: Linux pg 4.4.0-72-generic #93-Ubuntu SMP</li>
  <li>PG: Postgres 9.6.3 installed from repo 'deb <a href="http://apt.postgresql.org/pub/repos/apt/" rel="noreferrer">http://apt.postgresql.org/pub/repos/apt/</a> xenial-pgdg main'</li>
  </ul>
  
  <p><strong>Citusdata pg_cron project</strong></p>
  
  <ul>
  <li><a href="https://github.com/citusdata/pg_cron" rel="noreferrer">https://github.com/citusdata/pg_cron</a></li>
  </ul>
  
  <p>Following the instructions in the pg_cron repository, we set in postgresql.conf 
  the configuration below </p>
  
  <pre><code>shared_preload_libraries = 'pg_cron'   
  cron.database_name = 'our db_name'
  </code></pre>
  
  <p>Then, on db_name, we created the EXTENSION pg_cron</p>
  
  <pre><code>CREATE EXTENSION pg_cron;
  </code></pre>
  
  <p>and we scheduled our first postgres job:</p>
  
  <pre><code>SELECT cron.schedule('45 12 * * *', $$CREATE TABLE testCron AS Select 'Test Cron' as Cron$$);
  </code></pre>
  
  <p>So, jobid 1 is created and listed in table cron.job.</p>
  
  <p>We expect that at 12:45 the command of the scheduled job will be launched.</p>
  
  <p>But nothing happens.</p>
  
  <p>testCron  table is not created and we have no trace in any logs.</p>
  
  <p>We have also defined LOG_FILE in /usr/src/pg_cron/include/pathnames.h to enable logging.</p>
  
  <p>But, after re-compiling the project and restarting postgres service, we did not track log for pg_cron.</p>
  
  <p>Can someone help us?</p>
  
  <p>How can we enable logs for pg_cron to check scheduling result?</p>
  
  <p>Thanks in advance!</p>