On Sunday 12 March 2006 02:01 pm, Kamas Muhammad wrote: > gimana kalo pake pg_dump atau pg_dumpall? Udah termasuk dalam paket > postgresql. Ini ada sepotong dari man keduanya :) > > pg_dump is a utility for backing up a PostgreSQL database. It makes con- > sistent backups even if the database is being used > concurrently. pg_dump does not block other users accessing the > database (readers or writers). > > pg_dumpall is a utility for writing out (``dumping'') all PostgreSQL > databases of a cluster into one script file. The script file > contains SQL commands that can be used as input to psql(1) to > restore the databases. It does this by calling pg_dump(1) for each > database in a cluster. pg_dumpall also dumps global objects > that are common to all databases. (pg_dump does not save these > objects.) This currently includes information about database > users and groups, and access permis- sions that apply to databases > as a whole.
Nah itu Mas, Iseng2 saya lagi bikin bash scriptnya, jadi bisa ngesave berdasarkan hari dan jam. Trus di zip. Trus di rotate. Ntar saya tanya2 lagi yah :) -- Fajar Priyanto | Reg'd Linux User #327841 | Linux tutorial http://linux2.arinet.org 20:22:06 up 16 min, 2.6.15-1.1830_FC4 GNU/Linux Let's use OpenOffice. http://www.openoffice.org -- FAQ milis di http://wiki.linux.or.id/FAQ_milis_tanya-jawab Unsubscribe: kirim email ke [EMAIL PROTECTED] Arsip dan info milis selengkapnya di http://linux.or.id/milis