--- On Fri, 30/4/10, Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> wrote: > > Uh. Why are you doing that? pg_restore is > supposed to restore the > schema, then data, finally indexes and other stuff. > Are you using > separate schema/data dumps? If so, don't do that -- > it's known to be > slower. Yes, I'm restoring the schema first, then the data. The reason being that the data can come from different slony 1.2 slaves, but the schema always comes from the origin server due to modifications slony makes to schemas on the slaves. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general