Re: pg_restore should restore the schema comments and the database properties

On Tuesday, December 20, 2011 7:02:13 am Alban Hertroys wrote:
> On 20 December 2011 15:35, Adrian Klaver <adrian.klaver@gmail.com> wrote:
> > To elaborate on my previous answer, search_path is in postgresql.conf
> > because it is tied to the database cluster not a particular database.
>
> Not necessarily, it can also be tied to a schema or a role or (I
> assume) a specific database in the cluster.
>
> ALTER ROLE x SET search_path TO ...
> ALTER SCHEMA x SET search_path TO ...

My mistake, I forgot about that.
For a database:
ALTER DATABASE name SET configuration_parameter { TO | = } { value | DEFAULT }

>
> I don't have a PG instance available here, so I can't verify whether
> those get dumped/restored. I assume they do though.

--
Adrian Klaver
adrian.klaver@gmail.com