Thread: pg_dump is missing data

pg_dump is missing data

From

"Robert Wille"

Date:

26 March 2004, 15:36:18

I am running Postgres 7.3.3 on RedHat Linux 7.3. I have 14 tables, but when I run “pg_dump -c -F p -U username dbname”, the output contains no data for three of them. Here is the relevant output for one of the tables:

-- TOC entry 9 (OID 16990)

-- Name: message; Type: TABLE; Schema: public; Owner: jobq

CREATE TABLE message (

recipient character varying(60) NOT NULL,

subject character varying(2000) NOT NULL,

body character varying(2000) NOT NULL,

eventtime timestamp with time zone NOT NULL,

delivertime timestamp with time zone NOT NULL

);

-- Data for TOC entry 40 (OID 16990)

-- Name: message; Type: TABLE DATA; Schema: public; Owner: jobq

COPY message (recipient, subject, body, eventtime, delivertime) FROM stdin;

I really need some help on this. This database runs the company I work for.

Robert Wille

Re: pg_dump is missing data

From

Tom Lane

Date:

26 March 2004, 16:25:37

"Robert Wille" <rwille@iarchives.com> writes:
> I am running Postgres 7.3.3 on RedHat Linux 7.3. I have 14 tables, but
> when I run "pg_dump -c -F p -U username dbname", the output contains no
> data for three of them. Here is the relevant output for one of the
> tables:

> COPY message (recipient, subject, body, eventtime, delivertime) FROM
> stdin;
> \.

Sure looks to me like that table is empty.  Are you saying you get data
out of it when you do a manual COPY or SELECT?

            regards, tom lane