Re: cannot restore db

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(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