Re: [Postgres-xc-general] Add new coordinator error!

[Koichi S. <koi...@gm...>]

I found your configuration, in terms of owner and user, is the same as my
demonstration scenario.   Then what you should do is:

1. Log in to your operating system as pgxcUser,
2. Initialize Postgres-XC cluster with "init all" command of pgxc_ctl,

Then the database user $pgxcOwner should have been created and you don't
have to worry about it.   When you add a coordinator, simply issue "add
coordinator master" command.   It should work.  If you have any other
issue, please let me know.

My pgxc_ctl demonstration scenario will be found at
https://sourceforge.net/apps/mediawiki/postgres-xc/index.php?title=PGOpen2013_Postgres_Open_2013

The configuration is with full slaves, which you can disable.   The demo
adds a datanode, not a coordinator.   I believe there's no significant
differences.

Regards;

---
Koichi Suzuki


2013/10/7 Koichi Suzuki <koi...@gm...>

> I understood the situation.   Could you let me know if pgxc is not the
> operating system user name you are using?  If so, I will run the test with
> this situation and see what is going to happen.   Maybe a bug (not
> Postgres-XC core, but pgxc_ctl).   If pgxc is the operating system user you
> are using, then there could be another cause.  Also, please let me know
> your setting of pgxcUser in pgxc_ctl.conf?
>
> Best;
>
> ---
> Koichi Suzuki
>
>
> 2013/10/7 Julian <jul...@gm...>
>
>> Sorry, i found i have already config pgxcOwner=pgxc in pxc_ctl.conf.
>>
>> And i forgot to mention there's something strange about to add new
>> coordinator,
>> i can’t add coord4 by "add coordinator master coord4 node4 20004 20010
>> /opt/pgxc/nodes/coord”
>>
>> it will show me
>> ERROR: sorry found some inconflicts in coordinator master
>> configuration.PGXC$
>>
>> unless i add coord4 to pgxc_ctl.conf and remove it at PGXC shell
>> PGXC$ remove coordinator master coord4
>> ERROR:  PGXC Node coord4: object not defined
>> ERROR:  PGXC Node coord4: object not defined
>> ERROR:  PGXC Node coord4: object not defined
>>
>> Is it normal ?
>>
>> attach file is my pgxc config
>>
>> Julian
>> 使用 Sparrow <http://www.sparrowmailapp.com/?sig> 發信
>>
>> On 2013年10月7日Monday at 下午5:31, Koichi Suzuki wrote:
>>
>> Okay.   I'm wondering why internal pg_restore complains pgxc already
>> exists.    If you do not specify pgxc in pgxc_ctl and created it manually,
>> newly-craeted node should not contain the role pgxc, though we have
>> different massage.
>>
>> Could you let me know if you have any idea?
>>
>> Best;
>>
>> ---
>> Koichi Suzuki
>>
>>
>> 2013/10/7 Julian <jul...@gm...>
>>
>> I did not specify pgxc as a database owner, but i create user pgxc to do
>> these job.
>>
>> --
>> Julian
>> 使用 Sparrow <http://www.sparrowmailapp.com/?sig> 發信
>>
>> On 2013年10月7日Monday at 下午4:44, Koichi Suzuki wrote:
>>
>> Did you specify pgxc as a database owner
>>
>>
>>
>>
>>
>