Hello everyone:
I have a systems admin that is backing up our Linux computers
(postgres) by backing up the directory structure. This of course
includes all the files that pertain to my postgres databases. I
maintain that using pgdump and creating a file of SQL commands for
restore is a better method by allowing the restore on any linux box that
is running postgress as opposed to having to reconstruct the directory
on another server.
Does anyone have any thoughts on this matter. Is one way better than
the other? Thanks in advance.
Bob Powell
Database Administrator