Windows 上的 Postgreql 配置文件: ‘ postgreql.conf’在哪里？

我收到这条消息，但我找不到 postgresql.conf文件:

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?
161564 次浏览
小开
最佳答案

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.

小开

On my machine:

C:\Program Files (x86)\OpenERP 6.1-20121026-233219\PostgreSQL\data
小开

You can find it by following this path

C:\Program Files\PostgreSQL\13\data
小开

you will get postgressql.conf file

C:/programfiles/postgressql/14/data you will also get the pg_hba to check username password


提交答案