[Postgres-xc-general] Problem with starting datanode slave

[Juned K. <jkh...@gm...>]

Hi All,

When i tried to set max_connection value to 1000 it gave me this error

FATAL:  could not create semaphores: No space left on device
DETAIL:  Failed system call was semget(20008064, 17, 03600).

>From the docs i came to know that to use than much connection i have to
modify kernel configuration

But now i am now trying to set 500 connection instead of 1000 then its
giving below error.

LOG:  database system was interrupted while in recovery at log time
2014-04-16 09:06:06 WAT
HINT:  If this has occurred more than once some data might be corrupted and
you might need to choose an earlier recovery target.
LOG:  entering standby mode
LOG:  restored log file "000000010000000B00000011" from archive
FATAL:  hot standby is not possible because max_connections = 500 is a
lower setting than on the master server (its value was 1000)
LOG:  startup process (PID 16829) exited with exit code 1
LOG:  aborting startup due to startup process failure

It says master value is 1000 but i have set it to 500. seems it reading old
values i guess.

database=# show max_connections;
 max_connections
-----------------
 500
(1 row)

I have restarted all components several times but no luck.

Anyone please suggest if any other way is there to fix this like clearing
cache or something so it can read correct values.


Regards
Juned Khan