The following bug has been logged online:
Bug reference: 5684
Logged by: Nathan Gorter
Email address: nathan@vanbelle.com
PostgreSQL version: 8.3.11
Operating system: i686-redhat-linux-gnu
Description: pg_restore does not restore schemas
Details:
I am attempting to perform a dump from one database, create a new database,
and restore the data to that new database. In my old database I have schemas
besides the public schema that I have created myself. The pg_dump works fine
and the pg_restore does not generate any errors, but the pg_restore fails to
create the extra schemas, and instead restores the tables in those other
schemas into the public schema. I have included my pg_dump and pg_restore
commands below. I have tried the pg_restore command with and without the -c
switch, and I have tried calling pg_restore twice, the first time using the
-s switch and the second time using the -a switch. None of these have
worked. On a note, when I manually create the extra schemas myself before
performing the restore, it all works correctly.
pg_dump command: [C:\Workspaces\Nathan\Database Backup Tool\pg_dump.exe,
-fC:\Workspaces\Nathan\Database Backup Tool\plantango_v1.backup, -Fc, -o,
-tball.ball_goals, -tball.ball_plant_po, -tball.ball_plants,
-tball.ball_po_update_reasons, -tpublic.ar_so, -tpublic.ar_so_line,
-tpublic.common_country, -tpublic.common_province, -tpublic.gl_department,
-tpublic.in_crop, -tpublic.in_crop_adjustment, -tpublic.in_crop_history,
-tpublic.in_dump_reason, -tpublic.in_item, -tpublic.in_location,
-tpublic.in_pool, -tpublic.in_product, -tpublic.in_site, -tpublic.in_size,
-tpublic.label_series, -tpublic.pack_order, -tpublic.pack_record,
-tpublic.pack_shipping_container, -tpublic.p_group, -tpublic.p_group_member,
-tpublic.pick_record, -tpublic.prd_crop_schedule, -tpublic.prd_crop_step,
-tpublic.prd_customer_goal, -tpublic.prd_customer_item_goal,
-tpublic.prd_goal, -tpublic.prd_method, -tpublic.prd_period,
-tpublic.prd_sales_goal, -tpublic.prd_schedule, -tpublic.rs_carrier,
-tpublic.rs_load, -tpublic.rs_schedule, -tpublic.sa_context,
-tpublic.sa_customer, -tpublic.sa_period, -tpublic.sa_v_item,
-tpublic.sa_v_item_reservation, -v, -i, -Z9, -h10.10.10.200, -p5432,
-Unathan, plantango_v1]
pg_restore command: [C:\Workspaces\Nathan\Database Backup
Tool\pg_restore.exe, -c, -dplantango_v1 (Restored on 2010-9-29 11-18-22),
-i, -v, -hchaucer, -p5432, -Unathan, C:\Workspaces\Nathan\Database Backup
Tool\plantango_v1.backup]