Re: Can a database be restored successfully after new installation. - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: Can a database be restored successfully after new installation.
Date
Msg-id 20070202180345.GE11505@phlogiston.dyndns.org
Whole thread Raw
In response to Can a database be restored successfully after new installation.  ("Rohit Prakash Khare" <rohitprakash123@indiatimes.com>)
List pgsql-general
On Fri, Feb 02, 2007 at 11:27:38PM +0530, Rohit Prakash Khare wrote:
> If I have a backup of pgsql database and I take this dump file to
> another machine where postgresql is freshly installed with standard
> settings. Will I be able to restore the database?

How did you backup?  pg_dump?  Sure, oughta work fine, assuming you
have all the necessary support in your target system.  (e.g. if
you're using plpgsql, for instance, you need to have performed
createlang for it, &c.)

A


--
Andrew Sullivan  | ajs@crankycanuck.ca
Unfortunately reformatting the Internet is a little more painful
than reformatting your hard drive when it gets out of whack.
        --Scott Morris

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Predicted lifespan of different PostgreSQL branches
Next
From: Richard Huxton
Date:
Subject: Re: Predicted lifespan of different PostgreSQL branches