Thread:

From
Warren Little
Date:
Hello,
I'm trying to make a copy of a database using the following syntax:
pg_dump -v -Fc -b cert | pg_restore -v -d prodcopy

The output looks good until it the following:
pg_dump: socket not open
pg_dump: SQL command to dump the contents of table "casedocument"
failed: PQendcopy() failed.
pg_dump: Error message from server: socket not open
pg_dump: The command was: COPY public.casedocument (pid, content,
createdt, descr, docformat, version, casepid, createuserpid, typepid,
sent, active) TO stdout;
pg_dump: *** aborted because of error
pg_restore: [custom archiver] could not read data block -- expected 1,
got 0
pg_restore: *** aborted because of error

casedocument schema looks like:

CREATE TABLE casedocument
(
  pid varchar(12) NOT NULL,
  content bytea NOT NULL,
  createdt timestamp NOT NULL,
  descr varchar(40),
  docformat varchar(10) NOT NULL,
  version int4 NOT NULL,
  casepid varchar(12) NOT NULL,
  createuserpid varchar(12) NOT NULL,
  typepid varchar(12) NOT NULL,
  sent bool DEFAULT false,
  active bool DEFAULT true,
  CONSTRAINT casedocument_pkey PRIMARY KEY (pid),
  CONSTRAINT casedocument_r0 FOREIGN KEY (pid) REFERENCES pobject (pid)
ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT casedocument_r1 FOREIGN KEY (casepid) REFERENCES cas (pid)
ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT casedocument_r2 FOREIGN KEY (createuserpid) REFERENCES
party (pid) ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT casedocument_r3 FOREIGN KEY (typepid) REFERENCES
casedocumenttype (pid) ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH OIDS;
ALTER TABLE casedocument OWNER TO tigris;

Is there any way to determine what data the copy doesn't like

thanks




--
Warren Little
Chief Technology Officer
Meridias Capital Inc
Tel: 866.369.7763

Re:

From
"Goulet, Dick"
Date:
Few, if any, application packages come with a preinstalled db.  They always send you the installation cd for the required database engine, with a runtime license if applicable, or place the requirement on the user to install the db first.


From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of uva raj
Sent: Thursday, November 24, 2005 7:46 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN]


hi all,

I use Postgresql 8.0.3 on redhat linux.

I compiled the source and installed. Its working fine.Now I developed an application over this. Can i package the installed postgresql with my application and distribute. will this postgres (compiled in my local machine) work in all linux systems?

iam newbie to Postgresql. Please help me.

Thanks in advance.