What is the most recommended way to backup a PostgreSQL database? And to restore it?
I would like to get ALL the data and properties possible, because if I have a problem, and I lost my current database, I can just restore it, and will be all exactly like was before. What is the best way? pg_dump? If yes, what options I need to use? Thanks a lot!! Eduardo S. Fontanetti ______________________________________________________________________ Yahoo! Mail - agora com 100MB de espaço, anti-spam e antivírus grátis! http://br.info.mail.yahoo.com/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
