Message-ID: <4E4EA383.3050304@emolecules.com>
Date: Fri, 19 Aug 2011 10:55:15 -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'
As I mentioned earlier, yes it does work.

I also discovered by looking at all the postgres processes that it's making the first connection (to the master), but it doesn't seem to even try to make the second connection.

Could there be something else it's waiting for?  The dual-network issue may be completely irrelevant.  I know that while the IT guy was reconfiguring the network, he had to do a forced-reboot at least once without shutting down Postgres.  Is it possible that the Londiste tables are in some invalid state, and the daemon is waiting for something that's never going to happen?

Thanks,
Craig