[PLUG-TALK] Finding PHP Expert

Rich Shepard rshepard at appl-ecosys.com
Thu Apr 7 21:52:51 UTC 2011


On Thu, 7 Apr 2011, Aaron Burt wrote:

> 1. There is a difference between "local" and network connections with
> Postgres.  When you tested the connection with psql, did you specify the
> exact same hostname (with -h) as your PHP code uses?  If you didn't, you
> made a "local" connection.

Aaron,

   Yes, I specified '-h localhost' and it makes no difference.

> 2. Google tells me there's a protocol change for Postgres 9 regarding the
> default encoding of bytearrays.  See:
> http://stackoverflow.com/questions/4828266/what-has-changed-between-postgres-jdbc-8-4-and-9-regarding-bytearrays
> and:
> http://www.postgresql.org/docs/9.0/static/runtime-config-client.html#GUC-BYTEA-OUTPUT
> If you can set the encoding to "escape" on the client or server, you might
> be OK.

   I changed the setting to 'escape' stopped and re-started the postmaster
and it makes no difference.

> 3. Can you use Postgres 8.4 instead?

   No, all my other databases are happily chugging away in 9.0.3.

Thanks,

Rich



More information about the PLUG-talk mailing list