Thread: Issue while connecting PostgreSQL 13 with Tableau 2020.3 & even applying COPY statement on PGAdmin

On Tue, Dec 15, 2020 at 5:32 PM Urmisha Patel <upp2134@gmail.com> wrote:
>
> Hi Team,
>
> Please help me in connecting PostgreSQL with Tableau.
>
> Error:
> An error occurred while communicating with PostgreSQL
> Unable to connect to the server. Check that the server is running and that you have access privileges to the
requesteddatabase.
 
> Error Code: 37CE01A3
> authentication method 10 not supported
>
> Unable to connect to the PostgreSQL server "localhost". Check that the server is running and that you have access
privilegesto the requested database.
 
>
> This is impacting the business. As a lot of data is in the database and Tableau makes it difficult to work.
> Please resolve it as soon as possible.
>
> For more details, I am sharing the screenshot of error generating while connecting with PostgreSql.
>
> I'm also facing problem in COPY statement while inserting multiple data via csv file in PGAdmin.
> Again, showing same error.
> "Access Priviledges"


This means you need to upgrade your driver to one that supports scram
authentication. You need client drivers (libpq) from PostgreSQL
version 10 or newer.

You can also downgrade the password security on your postgres
installation, but that's not recommended.

-- 
 Magnus Hagander
 Me: https://www.hagander.net/
 Work: https://www.redpill-linpro.com/

Hi!

Please don't remove the mailinglist from your replies.

This question is more for Tableau -- the PostgreSQL installeras ship
the newer drivers since version 10, and if Tableau used the ones
installed by PostgreSQL the problem wouldn't exist in those cases.
Thus, they must be using their own copy of the driver somehow, and you
need to ask them how to get that updated.

//Magnus


On Sat, Dec 19, 2020 at 11:42 PM Urmisha Patel <upp2134@gmail.com> wrote:
>
> Hi Magnus,
>
> Kindly reply on how to update the client libraries?
>
>
> On Wed, Dec 16, 2020 at 9:52 AM Urmisha Patel <upp2134@gmail.com> wrote:
>>
>> Hi Magnus,
>>
>> How to update the client driver?
>>
>> On Tue, Dec 15, 2020 at 11:39 AM Urmisha Patel <upp2134@gmail.com> wrote:
>>>
>>> Hi Magnus,
>>>
>>> Then can you share the link where I can download this client driver Libpg?
>>> I have upgraded the PostgreSql version from 10 to 13. But both are available within my PgAdmin.
>>>
>>> On Tue, Dec 15, 2020 at 11:36 AM Magnus Hagander <magnus@hagander.net> wrote:
>>>>
>>>> On Tue, Dec 15, 2020 at 5:32 PM Urmisha Patel <upp2134@gmail.com> wrote:
>>>> >
>>>> > Hi Team,
>>>> >
>>>> > Please help me in connecting PostgreSQL with Tableau.
>>>> >
>>>> > Error:
>>>> > An error occurred while communicating with PostgreSQL
>>>> > Unable to connect to the server. Check that the server is running and that you have access privileges to the
requesteddatabase.
 
>>>> > Error Code: 37CE01A3
>>>> > authentication method 10 not supported
>>>> >
>>>> > Unable to connect to the PostgreSQL server "localhost". Check that the server is running and that you have
accessprivileges to the requested database.
 
>>>> >
>>>> > This is impacting the business. As a lot of data is in the database and Tableau makes it difficult to work.
>>>> > Please resolve it as soon as possible.
>>>> >
>>>> > For more details, I am sharing the screenshot of error generating while connecting with PostgreSql.
>>>> >
>>>> > I'm also facing problem in COPY statement while inserting multiple data via csv file in PGAdmin.
>>>> > Again, showing same error.
>>>> > "Access Priviledges"
>>>>
>>>>
>>>> This means you need to upgrade your driver to one that supports scram
>>>> authentication. You need client drivers (libpq) from PostgreSQL
>>>> version 10 or newer.
>>>>
>>>> You can also downgrade the password security on your postgres
>>>> installation, but that's not recommended.
>>>>