Frank Church wrote: > > I want to copy the data from one server to another. One is running Postgresql > 7.4.6 and the other 7.4.7. > > Are they any gotchas I should lookout for when making the copy? None. You can shutdown and do a binary copy of the filesystem, or use pg_dump or pg_dumpall. -- Bruce Momjian | http://candle.pha.pa.us pgman@xxxxxxxxxxxxxxxx | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073