i read that you can copy the contents of pgsql's data directory to create a backup, too. in order to restore the db, you clean out the data directory and then copy the "backed up" files back in to the data directory. i have no experience using this method, but i thought i'd mention it to see if anyone else has done this. --- Christopher Kings-Lynne <chriskl@xxxxxxxxxxxxxxxxxxx> wrote: > pg_dumpall <dbname> > backup.sql > > Chris > > enzo venegas palacios wrote: > > hi, i don't know use the pg_dump instruccion and i > need create a backup, > > please someone has an example. > > thanks > > enzo > > > --------------------------------------------------------- > > > > Imagina tus vacaciones perfectas... y hazlas > realidad. Juega en http://sorteos.ya.com > > ADSL + Llamadas 24 horas: desde 28,95 ?/mes + IVA. > Navega y habla de forma ilimitada. Sin compromiso de > permanencia. http://acceso.ya.com/ADSLllamadas/ > > > > > > ---------------------------(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 > > > ---------------------------(end of > broadcast)--------------------------- > TIP 2: you can get off all lists at once with the > unregister command > (send "unregister YourEmailAddressHere" to > majordomo@xxxxxxxxxxxxxx) > __________________________________ Yahoo! Mail Mobile Take Yahoo! Mail with you! Check email on your mobile phone. http://mobile.yahoo.com/learn/mail
