I have tried to follow the pgAdmin slony support in the help sections
of pgAdmin and it seems to be inconsistent. For example, it is not
intuitively clear from the help sections how exactly to setup the master
and slave configurations. From a windows client perspective, it seems
that one must us
e'
since
the 'Cluster Name' must have a value and 'OK' remains greyed out.
So I am at loss to go any further...
Any advice?
>-Original Message-
>From: Dave Page [mailto:[EMAIL PROTECTED]
>Sent: Monday, September 17, 2007 8:58 AM
>To: Da
As recommended, I downloaded and installed pgAdmin v1.8.0-beta5
and ran into some problems:
1) The update.bat script failed to update the v1.6.3 release that came
integrated with the postgreSQL v1.8.2 release. Failing that, I proceeded
to install the complete program into a seperate dire
Uh, forgot to also mention that the pgAdmin exe icon is missing
and shows some sort of an image but not that of ol' ele ;)
>-Original Message-
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED] Behalf Of Daniel B.
>Thurman
>Sent: Monday, September 17, 2007 2:50 PM
>> Thanks Dave.
>>
>> But I am having some trouble trying to get replication to work.
>>
>> Here is what I did:
>>
>> 1) On master server:
>>a) I registered: lib/slevent.dll
>>b) I register as a service: slon -regservice
>>c) slon -listengines
>> 2 engine(s) registered for serv
>
>Daniel B. Thurman wrote:
>> Uh, forgot to also mention that the pgAdmin exe icon is missing
>> and shows some sort of an image but not that of ol' ele ;)
>
>What colour depth is your display running at? Can you post a small
>screenshot?
>
>Thanks, Dave
I have gone over the following document:
http://www.slony.info/documentation/firstdb.html
To get some idea of what is going on (at the manual level)
as to how replication services works. From what I have done,
was to manually start the slon for the master and server sides
the following:
MASTER:
For some reason, I sent a post and it has never reached the pgAdmin-support
site, nor have I been receving any more new or replied postings? I noticed this
problem occurred yesterday (9/18/07) somtime in the afternoon (~1:00PM PST)?
Thanks -
Dan
No virus found in this outgoing message.
Checked
>>> 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:
>>>
>>>
>>> I am not sure where to look for any activities...
>>
>>I only see one
>For some reason, I sent a post and it has never reached the
>pgAdmin-support
>site, nor have I been receving any more new or replied
>postings? I noticed this
>problem occurred yesterday (9/18/07) somtime in the afternoon
>(~1:00PM PST)?
>
>Thanks -
>Dan
>
I have received this message, but I
>> >For some reason, I sent a post and it has never reached the
>> >pgAdmin-support
>> >site, nor have I been receving any more new or replied
>> >postings? I noticed this
>> >problem occurred yesterday (9/18/07) somtime in the afternoon
>> >(~1:00PM PST)?
>> >
>> >Thanks -
>> >Dan
>> >
>>
>>
As suggested by Dave,
The following link is a jpeg File, size 274K, showing the
pgAdmin3 setup I have so far. Note that there are a couple
of problems already found:
1) The Cluster name is now: CopperMasterCluster. I think that
slonik does not like '-' characters.
2) The entries for dbname
>> >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
>connect
Configuring Replication on Windows,
using pgAdmin3 v8.0 Beta 5
==
On Master:
==
1) Adding a new Master Replication Set:
a) Right-click 'Replication', and select: 'New slony-I Cluster...'
b) UnCheck: Join existing cluster
c) Enter: Cluster name: MasterClust
>> All is fine except that these slons are running as
>> foreground processes and cannot be backgrounded and
>> killing the command window will terminate the process!
>> How can I get the slons running without resorting to
>> using command windows to start the replication processes?
>
>Install t
What are the "rules" when defining the ID's for the replication sets
for both the master and slaves? I was not able to glean from the
online help if it makes any difference as to what values are chosen
for the IDs when creating a new replication set and whether or not
there should or should not b
I started out with a simple master and slave server arrangement and was
successfully
able to get the master to replicate to the slave. But once I added a second
slave, things
got much more confusing.
I had assumed that adding replication to a second slave server, the
relationship would
remain
>
>I started out with a simple master and slave server
>arrangement and was successfully
>able to get the master to replicate to the slave. But once I
>added a second slave, things
>got much more confusing.
>
>I had assumed that adding replication to a second slave
>server, the relationship woul
Strange as it seems, but that's right. I noticed that the use of PgAdmin
has the habit of moving windows desktop icons around! I keep trying to
but them back but it keeps doing it! It does not happen every time but
randomly, so it seems.
Dan
No virus found in this outgoing message.
Checked by
>On 22/09/2007 15:00, Daniel B. Thurman wrote:
>
>> I started out with a simple master and slave server
>arrangement and was successfully
>> able to get the master to replicate to the slave. But once I
>added a second slave, things
>> got much more confusing.
>
My objective is to setup and test replication, starting with a Master and
Slave-1 server, and once
replication has worked, to add an additional Slave-2 server for replication.
All of the replication
configuration was done strictly via pgAdmin3 v8.0-beta-5.
M
>Daniel B. Thurman wrote:
>> Thanks for some details and it helps, except the following step:
>>
>> 10) Create Paths on the master to both slaves, and on each
>slave back to
>> the master. Create the paths under each node on the master, using
>> the
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED] Behalf Of Dave Page
>Sent: Wednesday, October 10, 2007 1:31 AM
>To: pgadmin-hackers; pgAdmin Support; [EMAIL PROTECTED]
>Subject: [pgadmin-support] pgAdmin III v1.8.0 RC 1 released
>
>
>I'm pleased to announce the release of pgAdmin III v1.8.0 Rel
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED] Behalf Of Hiroshi Saito
>Sent: Wednesday, October 10, 2007 10:22 AM
>To: Daniel B. Thurman; pgAdmin Support
>Subject: Re: [pgadmin-support] pgAdmin III v1.8.0 RC 1 released
>
>
>Hi.
>
>From: "Daniel B. Thurman&q
24 matches
Mail list logo
