Notas Posgre SQL
Validar errores en el archivo de configuracion
Con errores
postgres=# select sourcefile, name, sourceline, error from pg_file_settings where error is not null;
sourcefile | name | sourceline | error
-----------------------------------------+-----------------+------------+------------------------------
/etc/postgresql/14/main/postgresql.conf | max_connections | 66 | setting could not be applied
(1 row)
Sin errores
postgres=# select sourcefile, name, sourceline, error from pg_file_settings where error is not null;
sourcefile | name | sourceline | error
------------+------+------------+-------
(0 rows)
Comentarios
Publicar un comentario