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(at)crankycanuck(dot)ca
Unfortunately reformatting the Internet is a little more painful
than reformatting your hard drive when it gets out of whack.
--Scott Morris