how to sync the system table with pg_dump

From: Gary Fu <gfu(at)saicmodis(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: how to sync the system table with pg_dump
Date: 2008-06-04 15:34:10
Message-ID: g26cli$22sb$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I tried to use pg_dump to restore (sync) a database, but I noticed that
the system table pg_namespace was not synced.

I tried the following pg_dump command to just restore that table without
success either.

Does pg_dump support for the system tables or something I missed ?
Is there another way to sync the system tables ?

Thanks,
Gary

% pg_dump -t pg_namespace -h nppdist nppsd3 | psql -h nppsds1 -d nppsd3
SET
SET
SET
SET
SET
SET
SET
SET
ERROR: relation "pg_namespace" already exists
ALTER TABLE
ERROR: duplicate key violates unique constraint
"pg_namespace_nspname_index"
CONTEXT: COPY pg_namespace, line 1: "pg_toast 10 \N"
ERROR: permission denied: "pg_namespace" is a system catalog
ERROR: permission denied: "pg_namespace" is a system catalog
REVOKE
REVOKE
GRANT

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kynn Jones 2008-06-04 16:19:40 pg_restore frozen?
Previous Message Gurjeet Singh 2008-06-04 15:00:58 Re: does postgresql works on distributed systems?