pg_dump fails..does not like "text" data..

From: "Peter Kelly" <pkelly(at)ETS(dot)NET>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: pg_dump fails..does not like "text" data..
Date: 2002-08-13 12:26:45
Message-ID: 5B11AE71DCF590449EF8C77A61DF09940754BE@bertha.ETS.NET
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I am trying to do a pg_dump of a DB that has one table with approx.
732,390 rows in it.

Notes:

- I have tried pg_dump -d and pg_dump -D -- both with errors.
- I am running PostgreSQL 7.0.3 on Linux RedHat 7.0 (with all updates)
postgresql-devel-7.0.3-8
postgresql-server-7.0.3-8
postgresql-perl-7.0.3-8
postgresql-python-7.0.3-8
postgresql-jdbc-7.0.3-8
postgresql-odbc-7.0.3-8
postgresql-7.0.3-8
- 'vacuumdb --analyze vrelay' works fine.
- The field I am thinking it is bombing on is a "TEXT" field with email
header information (at least that is what it pukes below consistantly
and it does not seem to be one row it does not like -- it seems random)
- The physical server has 196MB ram and the postgresql data is on a
hardware raid 5 array.

Error:

The error is (I also included the table schema below):

[root(at)krusty base]# pg_dump -D vrelay > /tmp/vrelay.dump
Backend sent B message without prior T
85256C0C(dot)001BCBE4-85256C0C(dot)001BCBE4(at)oyp(dot)com>
Date: Mon, 5 Aug 2002 01:03:36 -0400
X-MIMETrack: Serialize by Router on TORSMTP1/OYP(Release 5.0.10 |March
22, 2002) at 08/05/2002
01:03:32 AM
MIME-Version: 1.0
Content-type: text/plain; charset=us-ascii
Backend sent D message without prior T
unexpected character M following 'I'
dumpClasses(): command failed. Explanation from backend: '-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2651.58)
Content-Type: multipart/mixed;
boundary="----_=_NextPart_000_01C23C97.DCBD58C0"
Unknown protocol character 'Unknown protocol character '0' read from
backend. (The protocol character is the first character the backend
sends in response to a query it receives).
Unknown protocol character '
' read from backend. (The protocol character is the first character the
backend sends in response to a query it receives).
ANUnknown protocol character 'Unknown protocol character 'Unknown
protocol character 'e' read from backend. (The protocol character is
the first character the backend sends in response to a query it
receives).
Unknown protocol character 'h' read from backend. (The protocol
character is the first character the backend sends in response to a
query it receives).
Unknown protocol character ' ' read from backend. (The protocol
character is the first character the backend sends in response to a
query it receives).
Unknown protocol character 'm' read from backend. (The protocol
character is the first character the backend sends in response to a
query it receives).

CREATE TABLE "smtp_log" (
"rid" int4 DEFAULT nextval('smtp_log_rid_seq'::text) NOT NULL,
"node_date" timestamp NOT NULL,
"node_fqdn" character varying(100) NOT NULL,
"status" character varying(10) NOT NULL,
"fromaddr" text NOT NULL,
"toaddr" text NOT NULL,
"headers" text,
"msg_id" character varying(100),
"size" int4,
"smtp_info" text,
"virus_info" text,
"virusid" character varying(100),
"createdon" timestamp DEFAULT "timestamp"('now'::text) NOT NULL
);

Any help would be appreciated.

--

Peter Kelly
ETS.NET INC.
10-17705 Leslie Street
Newmarket, ON
L3Y 3E3
CANADA

Phone: 1-905-713-9978 ext. 405
toll-free: 1-866-713-9978 ext. 405
Fax: 1-905-726-8118

Visit: http://www.ets.net
Enterprise Email Virus Protection: http://vRelay.NET

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Elielson Fontanezi 2002-08-13 14:23:11 RES: RES: HAPPY HOUR
Previous Message Jie Liang 2002-08-12 22:58:37 Re: ineffiency of pg_restore