[ADMIN] pg_dump and schemas

pgSql 7.4.0 Hi, If a *schema* is dumped and then restored on a different server, will it be necessary to also restore system schemas, e.g. pg_catalog? Thanks __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/

Re: [ADMIN] pg_dump and schemas

ow writes: If a *schema* is dumped and then restored on a different server, will it be necessary to also restore system schemas, e.g. pg_catalog? No. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all

[ADMIN] pg_dump and schemas

pgSql 7.4.0 Hi, Suppose, there are two (2) schemas in the database: schemaA and schemaB. schemaA is relatively small and updated all the time, schemaB is huge and updated occasionally, maybe several times a day. The whole database, with schemaA and schemaB, is dumped once a week, say Sunday, and