Re: Londiste won't start with dual IP addresses

On Fri, Aug 19, 2011 at 7:17 PM, Craig James <craig_james(at)emolecules(dot)com> wrote:
> On 8/19/11 1:40 AM, Marko Kreen wrote:
>> On Fri, Aug 19, 2011 at 2:44 AM, Craig James<craig_james(at)emolecules(dot)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.

Hm. Londiste does not do anything fancy with connections.
Perhaps you have some other problem.

Does 'londiste conf.ini provider tables' work?

Does 'londiste conf.ini subscriber tables' work?

Do you have pgqadm running on provider db?

--
marko