[pgpool-general: 3322] Re: role "admin" does not exist

[Nozomi Anzai]

Hi,

It seems that installing pgpool-II and PostgreSQL itself was succeeded, but
there were some small failures, because install.sh tries to proceed even
if CREATE USER fails.

In such a case, you should do "CREATE USER" in the all backend nodes
manually.

ex.)
CREATE USER admin PASSWORD 'pgpool' SUPERUSER;


> PGPOOL Version 3.4.0
> 
> using install.sh to install, but  get error below:
> 
> 2014-12-01 11:02:12: pid 17102: LOG: backend throws an error message
> 2014-12-01 11:02:12: pid 17102: DETAIL: role "admin" does not exist
> 2014-12-01 11:02:12: pid 17102: ERROR: unable to forward message to frontend
> 2014-12-01 11:02:12: pid 17102: DETAIL: FATAL error occured on backend
> 
> 
> and when promote node , get error below:
> Error Codee1007
> Error Messagepcp_detach_node command error occurred.
> 
> please give reason, thx
> 
> Thank you.
> 
> -- 
> 
> 
> Confidentiality Warning: This e-mail contains information intended only for 
> the use of the individual or entity named above. If the reader of this 
> e-mail is not the intended recipient or the employee or agent responsible 
> for delivering it to the intended recipient, any dissemination, publication 
> or copying of this e-mail is strictly prohibited. The sender does not 
> accept any responsibility for any loss, disruption or damage to your data 
> or computer system that may occur while using data contained in, or 
> transmitted with, this e-mail. If you have received this e-mail in error, 
> please immediately notify us by return e-mail. Thank you.
> 


-- 
Nozomi Anzai
SRA OSS, Inc. Japan