pg_dump fails..does not like "text" data..
От | Peter Kelly |
---|---|
Тема | pg_dump fails..does not like "text" data.. |
Дата | |
Msg-id | 5B11AE71DCF590449EF8C77A61DF09940754BE@bertha.ETS.NET обсуждение исходный текст |
Ответы |
Re: pg_dump fails..does not like "text" data..
|
Список | 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@krusty base]# pg_dump -D vrelay > /tmp/vrelay.dump Backend sent B message without prior T 85256C0C.001BCBE4-85256C0C.001BCBE4@oyp.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
В списке pgsql-admin по дате отправления: