[GENERAL] Can a database be restored successfully after new installation.

[Rohit Prakash Khare]

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

Re: [GENERAL] Can a database be restored successfully after new installation.

[Andrew Sullivan]

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  | [EMAIL PROTECTED]
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