Restore from dump file: parse error

From: S P Arif Sahari Wibowo <arifsaha-lists(at)parokinet(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Restore from dump file: parse error
Date: 1999-05-06 21:18:14
Message-ID: Pine.LNX.4.10.9905061617330.3770-100000@semeru.parokinet.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

I am updating from 6.3.2 to 6.4.2. Obviously I started by dumping my
databases, i.e.:

pg_dump database > database.sql

After the update, I restoring my databases, i.e.:

createdb database
psql database < database.sql

(interestingly pg_dump doesn't insert create database command, I think it
should)

However, this database have big text fields. pg_dump made some text data
spanned several lines with "\" on the unfinished lines. On reading the
database.sql, psql choke on this continued lines, give "PARSER ERROR" and
print out it help page, eventually, psql crash on segmentation fault.

Anything can be done on this stage?

Thank you.

Arif

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paulo Parola 1999-05-06 21:52:54 Case insensitive searches
Previous Message Oliver Elphick 1999-05-06 21:05:42 Re: [GENERAL] pg_hba.conf and crypt