Problems with PG_DUMP and restore - Mailing list pgsql-sql

From Josh Berkus
Subject Problems with PG_DUMP and restore
Date
Msg-id web-83411@davinci.ethosmedia.com
Whole thread Raw
List pgsql-sql
Folks,

In an effort to do some general cleanup in my database functions, I
dumped the schema (pgdump -s) and the data (pgdump -a) to seperate text
files.

I editied and restored the schema fine. However, when I attemped to
restore the data (via \i filename), it failed selectively; some tables
were restored but many were not. No errors were logged.

Can someone give me some help? The application is due next week, and I
can't afford this setback. Grazie.

-Josh


______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco

Attachment

pgsql-sql by date:

Previous
From: Christof Glaser
Date:
Subject: Re: select only the first record
Next
From: Roberto Mello
Date:
Subject: CREATE TYPE function examples