Thread: possible bug : pg_dump does not include ALTER DATABASE SET search_path

possible bug :

pg_dump does not include ALTER DATABASE ... SET search_path TO ...

pg_dumpall does include it.

pg_dump only includes the runtime "SET search_path", but not the permanent ALTER DATABASE part

is this intentional?

Miles Keaton <mileskeaton@gmail.com> writes:
> pg_dump does not include ALTER DATABASE ... SET search_path TO ...
> pg_dumpall does include it.

This is per design; it holds for all ALTER DATABASE properties not
just search_path.

            regards, tom lane