From: | "Richard Harris" <Richard_Harris(at)adp(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Pg_dump does not include database search path in backup file |
Date: | 2004-08-13 17:02:05 |
Message-ID: | D6EE939FB590D84CB70371C2CB8CA34C1AE7B9@nexus.plaza.ds.adp.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
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;
I used pg_dump to backup to database.
pg_dump -U adp_dba -C -F p -f /adp/db/backup/at_db_p_text.bak adp_te
st_db
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. I found an item in
the mailing lists regarding a 'bug in pg_dump Alter Database' on Tue 29
2004. However, it appears to me that this is about a bug found in
testing the next release, not a bug in a current release. I do not see
any 'alter database' statements setting the search path in the backup
file from pg_dump. Should PostgreSQL 7.4.2 pg_dump include an 'Alter
Database' for the search path? If so, what pg_dump option does this?
Thank you for your help.
Thanks,
Rich Harris
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2004-08-13 17:36:20 | Re: TOAST tables keeps growing! |
Previous Message | Enrique Arizón | 2004-08-13 16:40:50 | Pseudo-Off-topic-survey: Opinions about future of Postgresql(MySQL)? |