On Tue, May 15, 2012 at 10:06 AM, Wes James <[email protected]> wrote: > On Mon, May 14, 2012 at 5:00 PM, Tom Lane <[email protected]> wrote: >> Wes James <[email protected]> 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. -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
