Re: [ADMIN] [Admin] Large DataBase move

2010-08-29 Thread Amit jain
Upgrade with slony tool in less than 15min downtime. Try this out !! http://www.slony.info/documentation/versionupgrade.html Jesper Krogh wrote: On 2010-08-28 17:44, Joshua D. Drake wrote: On Sat, 2010-08-28 at 17:25 +0200, David Montoya wrote: Hello: I have a DB with 90GB in po

Re: [ADMIN] Use hardware snapshots to restore postgres

2010-08-29 Thread Rosser Schwarz
On Sat, Aug 28, 2010 at 7:15 PM, jigar shah wrote: > so instead of tar or cpio, i am looking for the procedure where you can use > hardware level snapshots of the postgres filesystem, which you can take on > san (3par) or nas (netapp) or any other vendor hardware, and then mount the > postgres fil