http://localhost/ticket/1385 <p> Currently there is a problem because the docs guide us to set the sqlalchemy url to use 'localhost' i.e. loopback, whereas paster commands don't specify '-h localhost' so use unix sockets (you need to do 'sudo -u postgres'). These should be the same. </p> <p> Also do we need to tell people to add a line to their postgres authentication config /etc/postgresql/8.4/main/pg_hba.conf to help things? Florian suggests: </p> <pre class="wiki">local   std         std                          md5 </pre><p> /etc/postgresql/8.4/main/pg_hba.conf </p> en-us http://assets.okfn.org/p/ckan/img/ckan_logo_shortname.png http://localhost/ticket/1385 Trac 0.12.3 dread Wed, 12 Oct 2011 11:32:39 GMT http://localhost/ticket/1385#comment:1 http://localhost/ticket/1385#comment:1 <ul> <li><strong>cc</strong> <em>florian.marienfeld@…</em> added </li> </ul> <p> Another change needed for this (via Florian): </p> <pre class="wiki">diff -r 6f27828a4621 ckan/lib/cli.py --- a/ckan/lib/cli.py Wed Oct 12 11:10:32 2011 +0100 +++ b/ckan/lib/cli.py Wed Oct 12 12:23:18 2011 +0100 @@ -132,7 +132,7 @@ pg_cmd += ' -U %(db_user)s' % self.db_details if self.db_details.get('db_pass') not in (None, ''): pg_cmd = 'export PGPASSWORD=%(db_pass)s &amp;&amp; ' % self.db_details + pg_cmd - if self.db_details.get('db_host') not in (None, '', 'localhost'): + if self.db_details.get('db_host') not in (None, ''): pg_cmd += ' -h %(db_host)s' % self.db_details if self.db_details.get('db_port') not in (None, ''): pg_cmd += ' -p %(db_port)s' % self.db_details </pre> Ticket dread Tue, 10 Jan 2012 18:05:03 GMT http://localhost/ticket/1385#comment:2 http://localhost/ticket/1385#comment:2 <ul> <li><strong>status</strong> changed from <em>new</em> to <em>closed</em> </li> <li><strong>resolution</strong> set to <em>fixed</em> </li> </ul> <p> This patch has gone in (aimed for CKAN 1.5.2) [master 5b518e5]. </p> <p> Regarding setup to use unix sockets (as opposed to the loopback), I'm not keen, since it requires an extra step in editing the postgres config, for a barely noticeable performance improvement. Thanks for alerting us to it though, Florian. </p> Ticket