Обсуждение: Re: [RESENT]Implementing Replication via pgAdmin

Поиск
Список
Период
Сортировка

Re: [RESENT]Implementing Replication via pgAdmin

От
"Daniel B. Thurman"
Дата:
>>> I changed an entry in the myTest database table and I do not
>>> see this value replicated to the slave db.  Is there something
>>> more I need to do after coming
>>> this far along?
>>>
>>> So far I see:
>>>   <snipped out structure>
>>>
>>>   I am not sure where to look for any activities...
>>
>>I only see one listen on your slave. Make sure there is one there for
>>the master and not (just) the admin node.
>>
>>Regards, Dave.
>>
>
>I see that my Master and Slave replication process is not
>even running so at this point I am not sure how to start
>them running.  I have attached an image of my setup with
>full details and the file is a jpeg file of size 800K.
>
>Please review and let me know what I need to do.  The image
>shown has been static since yesterday and I have not done anything
>yet at this point.
>
>Thanks Dave!
>Dan

[RESEND]

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.487 / Virus Database: 269.13.22/1015 - Release Date: 9/18/2007 11:53 AM


Re: [RESENT]Implementing Replication via pgAdmin

От
Dave Page
Дата:
On Wed, 2007-09-19 at 08:28 -0700, Daniel B. Thurman wrote:

> >I see that my Master and Slave replication process is not
> >even running so at this point I am not sure how to start
> >them running.  

Are the slons running? They should be started from the Services control
panel applet after the engines are registered. When they are, check the
connections on each server to ensure they have actually connected. If
not, check the log files/event log for error messages to see why not. If
required, modify the config files or pgpass files are required and
restart the slons.

If they are connected and running, check that you have listens defined
on each node in the cluster for every other node in the cluster (except
the admin node).

Regards, Dave.