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