It is called, pg_dump - see my previous post. Tom Veldhouse veldy at veldy.net ----- Original Message ----- From: David Wood <jbevren at yahoo.com> To: TCLUG <tclug-list at mn-linux.org> Sent: Thursday, August 24, 2000 12:01 AM Subject: Re: [TCLUG:20610] moving PostgreSQL table > > I recommend you check out the dumpdb command :) > > It allows you to dump an entire database to a schema file (aimed at backup > and archival I'm sure), but can also be handy for moving databases across > systems ;) > > Have at 'em! > > -David > > On Tue, 22 Aug 2000, Timothy Wilson wrote: > > > I'm migrating a very simple PostgreSQL database from one machine to another > > and I can't figure out the proper procedure. I scanned a bunch of the docs, > > but I can't find anything that says, "Hey, idiot, here's how you move a > > database from one machine to another!" > > > > Can I simply tar up the files in the existing 'foo_db' directory and move > > them to the new machine and untar in the appropriate place? > > I suppose you could try that, but I'd recommend the above solution so the > database is built by the daemon instead of some other daemon :) > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: tclug-list-unsubscribe at mn-linux.org > For additional commands, e-mail: tclug-list-help at mn-linux.org > > --------------------------------------------------------------------- To unsubscribe, e-mail: tclug-list-unsubscribe at mn-linux.org For additional commands, e-mail: tclug-list-help at mn-linux.org