Message-ID: <4E4E8CA9.8040800@emolecules.com>
Date: Fri, 19 Aug 2011 09:17:45 -0700
From: Craig James <craig_james@emolecules.com>
User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US;
	rv:1.9.2.18) Gecko/20110616 Thunderbird/3.1.11
MIME-Version: 1.0
To: Marko Kreen <markokr@gmail.com>
CC: pgsql-admin@postgresql.org
Subject: Re: Londiste won't start with dual IP addresses
References: <6998779.958621310027350384.JavaMail.defaultUser@defaultHost>
	<1313596948733-4708835.post@n5.nabble.com>	<4E4CA698.5010803@ringerc.id.au>
	<4E4DA3CD.5060003@emolecules.com>
	<CACMqXC+V3CxDKyCeLBncgONLtt_mjLMLBC-Fk2cBACySSM9pyw@mail.gmail.com>
In-Reply-To: 
 <CACMqXC+V3CxDKyCeLBncgONLtt_mjLMLBC-Fk2cBACySSM9pyw@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 8/19/11 1:40 AM, Marko Kreen wrote:
> On Fri, Aug 19, 2011 at 2:44 AM, Craig James<craig_james@emolecules.com>  wrote:
>> We had to temporarily assign two IP addresses to our servers.  After doing
>> so and rebooting, Londiste will start, but it just sits there doing nothing.
>>   The logfile has zero bytes, and it doesn't seem to connect to either the
>> master or the slave database.
>>
>> We reconfigured Postgres to listen on both addresses, but the /etc/hosts
>> tables still point to the original addresses (that is, the second IP address
>> shouldn't matter).  But I can connect to Postgres on either IP address on
>> all servers.
>>
>> All other Postgres applications work.  I can use psql, and our Perl DBI and
>> PHP applications all work with no problems.
>>
>> When I invoke "londiste.py --verbose ...", the log file says:
>>
>>   2011-08018 16:35:47,250  22074 DEBUG Attaching
>>
>> And that's all.  Nothing more ever happens.
>>
>> Help?  Thanks!
> Does the exact connect string you use in londiste config work
> with psql? Like so:
>
>    $ psql -d 'connstr'
Yes.

   psql -d 'dbname=archive host=iridium user=postgres'

connects with no problem.

Thanks,
Craig