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?





Have you checked out the new-look www.indiatimes.com yet?


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster