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..  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Jie Liang
Дата:
Сообщение: Re: ineffiency of pg_restore
Следующее
От: Elielson Fontanezi
Дата:
Сообщение: RES: RES: HAPPY HOUR