hello all,<br><br>I been struggling with this issue whole day today but I do not know if this is bug in 3.2 version or not however, I downloaded from the <a href="http://git.postgresql.org/gitweb/?p=pgpool2.git;a=shortlog;h=refs/heads/V3_2_STABLE">http://git.postgresql.org/gitweb/?p=pgpool2.git;a=shortlog;h=refs/heads/V3_2_STABLE</a><br>
<br>recompiled and installed - this looks working now. It would be good people share if they were having similar issue.<br><br>KH<br><br><div class="gmail_quote">On Thu, Oct 4, 2012 at 2:06 PM, Khapare Joshi <span dir="ltr"><<a href="mailto:khapare77@gmail.com" target="_blank">khapare77@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Follow up:<br><br>When I connect with pgadmin I get following in the pgpool log<br><br>Oct 4 14:02:35 pgpool pgpool[15454]: connection received: host=myservertest port=57997<br>
Oct 4 14:02:35 pgpool pgpool[15454]: statement: SELECT version();<br>
Oct 4 14:02:35 pgpool pgpool[15454]: DB node id: 0 backend pid: 24949 statement: SELECT version();<br>Oct 4 14:02:35 pgpool pgpool[15454]: statement: SET DateStyle=ISO;#012SET bytea_output=escape;#012SELECT oid, pg_encoding_to_char(encoding) AS encoding, datlastsysoid#012 FROM pg_database WHERE datname='test1'<br>
Oct 4 14:02:35 pgpool pgpool[15454]: DB node id: 0 backend pid: 24949 statement: BEGIN<br>Oct 4 14:02:35 pgpool pgpool[15454]: DB node id: 1 backend pid: 3452 statement: BEGIN<br>Oct 4 14:02:35 pgpool pgpool[15454]: DB node id: 0 backend pid: 24949 statement: SET DateStyle=ISO;#012SET bytea_output=escape;#012SELECT oid, pg_encoding_to_char(encoding) AS encoding, datlastsysoid#012 FROM pg_database WHERE datname='test1'<br>
Oct 4 14:02:35 pgpool pgpool[15454]: DB node id: 1 backend pid: 3452 statement: SET DateStyle=ISO;#012SET bytea_output=escape;#012SELECT oid, pg_encoding_to_char(encoding) AS encoding, datlastsysoid#012 FROM pg_database WHERE datname='test1'<br>
Oct 4 14:02:35 pgpool pgpool[15454]: DB node id: 1 backend pid: 3452 statement: COMMIT<br>Oct 4 14:02:35 pgpool pgpool[15454]: DB node id: 0 backend pid: 24949 statement: COMMIT<br>Oct 4 14:02:35 pgpool pgpool[15454]: statement: set client_encoding to 'UNICODE'<br>
Oct 4 14:02:35 pgpool pgpool[15454]: DB node id: 0 backend pid: 24949 statement: BEGIN<br>Oct 4 14:02:35 pgpool pgpool[15454]: DB node id: 1 backend pid: 3452 statement: BEGIN<br>Oct 4 14:02:35 pgpool pgpool[15454]: DB node id: 0 backend pid: 24949 statement: set client_encoding to 'UNICODE'<br>
Oct 4 14:02:35 pgpool pgpool[15454]: DB node id: 1 backend pid: 3452 statement: set client_encoding to 'UNICODE'<br>Oct 4 14:02:35 pgpool pgpool[15454]: DB node id: 1 backend pid: 3452 statement: COMMIT<br>Oct 4 14:02:35 pgpool pgpool[15454]: DB node id: 0 backend pid: 24949 statement: COMMIT<br>
<br><br>so when I am connecting via php or datastudio - why it does not set the proper parameter for the data encoding ? <br><br>Am I missing something, can someone point me into right direction ?<br><br>KH<div class="HOEnZb">
<div class="h5"><br><br><br><div class="gmail_quote">
On Thu, Oct 4, 2012 at 12:35 PM, Khapare Joshi <span dir="ltr"><<a href="mailto:khapare77@gmail.com" target="_blank">khapare77@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hello all,<br><br>I can connect via pgamin3 to pgpool and run the query/insert statement. All seem work. Our development is based in php so when we connect via php and try query I get following error in pgpool.log<br><br>
Oct 4 12:23:20 pgpool pgpool[7845]: DB node id: 0 backend pid: 24441 statement: Parse: �#017�#001<br>
Oct 4 12:23:20 pgpool pgpool[7845]: DB node id: 1 backend pid: 3008 statement: Parse: �#017�#001<br>Oct 4 12:23:20 pgpool pgpool[7845]: Bind: cannot get parse message "pdo_stmt_00000001"<br>Oct 4 12:23:20 pgpool pgpool[7845]: do_child: exits with status 1 due to error<br>
<br><br>So, it seem to me php pdo is not sending the right info to the pgpool. Does anybody know how to resolve this issue ?<br><br>my pgpool version is :<br>3.2<br><br>postgres backend are : 9.2<br><br>Thanks in advance<br>
<br>KH<br><br><br>
</blockquote></div><br>
</div></div></blockquote></div><br>