Justin’s Reviews > Practical SQL: A Beginner's Guide to Storytelling with Data > Status Update
Like flag
Justin’s Previous Updates
Justin
is on page 33 of 392
That ends the introduction.
If you use Linux, you are admonished to try to install pgadmin as part of a package. This didn't work for me so far. If I try to proceed with the exercises on the command line I'll update my opinion of the book.
My first impression is that it doesn't accommodate Linux sufficiently but is otherwise very straightforward.
— Apr 11, 2019 03:35AM
If you use Linux, you are admonished to try to install pgadmin as part of a package. This didn't work for me so far. If I try to proceed with the exercises on the command line I'll update my opinion of the book.
My first impression is that it doesn't accommodate Linux sufficiently but is otherwise very straightforward.
Comments Showing 1-6 of 6 (6 new)
date
newest »
newest »
That would be great. For the record I have used pgAdmin on Windows and it's very straightforward, just as the book describes, I just prefer to use Linux overall. I use Fedora 29. I have pgAdmin3, v 1.22.2, installed. I'll have to try to run the initial exercise with it again to recall exactly where I went astray.
I think I'm getting a permission issue:
Error: Error connecting to the server: FATAL: Peer
authentication failed for user "postgres"
$ uname -a
Linux localhost.localdomain 5.0.6-200.fc29.x86_64 #1 SMP
Wed Apr 3 15:09:51 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux
Hi, a few things:In the Linux world I'm most familiar with Ubuntu, but things should work fairly similarly with Fedora.
First thing to note is that pgAdmin 3 is no longer supported and doesn't work with recent versions of PostgreSQL. You'll want pgAdmin 4.
You can install via Yum, I believe. See https://computingforgeeks.com/how-to-... and also https://www.pgadmin.org/download/pgad...
Next, we should verify that PostgreSQL is running and you can connect via psql on the command line. See https://tecadmin.net/install-postgres... and let me know if you can get to a psql prompt.
We'll go from there.
The instructions for computing for geeks seemed promising, but there is something wrong with my configuration near the end, so I couldn't get pgAdmin4 to run. The command line interface, which I enabled following the techadmin site, is up and running. It's running despite an error I received:
# systemctl start postgresql-11.service
Job for postgresql-11.service failed because the control process exited with error code.
See "systemctl status postgresql-11.service" and "journalctl -xe" for details.
If you have psql running, you can do everything in the book. I cover psql in Chapter 16, so you might want to read that first and then proceed. If you're working solely on the command line, here are two utilities you might want to try that provide additional formatting and syntax options:
https://github.com/okbob/pspg
https://github.com/dbcli/pgcli
I'd do some more Googling as well on that error specific to your distro.
Thanks, I'll give those a recommendations a try. I'm sure that will work well-enough for my purposes.
Thanks for reading Practical SQL. Maybe I can help you get rolling with pgAdmin on Linux. Which distro are you using?
Best,
Anthony