Re: [tanya-jawab] Backup postgresql
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
Re: [tanya-jawab] Backup postgresql
setahu saya pake pg_dump atau pg_dumpall untuk backup postgre, terus supaya otomatis pake pg_agent --- Fajar Priyanto [EMAIL PROTECTED] wrote: Hi rekan2? Ada yang pakai database postgresql? Ada yang tahu dimana bisa dapetin script untuk backup otomatisnya ngga yah? Ngegoogle blom ketemu nih. Thanks. -- Fajar Priyanto | Reg'd Linux User #327841 | Linux tutorial http://linux2.arinet.org 07:42:35 up 6:15, 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 - ody __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- 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
Re: [tanya-jawab] Backup postgresql
Fajar Priyanto wrote: Hi rekan2? Ada yang pakai database postgresql? Ada yang tahu dimana bisa dapetin script untuk backup otomatisnya ngga yah? Ngegoogle blom ketemu nih. Thanks. 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. -- Kamas Muhammad -- 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