The following bug has been logged online: Bug reference: 5684 Logged by: Nathan Gorter Email address: nat...@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] -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs