Re: [GENERAL] Gotcha's in copying data between servers via file copy

2006-02-01 Thread Bruce Momjian
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. -

[GENERAL] Gotcha's in copying data between servers via file copy

2006-02-01 Thread Frank Church
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? ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignor