Hi, I want to backup a database. I've read here that pg_dumpall is really the best way to do it. However, what options are going to be most useful to me, should I need to restore the db ever. I know there's probably lots of conditional things, but just in general, what are the most commonly used. I'm mainly looking at the benefit of using -o and -d. Thanks, Joe ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly