Open Source Development

Power Open Source Development

Explore the open source tools and capabilities for building and deploying modern applications on IBM Power platforms including AIX, IBM i, and Linux.


#Power


#Power


#Servers
#Opensource
 View Only
Back to discussions
Expand all | Collapse all

code page error attempting to access a postgres database

  • 1.  code page error attempting to access a postgres database

    Posted 08/01/18 01:16 AM

    Originally posted by: mmetts


    I just installed the recently available Postgesql client tools on one of our AIX 7.1 systems and I'm getting a code page error when attempting to connect to one of our Postgres instances.  I'm thinking that AIX (US English) tends to be latin1, right?  I'm a little confused about this error since we have other machines RHEL 7.5 (Intel) and RHEL 7.4 (PPCle) running variations of the client tools and then don't have a problem connecting to this particular instance.  Does anyone have thoughts or a workaround?  Please see below.  Thanks, Mike

     

    $ psql -h crcoyb1 -d bank
    Password:
    psql: FATAL:  conversion between LATIN1 and LATIN9 is not supported


    #AIX-Open-Source-Software
    #AIXOpenSource


  • 2.  Re: code page error attempting to access a postgres database

    Posted 08/01/18 01:39 AM

    Originally posted by: mmetts


    oh.  it looks like LC_ALL=C might have fixed it.  thanks.


    #AIXOpenSource
    #AIX-Open-Source-Software


Related Content