Re: [ADMIN] Backup routine

2003-08-11 Thread Bruce Momjian
Christopher Browne wrote: The world rejoiced as [EMAIL PROTECTED] (Peter and Sarah Childs) wrote: However there is a third way. That should be safe but some people may disagree with me! If you can freeze the disk while you take the backup. The backup can be used as if the computer had

Re: [ADMIN] syslog enabled causes random hangs?

2003-08-11 Thread Tom Lane
Arthur Ward [EMAIL PROTECTED] writes: It looks to me like the guy doing VACUUM is simply waiting for the other guy to release a page-level lock. The other guy is running a deferred trigger and so I'd expect him to be holding one or two page-level locks, on the page or pages containing the

Re: [ADMIN] Backup routine

2003-08-11 Thread Dani Oderbolz
Hi Enio, Enio Schutt Junior wrote: Hi Here, where I work, the backups of the postgresql databases are being done the following way: There is a daily copy of nearly all the hd (excluding /tmp, /proc, /dev and so on) in which databases are and besides this there is also one script which makes