Where Is the Postgresql Config File: 'Postgresql. Conf' on Windows?
I'm Receiving This Message but I Can't Find the Postgresql. Conf File: Operationalerror: Could Not Connect to Server: Connection Refused (0X0000274D/10061) Is...
I'm receiving this message but I can't find the postgresql.conf file:
OperationalError: could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "???" and accepting
TCP/IP connections on port 5432?
could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "???" and accepting
TCP/IP connections on port 5432?
5 Answers
On my machine:
C:\Program Files\PostgreSQL\8.4\data\postgresql.conf
postgresql.conf is located in PostgreSQL's data directory. The data directory is configured during the setup and the setting is saved as PGDATA entry in c:\Program Files\PostgreSQL\<version>\pg_env.bat, for example
@ECHO OFF
REM The script sets environment variables helpful for PostgreSQL
@SET PATH="C:\Program Files\PostgreSQL\<version>\bin";%PATH%
@SET PGDATA=D:\PostgreSQL\<version>\data
@SET PGDATABASE=postgres
@SET PGUSER=postgres
@SET PGPORT=5432
@SET PGLOCALEDIR=C:\Program Files\PostgreSQL\<version>\share\locale
Alternatively you can query your database with SHOW config_file; if you are a superuser.
You can find it by following this path
C:\Program Files\PostgreSQL\13\data
On my machine:
C:\Program Files (x86)\OpenERP 6.1-20121026-233219\PostgreSQL\data
you will get postgressql.conf file
C:/programfiles/postgressql/14/data you will also get the pg_hba to check username password
David Miller brings 15 years of experience in global economics, personal finance strategy, and market dynamics. He specializes in turning complex economic trends into actionable insights for everyday readers.
