[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