Re: [GENERAL] review db dump script and difference between pg_dump & pg_dumpall

2008-10-09 Thread hubert depesz lubaczewski
On Thu, Oct 09, 2008 at 02:29:30PM +1100, Chris Henderson wrote: > I have written the following script to backup _all_ databases on > various servers that are running postgresql. I don't want anything > fancy - just be able to backup the database and restore when bad times > come. Just posting it h

[GENERAL] review db dump script and difference between pg_dump & pg_dumpall

2008-10-08 Thread Chris Henderson
I have written the following script to backup _all_ databases on various servers that are running postgresql. I don't want anything fancy - just be able to backup the database and restore when bad times come. Just posting it here to be reviewed to see if I have made any mistake: #!/bin/bash DIR=/b