title: Installing Postgresql and PgAdmin3 on Linux
body: <p>I use Postgesql and PgAdmin on Windows without any problems but am struggling to get it working on Linux (I'm a Linux N00b).  I have installed the 64bit version on my Fedora box following <a href="http://www.diegognesi.it/?p=196" rel="nofollow">these instructions</a> (except substituting version 9.3 for 9.2).  Everything works well until I get to launching pgsql with:</p>
  
  <pre><code>sudo -u postgres psql template1
  </code></pre>
  
  <p>Here I get an error "Permission denied" as is attempts to change to my home directory.</p>
  
  <p>I can change the password for 'postgres' as per the instructions and I presume this is just so I can use 'md5' rather than 'trust' in pg_hba.conf (if not, then I don't understand why I need this step).</p>
  
  <p>When I fire up PgAdmin3, initially I have no connections.  Attempting to connect to the server gives me an authentication error for user 'postgres'.  I have tried resetting pg_hba.conf to 'trust' but that doesn't work either.</p>
  
  <p>I would appreciate an explanation of the 'postgres' user in Linux as it appears to be a separate actual user on the Linux system (unlike Windows where it is just a 'disembodied' user relevant only to Postgress).  Secondly, help in getting PgAdmin speaking to Postgresql would be gratefully received.</p>