Skip site navigation (1) Skip section navigation (2)

Re: cannot restore db

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: "P(dot) Jourdan" <pippo(at)videotron(dot)ca>, pgsql-novice(at)postgresql(dot)org
Subject: Re: cannot restore db
Date: 2002-04-17 03:42:08
Message-ID: web-1373641@davinci.ethosmedia.com (view raw or flat)
Thread:
Lists: pgsql-novice
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(at)agliodbs(dot)com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco

In response to

pgsql-novice by date

Next:From: Josh BerkusDate: 2002-04-17 04:42:25
Subject: Re: Interval data types and SQL Server
Previous:From: Oliver ElphickDate: 2002-04-16 22:37:30
Subject: Re: Pl/Pgsql function troubles: FOLLOW UP

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group