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