Re: pg_restore -n sch1 : schema "sch1" does not exist - Mailing list pgsql-general

From lin
Subject Re: pg_restore -n sch1 : schema "sch1" does not exist
Date
Msg-id 28e393c6.11760.14a3158d97e.Coremail.jluwln@163.com
Whole thread Raw
In response to Re: pg_restore -n sch1 : schema "sch1" does not exist  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general


Are you sure it is a bug and you have fixed it? I test it with postgresql-9.4rcl, the result is the same with postgresql-9.3 beta2.




At 2014-12-09 23:54:01, "Tom Lane" <tgl@sss.pgh.pa.us> wrote: >lin <jluwln@163.com> 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@postgresql.org) >To make changes to your subscription: >http://www.postgresql.org/mailpref/pgsql-general


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Speeding up an in-progress wraparound-preventing vacuum
Next
From: Adrian Klaver
Date:
Subject: Re: pg_restore -n sch1 : schema "sch1" does not exist