Re: cannot restore db

Jourdan,

> I have installed pg 7.2.1_1, initialized & setup databases, installed
> plpgsql, set up users & superusers - everything seems to be ok....
> but I cannot restore the backup of a database that was created in pg
> 7.0.3 .
> I do not know how the original was created - pg_dump or pg_dumpall.
> These are a few of the first lines of the dump.file:
>
> Username: Password:
> \connect - med

This looks like a pg_dumpall file.  Are you just restoring one
database, or the whole server?

-Josh Berkus


______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