Manually Configure PostgreSQL - Revision history

Sam at 17:47, 25 February 2025

2025-02-25T17:47:30Z

2024-01-31T10:17:26Z

2023-05-03T09:43:48Z

Sample Parameters

2023-05-03T09:30:43Z

2022-05-12T20:18:34Z

pg_hba.conf

2021-08-23T20:41:03Z

2021-08-23T20:40:19Z

2021-05-05T20:34:59Z

pg_hba.conf

2021-05-05T20:26:57Z

pg_hba.conf

2020-10-05T17:57:24Z

← Older revision		Revision as of 17:47, 25 February 2025
Line 1:		Line 1:
−	Truxton will work with PostgreSQL version 9.6 through 16.	+	Truxton will work with PostgreSQL version 9.6 through 17.
	If you install PostgreSQL on your own, the following changes will allow connection from anywhere.		If you install PostgreSQL on your own, the following changes will allow connection from anywhere.

← Older revision		Revision as of 10:17, 31 January 2024
Line 1:		Line 1:
−	Truxton will work with PostgreSQL version 9.6 through 15.	+	Truxton will work with PostgreSQL version 9.6 through 16.
	If you install PostgreSQL on your own, the following changes will allow connection from anywhere.		If you install PostgreSQL on your own, the following changes will allow connection from anywhere.

@@ Line 30: / Line 30: @@
 ALTER SYSTEM SET default_statistics_target = '500';
 ALTER SYSTEM SET random_page_cost = '1.1';
-ALTER SYSTEM SET work_mem = '1390kB';
+ALTER SYSTEM SET work_mem = '6258kB';
 ALTER SYSTEM SET min_wal_size = '4GB';
 ALTER SYSTEM SET max_wal_size = '16GB';
@@ Line 36: / Line 36: @@
 ALTER SYSTEM SET max_parallel_workers_per_gather = '18';
 ALTER SYSTEM SET max_parallel_workers = '36';
 ALTER SYSTEM SET max_parallel_maintenance_workers = '4';
 </source>

@@ Line 1: / Line 1: @@
-Truxton will work with PostgreSQL version 9.6 through 12.
+Truxton will work with PostgreSQL version 9.6 through 15.
 If you install PostgreSQL on your own, the following changes will allow connection from anywhere.
@@ Line 6: / Line 6: @@
 <pre>
-host all all 0.0.0.0/0 md5
+host all all 0.0.0.0/0 scram-sha-256
-host all all ::0/0 md5
+host all all ::0/0 scram-sha-256
 </pre>

@@ Line 9: / Line 9: @@
 host all all ::0/0 md5
 </pre>
 =Tunable Parameters=

@@ Line 14: / Line 14: @@
 ==Sample Parameters==
-The following are the settings used for a server with 36 CPUs (72 virtual), 191GB RAM and data drive is an SSD.
+The following are the settings used for a server with 36 CPUs (72 virtual), 191GB RAM and data drive is an [https://en.wikipedia.org/wiki/Solid-state_drive SSD.]
 <source lang="sql">
 ALTER SYSTEM SET max_connections = '1000';

← Older revision		Revision as of 20:40, 23 August 2021
Line 12:		Line 12:
	=Tunable Parameters=		=Tunable Parameters=
	We recommend [https://pgtune.leopard.in.ua/#/ PGTune] for getting tuning parameters.		We recommend [https://pgtune.leopard.in.ua/#/ PGTune] for getting tuning parameters.
		+
		+	==Sample Parameters==
		+	The following are the settings used for a server with 36 CPUs (72 virtual), 191GB RAM and data drive is an SSD.
		+	<source lang="sql">
		+	ALTER SYSTEM SET max_connections = '1000';
		+	ALTER SYSTEM SET shared_buffers = '48896MB';
		+	ALTER SYSTEM SET effective_cache_size = '146688MB';
		+	ALTER SYSTEM SET maintenance_work_mem = '2047MB';
		+	ALTER SYSTEM SET checkpoint_completion_target = '0.9';
		+	ALTER SYSTEM SET wal_buffers = '16MB';
		+	ALTER SYSTEM SET default_statistics_target = '500';
		+	ALTER SYSTEM SET random_page_cost = '1.1';
		+	ALTER SYSTEM SET work_mem = '1390kB';
		+	ALTER SYSTEM SET min_wal_size = '4GB';
		+	ALTER SYSTEM SET max_wal_size = '16GB';
		+	ALTER SYSTEM SET max_worker_processes = '36';
		+	ALTER SYSTEM SET max_parallel_workers_per_gather = '18';
		+	ALTER SYSTEM SET max_parallel_workers = '36';
		+	ALTER SYSTEM SET max_parallel_maintenance_workers = '4';
		+	</source>

@@ Line 5: / Line 5: @@
 Edit the <code>pg_hba.conf</code> file to tell it to allow connections from anywhere.
-<syntaxhighlight lang="txt>
+<sourcelang="txt">
 host all all 0.0.0.0/0 md5
 host all all ::0/0 md5
-</syntaxhighlight>
+</source>
 =Tunable Parameters=
 We recommend [https://pgtune.leopard.in.ua/#/ PGTune] for getting tuning parameters.

← Older revision		Revision as of 17:57, 5 October 2020
Line 9:		Line 9:
	host all all ::0/0 md5		host all all ::0/0 md5
	</syntaxhighlight>		</syntaxhighlight>
		+
		+	=Tunable Parameters=
		+	We recommend [https://pgtune.leopard.in.ua/#/ PGTune] for getting tuning parameters.