반응형
Postgre는 어디에 있습니까?SQL 저장소 구성/conf 파일?
는 최근에 Postgre를을 설치했습니다.Enterprise 패키지를 하는 Ubuntu의 SQL은 입니다.DB입니다. 로컬로 할 수 파일을 수 없어서 수 .데이터베이스에 로컬로 연결할 수 있지만 구성 파일을 찾을 수 없어서 구성할 수 없습니다.하드 드라이브 전체를 검색해보니 다음과 같은 샘플만 발견되었습니다.pg_hba.conf.sample
Postgre Postgre는 어디에 ?SQL SQL.conf 파일?
또는 데이터베이스에 문의하십시오.
$ psql -U postgres -c 'SHOW config_file'
또는, ubuntu사용자:
$ sudo -u postgres psql -c 'SHOW config_file'
Ubuntu 13.04센터를 :
제 위치는 다음과 같습니다.
/etc/postgresql/9.1/main/postgresql.conf
내 postgres *.conf 파일은 어디에 있습니까?
sql 쿼리를 사용하여 데이터베이스를 쿼리합니다.
SHOW config_file;
당신이 찾는 데 문제가 있을 수 있는 이유는postgresql.conf루트가 아닌 포스트그레스가 소유하고 있기 때문입니다.
페도라 17에 있는 내 것이 여기 있습니다.
[root@defiant /]# ll /var/lib/pgsql/data/postgresql.conf
게시자가 소유하고 있습니다.
-rw------- 1 postgres postgres 19332 Oct 14 09:38
/var/lib/pgsql/data/postgresql.conf
파일 검색으로 찾기 어려운 이유를 설명하는 600개의 권한이 있습니다.의 postgresql.conf사용 중인 운영 체제에 따라 다릅니다.
제 내용은 다음과 같습니다.
# -----------------------------
# PostgreSQL configuration file
# -----------------------------
#
# This file consists of lines of the form:
#
# name = value
#
# (The "=" is optional.) Whitespace may be used. Comments are introduced with
# "#" anywhere on a line. The complete list of parameter names and allowed
# values can be found in the PostgreSQL documentation.
#
# The commented-out settings shown in this file represent the default values.
# Re-commenting a setting is NOT sufficient to revert it to the default value;
# you need to reload the server.
#
# This file is read on server startup and when the server receives a SIGHUP
# signal. If you edit the file on a running system, you have to SIGHUP the
# server for the changes to take effect, or use "pg_ctl reload". Some
# parameters, which are marked below, require a server shutdown and restart to
# take effect.
#
# Any parameter can also be given as a command-line option to the server, e.g.,
# "postgres -c log_connections=on". Some parameters can be changed at run time
# with the "SET" SQL command.
#
# Memory units: kB = kilobytes Time units: ms = milliseconds
# MB = megabytes s = seconds
# GB = gigabytes min = minutes
# h = hours
# d = days
#------------------------------------------------------------------------------
# FILE LOCATIONS
#------------------------------------------------------------------------------
# The default values of these variables are driven from the -D command-line
# option or PGDATA environment variable, represented here as ConfigDir.
#data_directory = 'ConfigDir' # use data in another directory
# (change requires restart)
#hba_file = 'ConfigDir/pg_hba.conf' # host-based authentication file
# (change requires restart)
#ident_file = 'ConfigDir/pg_ident.conf' # ident configuration file
# (change requires restart)
# If external_pid_file is not explicitly set, no extra PID file is written.
#external_pid_file = '(none)' # write an extra PID file
# (change requires restart)
#------------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#------------------------------------------------------------------------------
# - Connection Settings -
#listen_addresses = 'localhost' # what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to 'localhost', '*' = all
# (change requires restart)
#port = 5432 # (change requires restart)
# Note: In RHEL/Fedora installations, you can't set the port number here;
# adjust it in the service file instead.
max_connections = 100 # (change requires restart)
# Note: Increasing max_connections costs ~400 bytes of shared memory per
# connection slot, plus lock space (see max_locks_per_transaction).
#superuser_reserved_connections = 3 # (change requires restart)
#unix_socket_directories = '/var/run/postgresql, /tmp'
# comma-separated list of directories
# (change requires restart)
#unix_socket_group = '' # (change requires restart)
#unix_socket_permissions = 0777 # begin with 0 to use octal notation
# (change requires restart)
#bonjour = off # advertise server via Bonjour
# (change requires restart)
#bonjour_name = '' # defaults to the computer name
# (change requires restart)
# - Security and Authentication -
#authentication_timeout = 1min # 1s-600s
#ssl = off # (change requires restart)
#ssl_ciphers = 'ALL:!ADH:!LOW:!EXP:!MD5:@STRENGTH' # allowed SSL ciphers
# (change requires restart)
#ssl_renegotiation_limit = 512MB # amount of data between renegotiations
#password_encryption = on
#db_user_namespace = off
# Kerberos and GSSAPI
#krb_server_keyfile = ''
#krb_srvname = 'postgres' # (Kerberos only)
#krb_caseins_users = off
# - TCP Keepalives -
# see "man 7 tcp" for details
#tcp_keepalives_idle = 0 # TCP_KEEPIDLE, in seconds;
# 0 selects the system default
#tcp_keepalives_interval = 0 # TCP_KEEPINTVL, in seconds;
# 0 selects the system default
#tcp_keepalives_count = 0 # TCP_KEEPCNT;
# 0 selects the system default
#------------------------------------------------------------------------------
# RESOURCE USAGE (except WAL)
#------------------------------------------------------------------------------
# - Memory -
shared_buffers = 24MB # min 128kB
# (change requires restart)
#temp_buffers = 8MB # min 800kB
#max_prepared_transactions = 0 # zero disables the feature
# (change requires restart)
# Note: Increasing max_prepared_transactions costs ~600 bytes of shared memory
# per transaction slot, plus lock space (see max_locks_per_transaction).
# It is not advisable to set max_prepared_transactions nonzero unless you
# actively intend to use prepared transactions.
#work_mem = 1MB # min 64kB
#maintenance_work_mem = 16MB # min 1MB
#max_stack_depth = 2MB # min 100kB
# - Kernel Resource Usage -
#max_files_per_process = 1000 # min 25
# (change requires restart)
#shared_preload_libraries = '' # (change requires restart)
# - Cost-Based Vacuum Delay -
#vacuum_cost_delay = 0ms # 0-100 milliseconds
#vacuum_cost_page_hit = 1 # 0-10000 credits
#vacuum_cost_page_miss = 10 # 0-10000 credits
#vacuum_cost_page_dirty = 20 # 0-10000 credits
#vacuum_cost_limit = 200 # 1-10000 credits
# - Background Writer -
#bgwriter_delay = 200ms # 10-10000ms between rounds
#bgwriter_lru_maxpages = 100 # 0-1000 max buffers written/round
#bgwriter_lru_multiplier = 2.0 # 0-10.0 multipler on buffers scanned/round
# - Asynchronous Behavior -
#effective_io_concurrency = 1 # 1-1000. 0 disables prefetching
#------------------------------------------------------------------------------
# WRITE AHEAD LOG
#------------------------------------------------------------------------------
# - Settings -
#wal_level = minimal # minimal, archive, or hot_standby
# (change requires restart)
#fsync = on # turns forced synchronization on or off
#synchronous_commit = on # synchronization level; on, off, or local
#wal_sync_method = fsync # the default is the first option
# supported by the operating system:
# open_datasync
# fdatasync (default on Linux)
# fsync
# fsync_writethrough
# open_sync
#full_page_writes = on # recover from partial page writes
#wal_buffers = -1 # min 32kB, -1 sets based on shared_buffers
# (change requires restart)
#wal_writer_delay = 200ms # 1-10000 milliseconds
#commit_delay = 0 # range 0-100000, in microseconds
#commit_siblings = 5 # range 1-1000
# - Checkpoints -
#checkpoint_segments = 3 # in logfile segments, min 1, 16MB each
#checkpoint_timeout = 5min # range 30s-1h
#checkpoint_completion_target = 0.5 # checkpoint target duration, 0.0 - 1.0
#checkpoint_warning = 30s # 0 disables
# - Archiving -
#archive_mode = off # allows archiving to be done
# (change requires restart)
#archive_command = '' # command to use to archive a logfile segment
#archive_timeout = 0 # force a logfile segment switch after this
# number of seconds; 0 disables
#------------------------------------------------------------------------------
# REPLICATION
#------------------------------------------------------------------------------
# - Master Server -
# These settings are ignored on a standby server
#max_wal_senders = 0 # max number of walsender processes
# (change requires restart)
#wal_sender_delay = 1s # walsender cycle time, 1-10000 milliseconds
#wal_keep_segments = 0 # in logfile segments, 16MB each; 0 disables
#vacuum_defer_cleanup_age = 0 # number of xacts by which cleanup is delayed
#replication_timeout = 60s # in milliseconds; 0 disables
#synchronous_standby_names = '' # standby servers that provide sync rep
# comma-separated list of application_name
# from standby(s); '*' = all
# - Standby Servers -
# These settings are ignored on a master server
#hot_standby = off # "on" allows queries during recovery
# (change requires restart)
#max_standby_archive_delay = 30s # max delay before canceling queries
# when reading WAL from archive;
# -1 allows indefinite delay
#max_standby_streaming_delay = 30s # max delay before canceling queries
# when reading streaming WAL;
# -1 allows indefinite delay
#wal_receiver_status_interval = 10s # send replies at least this often
# 0 disables
#hot_standby_feedback = off # send info from standby to prevent
# query conflicts
#------------------------------------------------------------------------------
# QUERY TUNING
#------------------------------------------------------------------------------
# - Planner Method Configuration -
#enable_bitmapscan = on
#enable_hashagg = on
#enable_hashjoin = on
#enable_indexscan = on
#enable_material = on
#enable_mergejoin = on
#enable_nestloop = on
#enable_seqscan = on
#enable_sort = on
#enable_tidscan = on
# - Planner Cost Constants -
#seq_page_cost = 1.0 # measured on an arbitrary scale
#random_page_cost = 4.0 # same scale as above
#cpu_tuple_cost = 0.01 # same scale as above
#cpu_index_tuple_cost = 0.005 # same scale as above
#cpu_operator_cost = 0.0025 # same scale as above
#effective_cache_size = 128MB
# - Genetic Query Optimizer -
#geqo = on
#geqo_threshold = 12
#geqo_effort = 5 # range 1-10
#geqo_pool_size = 0 # selects default based on effort
#geqo_generations = 0 # selects default based on effort
#geqo_selection_bias = 2.0 # range 1.5-2.0
#geqo_seed = 0.0 # range 0.0-1.0
# - Other Planner Options -
#default_statistics_target = 100 # range 1-10000
#constraint_exclusion = partition # on, off, or partition
#cursor_tuple_fraction = 0.1 # range 0.0-1.0
#from_collapse_limit = 8
#join_collapse_limit = 8 # 1 disables collapsing of explicit
# JOIN clauses
#------------------------------------------------------------------------------
# ERROR REPORTING AND LOGGING
#------------------------------------------------------------------------------
# - Where to Log -
#log_destination = 'stderr' # Valid values are combinations of
# stderr, csvlog, syslog, and eventlog,
# depending on platform. csvlog
# requires logging_collector to be on.
# This is used when logging to stderr:
logging_collector = on # Enable capturing of stderr and csvlog
# into log files. Required to be on for
# csvlogs.
# (change requires restart)
# These are only used if logging_collector is on:
#log_directory = 'pg_log' # directory where log files are written,
# can be absolute or relative to PGDATA
log_filename = 'postgresql-%a.log' # log file name pattern,
# can include strftime() escapes
#log_file_mode = 0600 # creation mode for log files,
# begin with 0 to use octal notation
log_truncate_on_rotation = on # If on, an existing log file with the
# same name as the new log file will be
# truncated rather than appended to.
# But such truncation only occurs on
# time-driven rotation, not on restarts
# or size-driven rotation. Default is
# off, meaning append to existing files
# in all cases.
log_rotation_age = 1d # Automatic rotation of logfiles will
# happen after that time. 0 disables.
log_rotation_size = 0 # Automatic rotation of logfiles will
# happen after that much log output.
# 0 disables.
# These are relevant when logging to syslog:
#syslog_facility = 'LOCAL0'
#syslog_ident = 'postgres'
#silent_mode = off # Run server silently.
# DO NOT USE without syslog or
# logging_collector
# (change requires restart)
# - When to Log -
#client_min_messages = notice # values in order of decreasing detail:
# debug5
# debug4
# debug3
# debug2
# debug1
# log
# notice
# warning
# error
#log_min_messages = warning # values in order of decreasing detail:
# debug5
# debug4
# debug3
# debug2
# debug1
# info
# notice
# warning
# error
# log
# fatal
# panic
#log_min_error_statement = error # values in order of decreasing detail:
# debug5
# debug4
# debug3
# debug2
# debug1
# info
# notice
# warning
# error
# log
# fatal
# panic (effectively off)
#log_min_duration_statement = -1 # -1 is disabled, 0 logs all statements
# and their durations, > 0 logs only
# statements running at least this number
# of milliseconds
# - What to Log -
#debug_print_parse = off
#debug_print_rewritten = off
#debug_print_plan = off
#debug_pretty_print = on
#log_checkpoints = off
#log_connections = off
#log_disconnections = off
#log_duration = off
#log_error_verbosity = default # terse, default, or verbose messages
#log_hostname = off
#log_line_prefix = '' # special values:
# %a = application name
# %u = user name
# %d = database name
# %r = remote host and port
# %h = remote host
# %p = process ID
# %t = timestamp without milliseconds
# %m = timestamp with milliseconds
# %i = command tag
# %e = SQL state
# %c = session ID
# %l = session line number
# %s = session start timestamp
# %v = virtual transaction ID
# %x = transaction ID (0 if none)
# %q = stop here in non-session
# processes
# %% = '%'
# e.g. '<%u%%%d> '
#log_lock_waits = off # log lock waits >= deadlock_timeout
#log_statement = 'none' # none, ddl, mod, all
#log_temp_files = -1 # log temporary files equal or larger
# than the specified size in kilobytes;
# -1 disables, 0 logs all temp files
#log_timezone = '(defaults to server environment setting)'
#------------------------------------------------------------------------------
# RUNTIME STATISTICS
#------------------------------------------------------------------------------
# - Query/Index Statistics Collector -
#track_activities = on
#track_counts = on
#track_functions = none # none, pl, all
#track_activity_query_size = 1024 # (change requires restart)
#update_process_title = on
#stats_temp_directory = 'pg_stat_tmp'
# - Statistics Monitoring -
#log_parser_stats = off
#log_planner_stats = off
#log_executor_stats = off
#log_statement_stats = off
#------------------------------------------------------------------------------
# AUTOVACUUM PARAMETERS
#------------------------------------------------------------------------------
#autovacuum = on # Enable autovacuum subprocess? 'on'
# requires track_counts to also be on.
#log_autovacuum_min_duration = -1 # -1 disables, 0 logs all actions and
# their durations, > 0 logs only
# actions running at least this number
# of milliseconds.
#autovacuum_max_workers = 3 # max number of autovacuum subprocesses
# (change requires restart)
#autovacuum_naptime = 1min # time between autovacuum runs
#autovacuum_vacuum_threshold = 50 # min number of row updates before
# vacuum
#autovacuum_analyze_threshold = 50 # min number of row updates before
# analyze
#autovacuum_vacuum_scale_factor = 0.2 # fraction of table size before vacuum
#autovacuum_analyze_scale_factor = 0.1 # fraction of table size before analyze
#autovacuum_freeze_max_age = 200000000 # maximum XID age before forced vacuum
# (change requires restart)
#autovacuum_vacuum_cost_delay = 20ms # default vacuum cost delay for
# autovacuum, in milliseconds;
# -1 means use vacuum_cost_delay
#autovacuum_vacuum_cost_limit = -1 # default vacuum cost limit for
# autovacuum, -1 means use
# vacuum_cost_limit
#------------------------------------------------------------------------------
# CLIENT CONNECTION DEFAULTS
#------------------------------------------------------------------------------
# - Statement Behavior -
#search_path = '"$user",public' # schema names
#default_tablespace = '' # a tablespace name, '' uses the default
#temp_tablespaces = '' # a list of tablespace names, '' uses
# only default tablespace
#check_function_bodies = on
#default_transaction_isolation = 'read committed'
#default_transaction_read_only = off
#default_transaction_deferrable = off
#session_replication_role = 'origin'
#statement_timeout = 0 # in milliseconds, 0 is disabled
#vacuum_freeze_min_age = 50000000
#vacuum_freeze_table_age = 150000000
#bytea_output = 'hex' # hex, escape
#xmlbinary = 'base64'
#xmloption = 'content'
# - Locale and Formatting -
datestyle = 'iso, mdy'
#intervalstyle = 'postgres'
#timezone = '(defaults to server environment setting)'
#timezone_abbreviations = 'Default' # Select the set of available time zone
# abbreviations. Currently, there are
# Default
# Australia
# India
# You can create your own file in
# share/timezonesets/.
#extra_float_digits = 0 # min -15, max 3
#client_encoding = sql_ascii # actually, defaults to database
# encoding
# These settings are initialized by initdb, but they can be changed.
lc_messages = 'en_US.UTF-8' # locale for system error message
# strings
lc_monetary = 'en_US.UTF-8' # locale for monetary formatting
lc_numeric = 'en_US.UTF-8' # locale for number formatting
lc_time = 'en_US.UTF-8' # locale for time formatting
# default configuration for text search
default_text_search_config = 'pg_catalog.english'
# - Other Defaults -
#dynamic_library_path = '$libdir'
#local_preload_libraries = ''
#------------------------------------------------------------------------------
# LOCK MANAGEMENT
#------------------------------------------------------------------------------
#deadlock_timeout = 1s
#max_locks_per_transaction = 64 # min 10
# (change requires restart)
# Note: Each lock table slot uses ~270 bytes of shared memory, and there are
# max_locks_per_transaction * (max_connections + max_prepared_transactions)
# lock table slots.
#max_pred_locks_per_transaction = 64 # min 10
# (change requires restart)
#------------------------------------------------------------------------------
# VERSION/PLATFORM COMPATIBILITY
#------------------------------------------------------------------------------
# - Previous PostgreSQL Versions -
#array_nulls = on
#backslash_quote = safe_encoding # on, off, or safe_encoding
#default_with_oids = off
#escape_string_warning = on
#lo_compat_privileges = off
#quote_all_identifiers = off
#sql_inheritance = on
#standard_conforming_strings = on
#synchronize_seqscans = on
# - Other Platforms and Clients -
#transform_null_equals = off
#------------------------------------------------------------------------------
# ERROR HANDLING
#------------------------------------------------------------------------------
#exit_on_error = off # terminate session on any error?
#restart_after_crash = on # reinitialize after backend crash?
#------------------------------------------------------------------------------
# CUSTOMIZED OPTIONS
#------------------------------------------------------------------------------
#custom_variable_classes = '' # list of custom variable class names
달려.
sudo updatedb
다음에
locate postgresql.conf
pg_hba.conf 파일의 위치를 가져오려면 다음과 같이 데이터베이스를 쿼리할 수도 있습니다.
SHOW hba_file;
당신은 다음과 같은 것을 얻어야 합니다.
hba_file
---------------------------------
/var/lib/pgsql/data/pg_hba.conf
(1 row)
설치한 지 얼마 안 된 경우 다음과 같은 문제가 발생할 수 있습니다.locate도움이 되지 않습니다.가 실행 , "" "" " " " " " 를 할 수 있습니다.
ps aux | grep 'postgres *-D'
postgresql-master가 구성 파일을 로드하는 위치를 확인합니다.
Mac(Brew를 사용하여 설치된 Postgres):
/usr/local/Cellar/postgresql/9.3.3>bin/postgres -D /usr/local/var/postgres/
pg_hba.conf 파일 위치 인쇄:
su - postgres -c "psql -t -P format=unaligned -c 'show hba_file';"
postgresql.conf 파일 위치 인쇄:
su - postgres -c "psql -t -P format=unaligned -c 'SHOW config_file';"
페도라 20에
$ cd /var/lib/pgsql/data
$ ls -ltr *.conf
-rw-------. 1 postgres postgres 20453 Jan 18 23:22 postgresql.conf
-rw-------. 1 postgres postgres 1636 Jan 18 23:22 pg_ident.conf
-rw-------. 1 postgres postgres 4476 Jan 18 23:22 pg_hba.conf
Mac OS X의 경우:
sudo find / -name postgresql.conf
다음 명령을 사용하여 다른 conf 파일을 찾을 수 있습니다.
sudo find / -name pg\*.conf
참고: man 사용법 참조:
man find
포 센트OS 6 및 7 및 postgresql 9.2(및 Fedora 및 Redhat 이하):
/var/lib/pgsql/data
포 센트OS 6 및 7은 gresql 9.3 또는 9.4 이상을 지원합니다.
/var/lib/pgsql/9.3/data
/var/lib/pgsql/9.4/data
Ubuntu 14 및 postgresql 9.3의 경우:
/etc/postgresql/9.3/main/postgresql.conf
아직 데이터베이스를 초기화하지 않은 것이 정답일 수 있습니다.postgres를 설치한 후 데이터베이스를 초기화하기 전에 postgres*.sql 파일이 없습니다.데이터베이스를 초기화하면 postgres*.sql 파일이 나타납니다. (Centos 6, Postgres 9.3은 여기에 나와 있습니다.)
[root@localhost /]# yum -y install postgresql93 postgresql93-server
[root@localhost /]# ls /var/lib/pgsql/9.3/data/
[root@localhost /]#
[root@localhost /]# service postgresql-9.3 initdb
Initializing database: [ OK ]
[root@localhost /]# ls /var/lib/pgsql/9.3/data/
base pg_ident.conf pg_serial pg_subtrans pg_xlog
global pg_log pg_snapshots pg_tblspc postgresql.conf
pg_clog pg_multixact pg_stat pg_twophase
pg_hba.conf pg_notify pg_stat_tmp PG_VERSION
[root@localhost /]#
30-07-2019
Windows 10 Pro의 경우:
C:\Program Files\PostgreSQL\11\data
계정에 수 없기 에 ( postgres를 실행할 수 SHOW config_fileWindows(윈도우)에 게시물이 설치되어 있지만 아무 대답도 도움이 되지 않아 나중에 Windows(윈도우) 판독기를 위해 파일 위치를 공유합니다.
C:\Program Files\PostgreSQL\9.5\data
직접적인 답변 외에도 Postgres 구성 파일 위치에 대한 문서를 확인하고 싶을 것입니다.
대부분의 경우: 아래$PGDATA보통은/var/lib/postgresql/data또는 유사한 것(최소한 도커 이미지를 사용하는 경우에는 기본 경로임).
이 스레드는 다양한 아키텍처에서 다양한 postgresql.conf 파일의 기본 위치를 문서화하기 때문에 좋습니다.
그러나 대체 위치를 지정한 설치에 이러한 기본값을 사용하여 문제가 발생했습니다.데이터베이스를 직접 쿼리하여 특정 구성 파일의 위치를 확인하는 한 가지 방법:
select * from pg_settings where name='config_file'
드롭 더where모든 설정을 볼 수 있는 절이며, 데이터 디렉토리, pg_dll.conf 등이 어디에 있는지 보여주기 때문에 켜질 수도 있습니다.
데비안 9의 경우 프랑크 하이켄스 답변을 사용하여 내 것을 찾았습니다 - $ /etc/postgresql/9.6/main/postgresql.conf
만약 당신이 도커 컨테이너에 포스트그를 가지고 있다면, 아마도 당신은 도커 밖에서 당신이 사용하고 있는 .conf 파일을 찾기 위해 .conf 파일을 바인딩하고 있을 것입니다.docker inspect postgres11또는 postgres 컨테이너 이름 또는 ID.이 명령은 json을 반환합니다. 다음과 같은 것을 찾습니다.
"HostConfig": {
"Binds": [
"/home/my_user/postgres11/:/var/lib/postgresql/data"
]
실행하는 경우SHOW config_file;그리고 결과는./var/lib/postgresql/data/postgresql.conf그러면 외부의 .conf 파일이 있는 것을 알 수 있습니다./home/my_user/postgres11/postgresql.conf또는 "바인즈" 속성이 생성되었습니다.
nantha=# SHOW config_file;
config_file
/var/lib/postgresql/data/postgresql.conf(1행)
nantha=# HBA_file 표시;
hba_file
/var/lib/postgresql/data/pg_syslog.conf(1행)
Win7, 버전 10 위치:
C:\Program Files\PostgreSQL\10\postgresql.conf
Postgre가 설치된 CentOS 7SQL 9.4 다음 디렉터리에 있습니다.
/var/lib/pgsql/9.4/data
루트로 로그인하면 볼 수 있습니다.
내가 사용했던 MacOS Mojave에서brew install postgresql설치하기 위해, 여기서 찾았습니다.
/usr/local/var/postgres/postgresql.conf
이 응답에 인용된 다음 sql 명령을 사용하여 이 정보를 얻었습니다.
psql -U postgres -c 'SHOW config_file'
Ubuntu 18/20의 경우 다음 명령을 실행하여 postgresql.conf 파일을 찾습니다.
locate postgresql.conf
Linux에서 locate가 누락된 경우 실행합니다.sudo apt-get install locate를 먼저 찾습니다.
여기서 찾았습니다.
/var/lib/pgsql/9.6/data/postgresql.conf
Ubuntu에서 다음을 찾을 수 있습니다.
/etc/postgresql/11/main/pg_hba.conf
// after change restart it otherwise it won't be work
service postgresql restart
별도의 EBS 볼륨에 마운트된 파일 시스템에 /data/ 디렉토리를 생성하는 것을 포함하여 AWS에 Postgresql을 설치하기 위해 Amazon에서 제공한 백서를 따르면 postgresql.conf 파일은 /data/에 있습니다.
여기서 결론적으로 파일은 데이터 디렉토리 초기화 중에 생성되며 data dir의 루트에 위치합니다.기본 설치의 경우 /var/lib/pgsql/data로 표시되지만 data dir를 이동한 경우에는 그렇지 않습니다.
내 설치는 기본이 아니지만 Postgres 디렉토리로 이동하여 하위 디렉토리 \Data를 찾을 수 있습니다.
구성 파일 C:\Postgres\Data\postgresql.conf C:\Postgres\Data\pg_hba.conf
2022-4-25 업데이트:
위치:/Library/PostgreSQL/14/data/postgresql.conf
시템스:MacOS Monterey
이 길을 찾는 사람이라면 누구나...
Linux에서 기본 위치는 다음과 같습니다.
cd /etc/postgresql/12/main/
12 버전 버전은 설치된 버전에 따라 달라질 수 있음
언급URL : https://stackoverflow.com/questions/3602450/where-does-postgresql-store-configuration-conf-files
반응형
'programing' 카테고리의 다른 글
| Windows에서 'sudo' 명령을 실행하는 방법 (0) | 2023.06.01 |
|---|---|
| 올바른 @author 태그를 얻으려면 Eclipse에서 ${user}을(를) 어떻게 설정해야 합니까? (0) | 2023.05.27 |
| 날짜 대 날짜 시간 (0) | 2023.05.27 |
| 다중 처리로 인해 Python이 충돌하고 fork()가 호출되었을 때 다른 스레드에서 진행 중이었을 수 있는 오류가 발생합니다. (0) | 2023.05.27 |
| C#과 VB.NET의 가장 중요한 기능적 차이점은 무엇입니까? (0) | 2023.05.27 |