On 12/01/2016 03:16 AM, Juliano wrote:
Hi everyone, I tried to restore pg_catalog to my new database, but the existing pg_catalog can't be overwritten or dropped, and postgres auto creates pg_catalog when I create a new DB. So, there is a way to restore the pg_catalog to a new database?
Why would you do that? You should be restoring from a proper backup which will already have everything it needs to populate the new pg_catalog correctly.
JD
Regards, Juliano
-- Command Prompt, Inc. http://the.postgres.company/ +1-503-667-4564 PostgreSQL Centered full stack support, consulting and development. Everyone appreciates your honesty, until you are honest with them. Unless otherwise stated, opinions are my own. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general