Re: cannot restore db - Mailing list pgsql-novice

From Josh Berkus
Subject Re: cannot restore db
Date
Msg-id web-1374317@davinci.ethosmedia.com
Whole thread Raw
In response to cannot restore db  ("P. Jourdan" <pippo@videotron.ca>)
List pgsql-novice
Phillip,

> >This looks like a pg_dumpall file.  Are you just restoring one
> >database, or the whole server?
> I am trying to restore only the database which was on a virtual
> server on some IP. I believe that PG was on a shared server while the
> site was on another. What I have is the copy of the site that I
> periodically made as local backup.

Could be tough, then.  The way the file you have is supposed to be used
is to restore an entire database server from a fresh initdb, using
trusted access from the local machine.  As such, trying to restore only
one database on a shared server could be challenging.

How large is the file?  If you could send it to me, I could tinker
around and see if there's an easy way for you to restore what you need.
 If it's over 2mb, though, we'd have to do it by FTP.

-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

pgsql-novice by date:

Previous
From: Eduardo_Cadena@praxair.com
Date:
Subject: Newbie in functions
Next
From: Andrew McMillan
Date:
Subject: Re: Coalesce with Timestamp,Nulls,and Concatenation