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@xxxxxxxxxxxxxx> 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
