Talk:PostgreSQL - Revision history

Technius: /* Best place to discuss backups */ new section

2026-02-01T20:30:47Z

Best place to discuss backups: new section

← Older revision		Revision as of 20:30, 1 February 2026
Line 17:		Line 17:

	if you just do the part that accepts TCP connections WITHOUT the local, it just doesn't run because it is missing it.		if you just do the part that accepts TCP connections WITHOUT the local, it just doesn't run because it is missing it.

			== Best place to discuss backups ==

			Is this page an appropriate place to mention using a program like <nowiki><code>pgbackrest</code></nowiki> to perform backups, or would a separate page be better? [[User:Technius\|Technius]] ([[User talk:Technius\|talk]]) 20:30, 1 February 2026 (UTC)

imported>Maikelthedev: reformatted the parts that were nix code

2024-01-22T18:32:56Z

reformatted the parts that were nix code

← Older revision		Revision as of 18:32, 22 January 2024
Line 1:		Line 1:
	The instructions are incomplete and lead to a systm that never runs because is missing the local part. This is what worked for me.		The instructions are incomplete and lead to a systm that never runs because is missing the local part. This is what worked for me.

			<pre>
	services.postgresql = {		services.postgresql = {
	settings = {		settings = {
Line 13:		Line 14:
	'';		'';
	};		};
			</pre>

	if you just do the part that accepts TCP connections WITHOUT the local, it just doesn't run because it is missing it.		if you just do the part that accepts TCP connections WITHOUT the local, it just doesn't run because it is missing it.

imported>Maikelthedev: TCP/IP version misses the local auth and can't run

2024-01-22T18:04:35Z

TCP/IP version misses the local auth and can't run

New page

The instructions are incomplete and lead to a systm that never runs because is missing the local part. This is what worked for me.

services.postgresql = {
settings = {
listen_addresses = "*";
};
enable = true;
enableTCPIP = true;
authentication = pkgs.lib.mkOverride 10 ''
local all all trust
host all all ::1/128 trust
host all postgres 127.0.0.1/32 trust
'';
};

if you just do the part that accepts TCP connections WITHOUT the local, it just doesn't run because it is missing it.