title: postgres default timezone
body: <p>I installed <code>PostgreSQL 9</code> and the time it is showing is 1 hour behind the server time.</p>
  
  <p>Running <code>Select NOW()</code> shows: <code>2011-07-12 11:51:50.453842+00</code></p>
  
  <p>The server date shows: <code>Tue Jul 12 12:51:40 BST 2011</code></p>
  
  <p>It is 1 hour behind but the timezone shown in <code>phppgadmin</code> is: <code>TimeZone    Etc/GMT0</code></p>
  
  <p>I have tried going into the <code>postgresql.conf</code> and setting </p>
  
  <blockquote>
    <p>timezone = GMT</p>
  </blockquote>
  
  <p>then running a restart but no change.</p>
  
  <p>Any ideas I thought it would have just used the server timezone but obviously not?!</p>
  
  <p>SOLUTION!:
  I did set to <code>GMT</code> before and it was an hour behind. after searching around turns out that I needed to set it to <code>Europe/London</code>. This takes into account the +1 hour in British summer time, GMT does not!</p>