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 requested database.
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 privileges 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.

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

Hi Support Team,

I am still facing the problem of connecting PostgreSQL with Tableau.
My business is badly affecting.

On Tue, Dec 15, 2020 at 11:28 AM Urmisha Patel <upp2134@gmail.com> wrote:

Hi Team,

Please help me in connecting PostgreSQL with Tableau.

*Error:*

*An error occurred while communicating with PostgreSQLUnable to connect to
the server. Check that the server is running and that you have access
privileges to the requested database.Error Code: 37CE01A3authentication
method 10 not supportedUnable to connect to the PostgreSQL server
"localhost". Check that the server is running and that you have access
privileges 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"

Please solve this issue as soon as possible.

--
Warm Regards & Many Thanks,
Urmisha Patel

--
Warm Regards & Many Thanks,
Urmisha Patel

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