On Tue, May 15, 2012 at 10:16 AM, Scott Marlowe <scott.marl...@gmail.com> wrote: > On Tue, May 15, 2012 at 10:06 AM, Wes James <compte...@gmail.com> wrote: >> On Mon, May 14, 2012 at 5:00 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: >>> Wes James <compte...@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 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
