Home > mailing lists

Restoring dtabase problem - Mailing list pgsql-admin

From	Benjamin Krajmalnik
Subject	Restoring dtabase problem
Date	August 4, 2006 17:07:09
Msg-id	BF337097BDD9D849A2F4B818DDB27987252589@stash.stackdump.local Whole thread Raw
Responses	Re: Restoring dtabase problem (Ivo Rossacher <rossacher@bluewin.ch>)
List	pgsql-admin

I am trying to restore a database from a pg_dump.

I have a problematic issue in that a few rows have a problem with UTF-8 encoding.

All of these rows are in a specific table.

Is there something I can run against the table which will validate the rows which have the bad data and delete the rows?

The database is quite large (8GB) and I was informed that it would be much faster to restore using the COPY method as opposed to the INSERT method.

Any and all assistance will be deeply appreciated.

Regards,

Benjamin

From: Peter Eisentraut
Date: 04 August 2006, 16:10:49
Subject: Re: installing on user account

From: RPK
Date: 04 August 2006, 17:47:14
Subject: Problem in starting PGSQL8.1 service.