On Tue, 17 Sep 2002, Wim wrote:
> Anyone knows how to copy a table to another database?
Use the the COPY command:
Name
COPY -- copy data between files and tables
Synopsis
COPY [ BINARY ] table [ WITH OIDS ]
FROM { 'filename' | stdin }
[ [USING] DELIMITERS 'delimiter' ]
[ WITH NULL AS 'null string' ]
COPY [ BINARY ] table [ WITH OIDS ]
TO { 'filename' | stdout }
[ [USING] DELIMITERS 'delimiter' ]
[ WITH NULL AS 'null string' ]
Or, bearing in mind your problem,
pg_dump -t <tablename> ...
For your real problem, it sounds like it's the system tables causing you
problems. You say you tried REINDEX, that was REINDEX DATABASE <dbname> FORCE
presumably.
It is somewhat worrying that the same problem has reoccured. You checked your
hard disk but what about memory?
pg_dumpall fails but what about just pg_dump on the individual DBs?
Is it a production system? If it continues to cause problems what about
considering bringing someone in to investigate?
--
Nigel J. Andrews
Director
---
Logictree Systems Limited
Computer Consultants