Re: Pg_dump does not include database search path in backup file

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Richard Harris" <Richard_Harris(at)adp(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Pg_dump does not include database search path in backup file
Date: 2004-08-13 20:24:54
Message-ID: 26687.1092428694@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Richard Harris" <Richard_Harris(at)adp(dot)com> writes:
> I'm using PostgreSQL 7.4.2. I have a database with several user defined
> schemas, e.g., public, shr, sys, acc, prt. I have altered the database
> search path to include all of the schema.

> ALTER DATABASE adp_test_db SET search_path to public, shr, sys, acc,
> prt, svc, fi;

> Then I used psql to restore the database from the backup file. However,
> psql restored the search path to the default (e.g., $user, public)
> rather than the search path with all the schemas.

pg_dump only dumps the contents of the database. Settings associated
with ALTER DATABASE or ALTER USER are considered to be the province
of pg_dumpall.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Simon@2ndquadrant.com 2004-08-14 00:50:22 Re: [HACKERS] Point in Time Recovery
Previous Message Tom Lane 2004-08-13 19:05:18 Re: dynamic DB descriptions