On 08/01/11 11:12 AM, Johnny Edge wrote:
> I have a problem with identical versions of postgresql - 8.3.13
> Config files are identical. HostA is a 32 bit CentOS 5.3 install and
> the hostB is x86_64 CentOS 6.
> Difference in architecture should not be a problem - I have another 64
> bit CentOS where both queries are executed displaying identical results.
> However, libraries which postgresql is compiled against on host B are
> significantly newer.
> Any thoughts how can this be resolved?
> PostgreSQL is compiled from source on both servers.
same client encoding on both instances?
SHOW CLIENT_ENCODING;
SHOW LC_COLLATE;
--
john r pierce N 37, W 122
santa cruz ca mid-left coast