Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group