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