File Permission for Linux users

[AndreCoder]

Having trouble with data, code, or exercises in Practical SQL, 2nd Edition? I'm glad to help. Please answer these questions, and I'll typically reply within one to two business days.

Please include the chapter number in your issue title.
Chapter 1-SETTING UP YOUR CODING ENVIRONMENT

General

Please answer all of these as they're essential for troubleshooting.

What's your operating system (e.g. Windows 10, macOS Monterey, Ubuntu, etc.)? Linux -Fedora 42

Did you install PostgreSQL, PostGIS and pgAdmin according to the steps in Chapter 1? If not, please describe your installation (e.g., using RDS on Amazon Web Services). I installed Postgres in a Docker container

Which versions of PostgreSQL and pgAdmin 4 are you using? If you aren't sure, for PostgreSQL run the SQL command SELECT version(); and for pgAdmin 4, navigate to "About pgAdmin 4" under the "Help" menu.

PostgreSQL 18.1 (Debian 18.1-1.pgdg13+2) on x86_64-pc-linux-gnu, compiled by gcc (Debian 14.2.0-19) 14.2.0, 64-bit

Did you download the book's code examples and data from GitHub using the directions in Chapter 1? If not, please describe how you loaded the material on your computer. My laptop's OS is Windows 11 but my server is Fedora 11.

Issue or Question

Chapter, page and code listing number:

Describe the issue or your question:
On page 3, you have a note: to provide permission for the PostgreSQL database you will
install to read and write to the contents of the practical-sql-2-main folder for Windows users, but do I need to set permission for Linux users? If I have to provide permission for the PostgreSQL database you will
install to read and write to the contents of the practical-sql-2-main folder can you provide instructions.

Thank you
tCoder

Please paste the code and error message here. It's OK to alter identifying info such as a folder name

[anthonydb]

Hi, @AndreCoder.

You've got a setup that I'm less familiar with, but I'm glad to troubleshoot.

Assuming you have downloaded the book's code and data from this repo, have you reached any of the exercises in the book yet that include reading from or writing to the folders? If so, does it work or do you receive an error?