Question about PostgreSQL connection | Django | Page 1

oak lagoon Dec 23, 2023, 5:33 PM

#

Hey, it's me again.

So I'm a bit noob to Django and PostgreSQL, and I was checking the docs for Postgre.

I understand perfectly the content of this section:
https://docs.djangoproject.com/en/5.0/ref/settings/#std-setting-DATABASES

However, I don't understand much the latter part of the following, the "PostgreSQL connection settings" part:
https://docs.djangoproject.com/en/5.0/ref/databases/#postgresql-notes

I know what is psycopg2 and I have used it before, I'm OK with that part.
But I have no idea what is a "connection service file" nor a "password file", and what are their uses.
I checked PostgreSQL docs already, but it assumes I already know what is this for.
I don't even know how to create those files. This stuff isn't necessary at all right?

gaunt swift Dec 23, 2023, 5:43 PM

#

correct, I don't use them

#

they're conveniences to save you from having to type a username & password, or to store them in some other location

oak lagoon Dec 24, 2023, 2:55 AM

#

gaunt swift they're conveniences to save you from having to type a username & password, or t...

Thanks. Can I ask you how to create those files anyway? Just out of curiosity.

gaunt swift Dec 24, 2023, 2:56 AM

#

they're documented starting at https://www.postgresql.org/docs/current/libpq-envars.html

PostgreSQL Documentation

34.15. Environment Variables

34.15. Environment Variables # The following environment variables can be used to select default connection parameter values, which will be used …

#Question about PostgreSQL connection