PostgreSQL > Administration
How to change a language of error messages
Open the postgresql.conf
file in the following directory:
C:\Program Files\PostgreSQL\15\data
You need to change the following settings:
# These settings are initialized by initdb, but they can be changed.
lc_messages = 'English_United States.1252' # locale for system error message
lc_monetary = 'English_United States.1252' # locale for monetary formatting
lc_numeric = 'English_United States.1252' # locale for number formatting
lc_time = 'English_United States.1252' # locale for time formatting
How to allow to call postgres from another machine (or docker container)
You should find two filws: pg_hba.conf
and postgresql.conf
.
On Windows they are located in C:\Program Files\PostgreSQL\15\data
.
In pg_hba.conf
you should change the following line:
# Allow connections from a specific IP address
host all all <CLIENT_IP>/32 md5
like this:
# IPv4 local connections:
host all all 192.168.10.104/32 scram-sha-256
Then in postgresql.conf
you should change the following line:
listen_addresses = '*' # what IP address(es) to listen on;