Comments on: How to install SQL Workbench for postgreSQL https://data36.com/install-sql-workbench-postgresql/ Learn Data Science the Hard Way! Tue, 06 Feb 2024 22:35:26 +0000 hourly 1 https://wordpress.org/?v=6.7.4 By: Tomi Mester https://data36.com/install-sql-workbench-postgresql/#comment-191036 Mon, 02 Nov 2020 12:34:39 +0000 https://data36.com/?p=1050#comment-191036 In reply to Sid.

cheers!

]]> By: How to install Python, SQL, R and Bash (for non-devs) https://data36.com/install-sql-workbench-postgresql/#comment-191025 Fri, 30 Oct 2020 11:17:49 +0000 https://data36.com/?p=1050#comment-191025 […] are better SQL manager tools. Here’s my favorite free SQL manager (and how to install it): SQL Workbench. (Note: Save this link for later, and now just finish the article with […]

]]> By: Tomi Mester https://data36.com/install-sql-workbench-postgresql/#comment-190870 Tue, 13 Oct 2020 21:14:42 +0000 https://data36.com/?p=1050#comment-190870 In reply to Bhagz.

Not necessarily but SQL Workbench is better than pgadmin4, in my opinion!

]]> By: What's the best computer/laptop for a data scientist? https://data36.com/install-sql-workbench-postgresql/#comment-120228 Wed, 22 Jan 2020 23:59:20 +0000 https://data36.com/?p=1050#comment-120228 […] SQL Workbench (or other SQL manager tools) […]

]]> By: Kerry DH https://data36.com/install-sql-workbench-postgresql/#comment-105096 Tue, 12 Nov 2019 22:28:41 +0000 https://data36.com/?p=1050#comment-105096 In reply to Patrick.

In case anyone else is looking for the solution…

In the SQL Workbench Connection Profile Window:
– Select the profile you want to configure SSL
– Click the “Extended Properties” button
– Add two Properties (click the blank sheet icon in the form header):
— sslrootcert and sslmode
— The Value for the sslrootcert property should be a full path to the .pem file
— The Value for the sslmode property should be: verify-full

Other values for sslmode can be found here: https://www.postgresql.org/docs/9.6/libpq-ssl.html

]]> By: How to connect Google Data Studio to PostgreSQL (6 steps) https://data36.com/install-sql-workbench-postgresql/#comment-91626 Thu, 19 Sep 2019 23:12:28 +0000 https://data36.com/?p=1050#comment-91626 […] Don’t get intimidated; you just have to type the very same credentials that you use with SQL Workbench or […]

]]> By: Tamás Tarczy https://data36.com/install-sql-workbench-postgresql/#comment-68324 Thu, 21 Mar 2019 21:04:10 +0000 https://data36.com/?p=1050#comment-68324 Hi Tomi,

I am on Mac and PC. I installed the pgAdmin4 but I can’t connect to the server:
Unable to connect to server:
FATAL: password authentication failed for user “xxxx”

Using the command line I can reach the server and I see the database. I use the same password and username in the pgAdmin without success.
I made all the setup that is written in the article.

What can be the problem?

Thank you

]]> By: Sid https://data36.com/install-sql-workbench-postgresql/#comment-56726 Sat, 02 Feb 2019 07:53:36 +0000 https://data36.com/?p=1050#comment-56726 wow Great Tomi i went through this first page will start reading all pages i think this is the best info to learn sql for data analysis.

]]> By: Tomi Mester https://data36.com/install-sql-workbench-postgresql/#comment-38665 Mon, 17 Sep 2018 09:41:52 +0000 https://data36.com/?p=1050#comment-38665 In reply to Eni Patrick.

Great, Eni!
Thanks for the comment and for the link!
Let me know if you need help with something! ; )
Tomi

]]> By: Eni Patrick https://data36.com/install-sql-workbench-postgresql/#comment-38182 Sun, 16 Sep 2018 01:54:35 +0000 https://data36.com/?p=1050#comment-38182 I found the solution to my question. Basically, I followed a variation of this:

https://blog.bigbinary.com/2016/01/23/configure-postgresql-to-allow-remote-connection.html

I just had to remember to do the steps as a root user and restart after each change I made.

]]>