Moving a PostgreSQL database from one server to another

[Richard E Miles]

On Thu, 13 Jan 2005 13:16:58 -0500 (EST)
Rodolfo J. Paiz wrote:

> Hi, everyone:
> 
> I'll happily accept a pointer to an FM I can R, but haven't found it
> yet. I'm just moving to PostgreSQL from MySQL, and so far I really
> really like it. The learning curve for a total newbie has been very easy
> thus far (easier than MySQL by a good chunk), and I simply love the fact
> that I finally have referential integrity, transactions, and stored
> procedores in an open-source database.
> 
> Anyway, my problem is that I set up and populated a database on my
> notebook, but of course my production website is not *on* my notebook.
> <grin> I move the website files to the server with rsync... but how do I
> move the PostgreSQL database?
> 
> I guess I need a backup/restore or an export/import... but for some
> bizarre reason I haven't found them yet. Admittedly I've only been
> looking for about an hour (and I keep getting sidetracked learning other
> stuff), but I thought I'd send a quick email to the One True List to see
> if anyone can save me some time, since I'm on a deadline.
> 
> Thanks, y'all...
> 
> -- 
> Rodolfo J. Paiz <rpaiz at simpaticus.com>

You might want to look at pgdump and pgrestore to accomplish this. I havn't
used it myself, but I think that may work.
YMMV

-- 
Richard E Miles
Federal Way WA. USA
registered linux user 46097