Re: user can't access own database after creation

Can you try a very simple JDBC program to see if you can connect ?

Dave Cramer

davec(at)postgresintl(dot)com
www.postgresintl.com

On 2 December 2015 at 14:57, John R Pierce <pierce(at)hogranch(dot)com> wrote:

> On 12/2/2015 11:55 AM, Nuno Zimas wrote:
>
>> psql always connects successfully no matter what.
>> As for JDBC, we get the same results with or without ssl=true explicitly
>> appended to the URL.
>> What truly baffles me is that ye exact same java application works with
>> no hiccups against a quasi-vanilla pgsql backend i’ve installed on windows
>> 10.
>> So far, the only visible difference I found is in the values for
>> LC_COLLATE and LC_TYPE, which is V on the remote pgsql instances and
>> English_United States.1252 on the local pgsql instance.
>> Not sure how tis would affect accessing the DBs, though.
>>
>
> can you connect using psql on the windows system to the ubuntu hosted
> database?
>
>
>
> --
> john r pierce, recycling bits in santa cruz
>
>
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc
>