[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [noalyss-generale] Problème PHP suite mise à niveau Ubuntu
From: |
ydc |
Subject: |
Re: [noalyss-generale] Problème PHP suite mise à niveau Ubuntu |
Date: |
Tue, 10 Jan 2023 18:36:10 +0100 |
Voici les sorties :
1. C'est «noalyss_sql», non?
usename | usesysid | usecreatedb | usesuper | userepl | usebypassrls
| passwd | valuntil | useconfig
-------------+----------+-------------+----------+---------+--------------+----------+----------+-----------
noalyss_sql | 16400 | t | t | f |
f | ******** | |
postgres | 10 | t | t | t |
t | ******** | |
(2 rows)
2. Je colle la sortie ci-dessous (346 lignes) mais je ne sais rien en tirer.
3. Sortie :
sudo -i -u postgres
postgres@WELT-AG:~$ psql template1 -c -c " select * from pg_hba_file_rules"
Password for user select * from pg_hba_file_rules:
C'est une erreur, ça, non, le nom d'utilisateur?
En tous cas, le mot de passe ne fontionne pas.
Mais j'avais changé «indent» → «peer» dans le fichier.
Comment fais-t-on pour voir le mot de passe de l'utilisateur noalyss_sql
pour voir s'il est correct dans le fichier de configuration Noalyss?
Bonne soirée à toi et merci encore.
y
name | setting | description
----------------------------------------+-----------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------
allow_in_place_tablespaces |
off | Allows tablespaces directly
inside pg_tblspc, for testing.
allow_system_table_mods |
off | Allows modifications of the
structure of system tables.
application_name |
psql | Sets the application name to
be reported in statistics and logs.
archive_cleanup_command | |
Sets the shell command that will be executed at every restart point.
archive_command |
(disabled) | Sets the shell command that
will be called to archive a WAL file.
archive_mode |
off | Allows archiving of WAL files
using archive_command.
archive_timeout |
0 | Forces a switch to the next
WAL file if a new file has not been started within N seconds.
array_nulls |
on | Enable input of NULL elements
in arrays.
authentication_timeout |
1min | Sets the maximum allowed time
to complete client authentication.
autovacuum |
on | Starts the autovacuum subprocess.
autovacuum_analyze_scale_factor |
0.1 | Number of tuple inserts,
updates, or deletes prior to analyze as a fraction of reltuples.
autovacuum_analyze_threshold |
50 | Minimum number of tuple
inserts, updates, or deletes prior to analyze.
autovacuum_freeze_max_age |
200000000 | Age at which to autovacuum a
table to prevent transaction ID wraparound.
autovacuum_max_workers |
3 | Sets the maximum number of
simultaneously running autovacuum worker processes.
autovacuum_multixact_freeze_max_age |
400000000 | Multixact age at which to
autovacuum a table to prevent multixact wraparound.
autovacuum_naptime |
1min | Time to sleep between
autovacuum runs.
autovacuum_vacuum_cost_delay |
2ms | Vacuum cost delay in
milliseconds, for autovacuum.
autovacuum_vacuum_cost_limit |
-1 | Vacuum cost amount available
before napping, for autovacuum.
autovacuum_vacuum_insert_scale_factor |
0.2 | Number of tuple inserts prior
to vacuum as a fraction of reltuples.
autovacuum_vacuum_insert_threshold |
1000 | Minimum number of tuple
inserts prior to vacuum, or -1 to disable insert vacuums.
autovacuum_vacuum_scale_factor |
0.2 | Number of tuple updates or
deletes prior to vacuum as a fraction of reltuples.
autovacuum_vacuum_threshold |
50 | Minimum number of tuple
updates or deletes prior to vacuum.
autovacuum_work_mem |
-1 | Sets the maximum memory to be
used by each autovacuum worker process.
backend_flush_after |
0 | Number of pages after which
previously performed writes are flushed to disk.
backslash_quote |
safe_encoding | Sets whether "\'" is allowed
in string literals.
backtrace_functions | | Log
backtrace for errors in these functions.
bgwriter_delay |
200ms | Background writer sleep time
between rounds.
bgwriter_flush_after |
512kB | Number of pages after which
previously performed writes are flushed to disk.
bgwriter_lru_maxpages |
100 | Background writer maximum
number of LRU pages to flush per round.
bgwriter_lru_multiplier |
2 | Multiple of the average buffer
usage to free per round.
block_size |
8192 | Shows the size of a disk block.
bonjour |
off | Enables advertising the server
via Bonjour.
bonjour_name | | Sets the
Bonjour service name.
bytea_output |
hex | Sets the output format for bytea.
check_function_bodies |
on | Check routine bodies during
CREATE FUNCTION and CREATE PROCEDURE.
checkpoint_completion_target |
0.9 | Time spent flushing dirty
buffers during checkpoint, as fraction of checkpoint interval.
checkpoint_flush_after |
256kB | Number of pages after which
previously performed writes are flushed to disk.
checkpoint_timeout |
5min | Sets the maximum time between
automatic WAL checkpoints.
checkpoint_warning |
30s | Enables warnings if checkpoint
segments are filled more frequently than this.
client_connection_check_interval |
0 | Sets the time interval between
checks for disconnection while running queries.
client_encoding |
UTF8 | Sets the client's character
set encoding.
client_min_messages |
notice | Sets the message levels that
are sent to the client.
cluster_name |
14/main | Sets the name of the cluster,
which is included in the process title.
commit_delay |
0 | Sets the delay in microseconds
between transaction commit and flushing WAL to disk.
commit_siblings |
5 | Sets the minimum concurrent
open transactions before performing commit_delay.
compute_query_id |
auto | Compute query identifiers.
config_file |
/etc/postgresql/14/main/postgresql.conf | Sets the server's main
configuration file.
constraint_exclusion |
partition | Enables the planner to use
constraints to optimize queries.
cpu_index_tuple_cost |
0.005 | Sets the planner's estimate of
the cost of processing each index entry during an index scan.
cpu_operator_cost |
0.0025 | Sets the planner's estimate of
the cost of processing each operator or function call.
cpu_tuple_cost |
0.01 | Sets the planner's estimate of
the cost of processing each tuple (row).
cursor_tuple_fraction |
0.1 | Sets the planner's estimate of
the fraction of a cursor's rows that will be retrieved.
data_checksums |
off | Shows whether data checksums
are turned on for this cluster.
data_directory |
/var/lib/postgresql/14/main | Sets the server's data directory.
data_directory_mode |
0700 | Shows the mode of the data
directory.
data_sync_retry |
off | Whether to continue running
after a failure to sync data files.
DateStyle | ISO,
DMY | Sets the display format for date
and time values.
db_user_namespace |
off | Enables per-database user names.
deadlock_timeout |
1s | Sets the time to wait on a
lock before checking for deadlock.
debug_assertions |
off | Shows whether the running
server has assertion checks enabled.
debug_discard_caches |
0 | Aggressively flush system
caches for debugging purposes.
debug_pretty_print |
on | Indents parse and plan tree
displays.
debug_print_parse |
off | Logs each query's parse tree.
debug_print_plan |
off | Logs each query's execution plan.
debug_print_rewritten |
off | Logs each query's rewritten
parse tree.
default_statistics_target |
100 | Sets the default statistics
target.
default_table_access_method |
heap | Sets the default table access
method for new tables.
default_tablespace | | Sets
the default tablespace to create tables and indexes in.
default_text_search_config |
pg_catalog.french | Sets default text search
configuration.
default_toast_compression |
pglz | Sets the default compression
method for compressible values.
default_transaction_deferrable |
off | Sets the default deferrable
status of new transactions.
default_transaction_isolation | read
committed | Sets the transaction isolation
level of each new transaction.
default_transaction_read_only |
off | Sets the default read-only
status of new transactions.
dynamic_library_path |
$libdir | Sets the path for dynamically
loadable modules.
dynamic_shared_memory_type |
posix | Selects the dynamic shared
memory implementation used.
effective_cache_size |
4GB | Sets the planner's assumption
about the total size of the data caches.
effective_io_concurrency |
1 | Number of simultaneous
requests that can be handled efficiently by the disk subsystem.
enable_async_append |
on | Enables the planner's use of
async append plans.
enable_bitmapscan |
on | Enables the planner's use of
bitmap-scan plans.
enable_gathermerge |
on | Enables the planner's use of
gather merge plans.
enable_hashagg |
on | Enables the planner's use of
hashed aggregation plans.
enable_hashjoin |
on | Enables the planner's use of
hash join plans.
enable_incremental_sort |
on | Enables the planner's use of
incremental sort steps.
enable_indexonlyscan |
on | Enables the planner's use of
index-only-scan plans.
enable_indexscan |
on | Enables the planner's use of
index-scan plans.
enable_material |
on | Enables the planner's use of
materialization.
enable_memoize |
on | Enables the planner's use of
memoization.
enable_mergejoin |
on | Enables the planner's use of
merge join plans.
enable_nestloop |
on | Enables the planner's use of
nested-loop join plans.
enable_parallel_append |
on | Enables the planner's use of
parallel append plans.
enable_parallel_hash |
on | Enables the planner's use of
parallel hash plans.
enable_partition_pruning |
on | Enables plan-time and
execution-time partition pruning.
enable_partitionwise_aggregate |
off | Enables partitionwise
aggregation and grouping.
enable_partitionwise_join |
off | Enables partitionwise join.
enable_seqscan |
on | Enables the planner's use of
sequential-scan plans.
enable_sort |
on | Enables the planner's use of
explicit sort steps.
enable_tidscan |
on | Enables the planner's use of
TID scan plans.
escape_string_warning |
on | Warn about backslash escapes
in ordinary string literals.
event_source |
PostgreSQL | Sets the application name used
to identify PostgreSQL messages in the event log.
exit_on_error |
off | Terminate session on any error.
extension_destdir | | Path to
prepend for extension loading
external_pid_file |
/var/run/postgresql/14-main.pid | Writes the postmaster PID to
the specified file.
extra_float_digits |
1 | Sets the number of digits
displayed for floating-point values.
force_parallel_mode |
off | Forces use of parallel query
facilities.
from_collapse_limit |
8 | Sets the FROM-list size beyond
which subqueries are not collapsed.
fsync |
on | Forces synchronization of
updates to disk.
full_page_writes |
on | Writes full pages to WAL when
first modified after a checkpoint.
geqo |
on | Enables genetic query
optimization.
geqo_effort |
5 | GEQO: effort is used to set
the default for other GEQO parameters.
geqo_generations |
0 | GEQO: number of iterations of
the algorithm.
geqo_pool_size |
0 | GEQO: number of individuals in
the population.
geqo_seed |
0 | GEQO: seed for random path
selection.
geqo_selection_bias |
2 | GEQO: selective pressure
within the population.
geqo_threshold |
12 | Sets the threshold of FROM
items beyond which GEQO is used.
gin_fuzzy_search_limit |
0 | Sets the maximum allowed
result for exact search by GIN.
gin_pending_list_limit |
4MB | Sets the maximum size of the
pending list for GIN index.
hash_mem_multiplier |
1 | Multiple of work_mem to use
for hash tables.
hba_file |
/etc/postgresql/14/main/pg_hba.conf | Sets the server's "hba"
configuration file.
hot_standby |
on | Allows connections and queries
during recovery.
hot_standby_feedback |
off | Allows feedback from a hot
standby to the primary that will avoid query conflicts.
huge_page_size |
0 | The size of huge page that
should be requested.
huge_pages |
try | Use of huge pages on Linux or
Windows.
ident_file |
/etc/postgresql/14/main/pg_ident.conf | Sets the server's "ident"
configuration file.
idle_in_transaction_session_timeout |
0 | Sets the maximum allowed idle
time between queries, when in a transaction.
idle_session_timeout |
0 | Sets the maximum allowed idle
time between queries, when not in a transaction.
ignore_checksum_failure |
off | Continues processing after a
checksum failure.
ignore_invalid_pages |
off | Continues recovery after an
invalid pages failure.
ignore_system_indexes |
off | Disables reading from system
indexes.
in_hot_standby |
off | Shows whether hot standby is
currently active.
integer_datetimes |
on | Shows whether datetimes are
integer based.
IntervalStyle |
postgres | Sets the display format for
interval values.
jit |
on | Allow JIT compilation.
jit_above_cost |
100000 | Perform JIT compilation if
query is more expensive.
jit_debugging_support |
off | Register JIT-compiled
functions with debugger.
jit_dump_bitcode |
off | Write out LLVM bitcode to
facilitate JIT debugging.
jit_expressions |
on | Allow JIT compilation of
expressions.
jit_inline_above_cost |
500000 | Perform JIT inlining if query
is more expensive.
jit_optimize_above_cost |
500000 | Optimize JIT-compiled
functions if query is more expensive.
jit_profiling_support |
off | Register JIT-compiled
functions with perf profiler.
jit_provider |
llvmjit | JIT provider to use.
jit_tuple_deforming |
on | Allow JIT compilation of tuple
deforming.
join_collapse_limit |
8 | Sets the FROM-list size beyond
which JOIN constructs are not flattened.
krb_caseins_users |
off | Sets whether Kerberos and
GSSAPI user names should be treated as case-insensitive.
krb_server_keyfile |
FILE:/etc/postgresql-common/krb5.keytab | Sets the location of the
Kerberos server key file.
lc_collate |
fr_BE.UTF-8 | Shows the collation order locale.
lc_ctype |
fr_BE.UTF-8 | Shows the character
classification and case conversion locale.
lc_messages |
fr_BE.UTF-8 | Sets the language in which
messages are displayed.
lc_monetary |
fr_BE.UTF-8 | Sets the locale for formatting
monetary amounts.
lc_numeric |
fr_BE.UTF-8 | Sets the locale for formatting
numbers.
lc_time |
fr_BE.UTF-8 | Sets the locale for formatting
date and time values.
listen_addresses |
localhost | Sets the host name or IP
address(es) to listen to.
listen_addresses |
localhost | Sets the host name or IP
address(es) to listen to.
lo_compat_privileges |
off | Enables backward compatibility
mode for privilege checks on large objects.
local_preload_libraries | |
Lists unprivileged shared libraries to preload into each backend.
lock_timeout |
0 | Sets the maximum allowed
duration of any wait for a lock.
log_autovacuum_min_duration |
-1 | Sets the minimum execution
time above which autovacuum actions will be logged.
log_checkpoints |
off | Logs each checkpoint.
log_connections |
off | Logs each successful connection.
log_destination |
stderr | Sets the destination for
server log output.
log_directory |
log | Sets the destination directory
for log files.
log_disconnections |
off | Logs end of a session,
including duration.
log_duration |
off | Logs the duration of each
completed SQL statement.
log_error_verbosity |
default | Sets the verbosity of logged
messages.
log_executor_stats |
off | Writes executor performance
statistics to the server log.
log_file_mode |
0600 | Sets the file permissions for
log files.
log_filename |
postgresql-%Y-%m-%d_%H%M%S.log | Sets the file name pattern for
log files.
log_hostname |
off | Logs the host name in the
connection logs.
log_line_prefix | %m [%p]
%q%u@%d | Controls information prefixed to each
log line.
log_lock_waits |
off | Logs long lock waits.
log_min_duration_sample |
-1 | Sets the minimum execution
time above which a sample of statements will be logged. Sampling is
determined by log_statement_sample_r
ate.
log_min_duration_statement |
-1 | Sets the minimum execution
time above which all statements will be logged.
log_min_error_statement |
error | Causes all statements
generating error at or above this level to be logged.
log_min_messages |
warning | Sets the message levels that
are logged.
log_parameter_max_length |
-1 | When logging statements, limit
logged parameter values to first N bytes.
log_parameter_max_length_on_error |
0 | When reporting an error, limit
logged parameter values to first N bytes.
log_parser_stats |
off | Writes parser performance
statistics to the server log.
log_planner_stats |
off | Writes planner performance
statistics to the server log.
log_recovery_conflict_waits |
off | Logs standby recovery conflict
waits.
log_replication_commands |
off | Logs each replication command.
log_rotation_age |
1d | Automatic log file rotation
will occur after N minutes.
log_rotation_size |
10MB | Automatic log file rotation
will occur after N kilobytes.
log_statement |
none | Sets the type of statements
logged.
log_statement_sample_rate |
1 | Fraction of statements
exceeding log_min_duration_sample to be logged.
log_statement_stats |
off | Writes cumulative performance
statistics to the server log.
log_temp_files |
-1 | Log the use of temporary files
larger than this number of kilobytes.
log_timezone |
Europe/Brussels | Sets the time zone to use in
log messages.
log_transaction_sample_rate |
0 | Sets the fraction of
transactions from which to log all statements.
log_truncate_on_rotation |
off | Truncate existing log files of
same name during log rotation.
logging_collector |
off | Start a subprocess to capture
stderr output and/or csvlogs into log files.
logical_decoding_work_mem |
64MB | Sets the maximum memory to be
used for logical decoding.
maintenance_io_concurrency |
10 | A variant of
effective_io_concurrency that is used for maintenance work.
maintenance_work_mem |
64MB | Sets the maximum memory to be
used for maintenance operations.
max_connections |
100 | Sets the maximum number of
concurrent connections.
max_files_per_process |
1000 | Sets the maximum number of
simultaneously open files for each server process.
max_function_args |
100 | Shows the maximum number of
function arguments.
max_identifier_length |
63 | Shows the maximum identifier
length.
max_index_keys |
32 | Shows the maximum number of
index keys.
max_locks_per_transaction |
64 | Sets the maximum number of
locks per transaction.
max_logical_replication_workers |
4 | Maximum number of logical
replication worker processes.
max_parallel_maintenance_workers |
2 | Sets the maximum number of
parallel processes per maintenance operation.
max_parallel_workers |
8 | Sets the maximum number of
parallel workers that can be active at one time.
max_parallel_workers_per_gather |
2 | Sets the maximum number of
parallel processes per executor node.
max_pred_locks_per_page |
2 | Sets the maximum number of
predicate-locked tuples per page.
max_pred_locks_per_relation |
-2 | Sets the maximum number of
predicate-locked pages and tuples per relation.
max_pred_locks_per_transaction |
64 | Sets the maximum number of
predicate locks per transaction.
max_prepared_transactions |
0 | Sets the maximum number of
simultaneously prepared transactions.
max_replication_slots |
10 | Sets the maximum number of
simultaneously defined replication slots.
max_slot_wal_keep_size |
-1 | Sets the maximum WAL size that
can be reserved by replication slots.
max_stack_depth |
2MB | Sets the maximum stack depth,
in kilobytes.
max_standby_archive_delay |
30s | Sets the maximum delay before
canceling queries when a hot standby server is processing archived WAL data.
max_standby_streaming_delay |
30s | Sets the maximum delay before
canceling queries when a hot standby server is processing streamed WAL data.
max_sync_workers_per_subscription |
2 | Maximum number of table
synchronization workers per subscription.
max_wal_senders |
10 | Sets the maximum number of
simultaneously running WAL sender processes.
max_wal_size |
1GB | Sets the WAL size that
triggers a checkpoint.
max_worker_processes |
8 | Maximum number of concurrent
worker processes.
min_dynamic_shared_memory |
0 | Amount of dynamic shared
memory reserved at startup.
min_parallel_index_scan_size |
512kB | Sets the minimum amount of
index data for a parallel scan.
min_parallel_table_scan_size |
8MB | Sets the minimum amount of
table data for a parallel scan.
min_wal_size |
80MB | Sets the minimum size to
shrink the WAL to.
old_snapshot_threshold |
-1 | Time before a snapshot is too
old to read pages changed after the snapshot was taken.
parallel_leader_participation |
on | Controls whether Gather and
Gather Merge also run subplans.
parallel_setup_cost |
1000 | Sets the planner's estimate of
the cost of starting up worker processes for parallel query.
parallel_tuple_cost |
0.1 | Sets the planner's estimate of
the cost of passing each tuple (row) from worker to leader backend.
parallel_tuple_cost |
0.1 | Sets the planner's estimate of
the cost of passing each tuple (row) from worker to leader backend.
password_encryption |
scram-sha-256 | Chooses the algorithm for
encrypting passwords.
plan_cache_mode |
auto | Controls the planner's
selection of custom or generic plan.
port |
5434 | Sets the TCP port the server
listens on.
post_auth_delay |
0 | Waits N seconds on connection
startup after authentication.
pre_auth_delay |
0 | Waits N seconds on connection
startup before authentication.
primary_conninfo | | Sets the
connection string to be used to connect to the sending server.
primary_slot_name | | Sets the
name of the replication slot to use on the sending server.
promote_trigger_file | |
Specifies a file name whose presence ends recovery in the standby.
quote_all_identifiers |
off | When generating SQL fragments,
quote all identifiers.
random_page_cost |
4 | Sets the planner's estimate of
the cost of a nonsequentially fetched disk page.
recovery_end_command | | Sets
the shell command that will be executed once at the end of recovery.
recovery_init_sync_method |
fsync | Sets the method for
synchronizing the data directory before crash recovery.
recovery_min_apply_delay |
0 | Sets the minimum delay for
applying changes during recovery.
recovery_target | | Set to
"immediate" to end recovery as soon as a consistent state is reached.
recovery_target_action |
pause | Sets the action to perform
upon reaching the recovery target.
recovery_target_inclusive |
on | Sets whether to include or
exclude transaction with recovery target.
recovery_target_lsn | | Sets
the LSN of the write-ahead log location up to which recovery will proceed.
recovery_target_name | | Sets
the named restore point up to which recovery will proceed.
recovery_target_time | | Sets
the time stamp up to which recovery will proceed.
recovery_target_timeline |
latest | Specifies the timeline to
recover into.
recovery_target_xid | | Sets
the transaction ID up to which recovery will proceed.
remove_temp_files_after_crash |
on | Remove temporary files after
backend crash.
restart_after_crash |
on | Reinitialize server after
backend crash.
restore_command | | Sets the
shell command that will be called to retrieve an archived WAL file.
row_security |
on | Enable row security.
search_path | "$user",
public | Sets the schema search order for names
that are not schema-qualified.
segment_size |
1GB | Shows the number of pages per
disk file.
seq_page_cost |
1 | Sets the planner's estimate of
the cost of a sequentially fetched disk page.
server_encoding |
UTF8 | Shows the server (database)
character set encoding.
server_version | 14.5 (Ubuntu
14.5-0ubuntu0.22.04.1) | Shows the server version.
server_version_num |
140005 | Shows the server version as an
integer.
session_preload_libraries | |
Lists shared libraries to preload into each backend.
session_replication_role |
origin | Sets the session's behavior
for triggers and rewrite rules.
shared_buffers |
128MB | Sets the number of shared
memory buffers used by the server.
shared_memory_type |
mmap | Selects the shared memory
implementation used for the main shared memory region.
shared_preload_libraries | |
Lists shared libraries to preload into server.
ssl |
on | Enables SSL connections.
ssl_ca_file | | Location of
the SSL certificate authority file.
ssl_cert_file |
/etc/ssl/certs/ssl-cert-snakeoil.pem | Location of the SSL server
certificate file.
ssl_ciphers |
HIGH:MEDIUM:+3DES:!aNULL | Sets the list of allowed SSL
ciphers.
ssl_crl_dir | | Location of
the SSL certificate revocation list directory.
ssl_crl_file | | Location of
the SSL certificate revocation list file.
ssl_dh_params_file | |
Location of the SSL DH parameters file.
ssl_ecdh_curve |
prime256v1 | Sets the curve to use for ECDH.
ssl_key_file |
/etc/ssl/private/ssl-cert-snakeoil.key | Location of the SSL server
private key file.
ssl_library |
OpenSSL | Shows the name of the SSL library.
ssl_max_protocol_version | |
Sets the maximum SSL/TLS protocol version to use.
ssl_min_protocol_version |
TLSv1.2 | Sets the minimum SSL/TLS
protocol version to use.
ssl_passphrase_command | |
Command to obtain passphrases for SSL.
ssl_passphrase_command_supports_reload |
off | Also use
ssl_passphrase_command during server reload.
ssl_prefer_server_ciphers |
on | Give priority to server
ciphersuite order.
standard_conforming_strings |
on | Causes '...' strings to treat
backslashes literally.
statement_timeout |
0 | Sets the maximum allowed
duration of any statement.
stats_temp_directory |
/var/run/postgresql/14-main.pg_stat_tmp | Writes temporary statistics
files to the specified directory.
superuser_reserved_connections |
3 | Sets the number of connection
slots reserved for superusers.
synchronize_seqscans |
on | Enable synchronized sequential
scans.
synchronous_commit |
on | Sets the current transaction's
synchronization level.
synchronous_standby_names | |
Number of synchronous standbys and list of names of potential
synchronous ones.
syslog_facility |
local0 | Sets the syslog "facility" to
be used when syslog enabled.
syslog_ident |
postgres | Sets the program name used to
identify PostgreSQL messages in syslog.
syslog_sequence_numbers |
on | Add sequence number to syslog
messages to avoid duplicate suppression.
syslog_split_messages |
on | Split messages sent to syslog
by lines and to fit into 1024 bytes.
tcp_keepalives_count |
0 | Maximum number of TCP
keepalive retransmits.
tcp_keepalives_idle |
0 | Time between issuing TCP
keepalives.
tcp_keepalives_interval |
0 | Time between TCP keepalive
retransmits.
tcp_user_timeout |
0 | TCP user timeout.
temp_buffers |
8MB | Sets the maximum number of
temporary buffers used by each session.
temp_file_limit |
-1 | Limits the total size of all
temporary files used by each process.
temp_tablespaces | | Sets the
tablespace(s) to use for temporary tables and sort files.
TimeZone |
Europe/Brussels | Sets the time zone for
displaying and interpreting time stamps.
timezone_abbreviations |
Default | Selects a file of time zone
abbreviations.
trace_notify |
off | Generates debugging output for
LISTEN and NOTIFY.
trace_recovery_messages |
log | Enables logging of
recovery-related debugging information.
trace_sort |
off | Emit information about
resource usage in sorting.
track_activities |
on | Collects information about
executing commands.
track_activity_query_size |
1kB | Sets the size reserved for
pg_stat_activity.query, in bytes.
track_commit_timestamp |
off | Collects transaction commit time.
track_counts |
on | Collects statistics on
database activity.
track_functions |
none | Collects function-level
statistics on database activity.
track_io_timing |
off | Collects timing statistics for
database I/O activity.
track_wal_io_timing |
off | Collects timing statistics for
WAL I/O activity.
transaction_deferrable |
off | Whether to defer a read-only
serializable transaction until it can be executed with no possible
serialization failures.
transaction_isolation | read
committed | Sets the current transaction's
isolation level.
transaction_read_only |
off | Sets the current transaction's
read-only status.
transform_null_equals |
off | Treats "expr=NULL" as "expr IS
NULL".
unix_socket_directories |
/var/run/postgresql | Sets the directories where
Unix-domain sockets will be created.
unix_socket_group | | Sets the
owning group of the Unix-domain socket.
unix_socket_permissions |
0777 | Sets the access permissions of
the Unix-domain socket.
update_process_title |
on | Updates the process title to
show the active SQL command.
vacuum_cost_delay |
0 | Vacuum cost delay in milliseconds.
vacuum_cost_limit |
200 | Vacuum cost amount available
before napping.
vacuum_cost_page_dirty |
20 | Vacuum cost for a page dirtied
by vacuum.
vacuum_cost_page_hit |
1 | Vacuum cost for a page found
in the buffer cache.
vacuum_cost_page_miss |
2 | Vacuum cost for a page not
found in the buffer cache.
vacuum_defer_cleanup_age |
0 | Number of transactions by
which VACUUM and HOT cleanup should be deferred, if any.
vacuum_failsafe_age |
1600000000 | Age at which VACUUM should
trigger failsafe to avoid a wraparound outage.
vacuum_freeze_min_age |
50000000 | Minimum age at which VACUUM
should freeze a table row.
vacuum_freeze_table_age |
150000000 | Age at which VACUUM should
scan whole table to freeze tuples.
vacuum_multixact_failsafe_age |
1600000000 | Multixact age at which VACUUM
should trigger failsafe to avoid a wraparound outage.
vacuum_multixact_freeze_min_age |
5000000 | Minimum age at which VACUUM
should freeze a MultiXactId in a table row.
vacuum_multixact_freeze_table_age |
150000000 | Multixact age at which VACUUM
should scan whole table to freeze tuples.
wal_block_size |
8192 | Shows the block size in the
write ahead log.
wal_buffers |
4MB | Sets the number of disk-page
buffers in shared memory for WAL.
wal_compression |
off | Compresses full-page writes
written in WAL file.
wal_consistency_checking | |
Sets the WAL resource managers for which WAL consistency checks are done.
wal_init_zero |
on | Writes zeroes to new WAL files
before first use.
wal_keep_size |
0 | Sets the size of WAL files
held for standby servers.
wal_level |
replica | Sets the level of information
written to the WAL.
wal_log_hints |
off | Writes full pages to WAL when
first modified after a checkpoint, even for a non-critical modification.
wal_receiver_create_temp_slot |
off | Sets whether a WAL receiver
should create a temporary replication slot if no permanent slot is
configured.
wal_receiver_status_interval |
10s | Sets the maximum interval
between WAL receiver status reports to the sending server.
wal_receiver_timeout |
1min | Sets the maximum wait time to
receive data from the sending server.
wal_recycle |
on | Recycles WAL files by renaming
them.
wal_retrieve_retry_interval |
5s | Sets the time to wait before
retrying to retrieve WAL after a failed attempt.
wal_segment_size |
16MB | Shows the size of write ahead
log segments.
wal_sender_timeout |
1min | Sets the maximum time to wait
for WAL replication.
wal_skip_threshold |
2MB | Minimum size of new file to
fsync instead of writing WAL.
wal_sync_method |
fdatasync | Selects the method used for
forcing WAL updates to disk.
wal_writer_delay |
200ms | Time between WAL flushes
performed in the WAL writer.
wal_writer_flush_after |
1MB | Amount of WAL written out by
WAL writer that triggers a flush.
work_mem |
4MB | Sets the maximum memory to be
used for query workspaces.
xmlbinary |
base64 | Sets how binary values are to
be encoded in XML.
xmloption |
content | Sets whether XML data in
implicit parsing and serialization operations is to be considered as
documents or content fragments.
zero_damaged_pages |
off | Continues processing past
damaged page headers.
Dany De Bontridder via noalyss-generale:
Eh ben voilà , on avance :-)
Maintenant , vérifier que la base de données peut se connecter.
En tant que postgresql, fais
1. ton utilisateur SQL pour te connecter existe ?
psql template1 -c "select * from pg_user";
2. Sur quel port tourne ta base de données et quelle est sa config
psql template1 -c "show all"
3. As-tu réglé la sécurité ?
psql template1 -c -c " select * from pg_hba_file_rules"
Voir aussi ici
https://wiki.noalyss.eu/doku.php?id=faq:erreur_de_connection
Bonne soirée
D
- [noalyss-generale] Problème PHP suite mise à niveau Ubuntu, ydc, 2023/01/05
- Re: [noalyss-generale] Problème PHP suite mise à niveau Ubuntu, Dany De Bontridder, 2023/01/07
- Re: [noalyss-generale] Problème PHP suite mise à niveau Ubuntu, ydc, 2023/01/08
- Re: [noalyss-generale] Problème PHP suite mise à niveau Ubuntu, Dany De Bontridder, 2023/01/08
- Re: [noalyss-generale] Problème PHP suite mise à niveau Ubuntu, ydc, 2023/01/08
- Message not available
- Message not available
- Re: [noalyss-generale] Problème PHP suite mise à niveau Ubuntu, Dany De Bontridder, 2023/01/09
- Re: [noalyss-generale] Problème PHP suite mise à niveau Ubuntu,
ydc <=
- Re: [noalyss-generale] Problème PHP suite mise à niveau Ubuntu, Pierre-François Philippe, 2023/01/26
- Re: [noalyss-generale] Problème PHP suite mise à niveau Ubuntu, Dany De Bontridder, 2023/01/26
- Re: [noalyss-generale] Problème PHP suite mise à niveau Ubuntu, Pierre-François Philippe, 2023/01/26
- Re: [noalyss-generale] Problème PHP suite mise à niveau Ubuntu, Pierre-François Philippe, 2023/01/28
- Re: [noalyss-generale] Problème PHP suite mise à niveau Ubuntu, Dany De Bontridder, 2023/01/28
- Re: [noalyss-generale] Problème PHP suite mise à niveau Ubuntu, Pierre-François Philippe, 2023/01/28
- Re: [noalyss-generale] Problème PHP suite mise à niveau Ubuntu, Dany De Bontridder, 2023/01/29
- Re: [noalyss-generale] Problème PHP suite mise à niveau Ubuntu, Pierre-François Philippe, 2023/01/29
- Re: [noalyss-generale] Problème PHP suite mise à niveau Ubuntu, Pierre-François Philippe, 2023/01/25