pg_dump, bytea, dump order questions

From: Együd Csaba <csegyud(at)vnet(dot)hu>
To: "Pgsql-General(at)Postgresql(dot)Org (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: pg_dump, bytea, dump order questions
Date: 2004-06-07 08:38:27
Message-ID: 001601c44c6a$ce40e3e0$230a0a0a@compaq
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,
I'd like to dump out my database using plain text format. Everything is ok,
but the bytea filds.

Restoring the dump file (using <<psql -f LO_TRY_INSERT_BYTEA.sql tmp7>>) it
sends an error message like
psql:LO_TRY_INSERT_BYTEA.sql:14: ERROR: Bad input string for type bytea

Trying dumping with copy commands it sends this error:
psql:LO_TRY_COPY_BYTEA.sql:13: lost synchronization with server, resetting
connection

I used <<pg_dump -d ...>> and <<pg_dump ...>> formats for creating dump
files.

How should I use pg_dump to make it able to back my binary data correctly?

An other question. How can I make psql to change the dupm order of db
objects? My problem is, that one of my table fields has a default clasuse
using a plpgsql function. As being functions dumped after table definitions
creating these tables fail. What can I do in order to avoid these problems -
without modifying every dump file by hand?

Any help is appreciated.

Thank you,
-- Együd Csaba

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com)
Version: 6.0.699 / Virus Database: 456 - Release Date: 2004. 06. 04.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gaetano Mendola 2004-06-07 09:09:09 Re: [HACKERS] CREATE DATABASE on the heap with PostgreSQL?
Previous Message Rajesh Kumar Mallah 2004-06-07 07:58:22 Tsearch case sensitive with dotted search terms.