dump + restore didn't include schemas
| От | Dan Langille |
|---|---|
| Тема | dump + restore didn't include schemas |
| Дата | |
| Msg-id | 401AC85F.29157.17799FCB@localhost обсуждение исходный текст |
| Ответы |
Re: dump + restore didn't include schemas
|
| Список | pgsql-hackers |
Hi folks, I upgraded two servers today from 7.3.* to 7.4.1. In both cases, the schemas which existed in the original databases were not created in the new database. The CREATE SCHEMA commands are there... \connect "freebsddiary.org" -- -- PostgreSQL database dump -- SET SESSION AUTHORIZATION 'www'; -- -- TOC entry 2 (OID 3642999) -- Name: www; Type: SCHEMA; Schema: -; Owner: www -- CREATE SCHEMA www; But not in the resulting database: freebsddiary.org=# set search_path = www, phorum, public, pg_catalog; ERROR: schema "www" does not exist freebsddiary.org=# set search_path = phorum, public, pg_catalog; ERROR: schema "phorum" does not exist freebsddiary.org=# New issue? Known bug? -- Dan Langille : http://www.langille.org/ BSDCan - http://www.bsdcan.org/
В списке pgsql-hackers по дате отправления: