Re: order by different on mac vs linux - Mailing list pgsql-sql

From Wes James
Subject Re: order by different on mac vs linux
Date
Msg-id CAFjCMHsWa_gOtAWMcYwUsZ2mgr9QUZK1ReFFLEYzsu17NN8nEg@mail.gmail.com
Whole thread Raw
In response to Re: order by different on mac vs linux  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-sql
On Tue, May 15, 2012 at 10:16 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> On Tue, May 15, 2012 at 10:06 AM, Wes James <comptekki@gmail.com> wrote:
>> On Mon, May 14, 2012 at 5:00 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>> Wes James <comptekki@gmail.com> writes:
>>>> Why is there a different order on the different platforms.
>>>
>>> This is not exactly unusual.  You should first check to see if
>>> lc_collate is set differently in the two installations --- but even if
>>> it's the same, there are often platform-specific interpretations of
>>> the sorting rules.  (Not to mention that OS X is flat out broken when
>>> it comes to sorting UTF8 data ...)
>>>
>>> If you want consistent cross-platform results, "C" locale will get
>>> that for you, but it's pretty stupid about non-ASCII characters.
>>>
>>> For more info read
>>> http://www.postgresql.org/docs/9.1/static/charset.html
>>>
>>>                        regards, tom lane
>>
>> I tried using the postgres that comes with ubuntu (sudo apt-get
>> install postgresql).
>>
>> With my app I kept getting invalid password.  I went in to the
>> database sudo -u postgres database and did \password and set a
>> password, but I still got invalid password error from the app api
>> trying to make a connection.
>>
>> I then went back to the source installed version and now the output is
>> correct.  I'm not sure what changed. hmmm.
>
> It's most likely an issue with the settings in your pg_hba.conf file.

Ok - if I try the apt-get version, I'll look at that.  The apt-get
version is a cluster version.  Looks like that file is in
/etc/postgresql/9.1/dbname

I see

local all postgres peer
local all all peer
host all all 127.0.0.1/32 md5
host all all ::1/128 md5

in there.

-wes


pgsql-sql by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: order by different on mac vs linux
Next
From: Jan Bakuwel
Date:
Subject: Re: SELECT 1st field