</sect3>

<sect3 id="collation-nondeterministic">

<title>Nondeterminstic Collations</title>

<title>Nondeterministic Collations</title>

<para>

A collation is either <firstterm>deterministic</firstterm> or

a <productname>PostgreSQL</productname> data directory contains a file

<filename>postgresql.auto.conf</filename><indexterm><primary>postgresql.auto.conf</primary></indexterm>,

which has the same format as <filename>postgresql.conf</filename> but

is intended to be edited automatically not manually. This file holds

is intended to be edited automatically, not manually. This file holds

settings provided through the <xref linkend="sql-altersystem"/> command.

This file is read whenever <filename>postgresql.conf</filename> is,

and its settings take effect in the same way. Settings

(<parameter>slot_name</parameter> <type>name</type>, <parameter>lsn</parameter> <type>pg_lsn</type>)

</entry>

<entry>

Copies an existing physical replication slotname <parameter>src_slot_name</parameter>

Copies an existing physical replication slotnamed <parameter>src_slot_name</parameter>

to a physical replication slot named <parameter>dst_slot_name</parameter>.

The copied physical slot starts to reserve WAL from the same <acronym>LSN</acronym> as the

source slot.

<para>

<function>pg_ls_archive_statusdir</function> returns the name, size, and

last modified time (mtime) of each file in the WAL archive status

directory <literal>pg_wal/archive_status</literal>. By default only

directory <filename>pg_wal/archive_status</filename>. By default only

superusers and members of the <literal>pg_monitor</literal> role can

use this function. Access may be granted to others using

<command>GRANT</command>.