lin <jluwln@xxxxxxx> writes: > I create a schema (sch1) in the database of db1, and I also create a table sch1.t1, then I use the comand "pg_dump -d db1 -Fd -f dir1" to back up the database of db1; at lase I drop the schema of sch1; I want to restore the schema sch1, but when I execute the command "pg_restore -d db1 -Fd dir1 -n sch1", get error, just like below. > I just want to test the parameter of "-n" for pg_restore, how can do to use the pg_restore correctly? Well, you could adopt an actually supported release: > ; Dumped from database version: 9.3beta2 > ; Dumped by pg_dump version: 9.3beta2 I'm not just being snarky: the messages you're getting here remind me of a bug we fixed some time ago. But even aside from this specific complaint, the list of known data-loss bugs in 9.3beta should terrify you. Why in the world are you still using it? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general