Inherited an 18TB DB & need to backup

2020-05-15 Thread Suhail Bamzena
Hello All, I have very recently inherited an 18 TB DB that is running version 9.2. Apparently this database has never been backed up and I have been tasked to set in a periodic backup routine (weekly full & daily incremental) and dump it into a NAS. What is the best way to go about this? Did some r

Re: Inherited an 18TB DB & need to backup

2020-05-15 Thread Suhail Bamzena
Hi Christoph Thats very high on my agenda.. but need to make sure i can backup this beast to start with.. On Fri, 15 May 2020, 17:08 Christoph Berg, wrote: > Re: Rory Campbell-Lange > > On 15/05/20, Suhail Bamzena (suhailsa...@gmail.com) wrote: > > > Hello All, > >

Re: Inherited an 18TB DB & need to backup

2020-05-15 Thread Suhail Bamzena
Rory Campbell-Lange, wrote: > On 15/05/20, Suhail Bamzena (suhailsa...@gmail.com) wrote: > > Hello All, > > I have very recently inherited an 18 TB DB that is running version 9.2. > > Apparently this database has never been backed up and I have been tasked > to > > set i

Re: Inherited an 18TB DB & need to backup

2020-05-15 Thread Suhail Bamzena
tte verzeihen Sie Verstöße > gegen die Rechtschreibung - > > Mobile: +31-(0)6-1638 9607 > > http://www.enterprisedb.com/ > > *Don't walk behind me*; I may not lead. > *Don't walk in front of me*; I may not follow. > *Just walk beside me* and be my friend. > +*+

Re: Inherited an 18TB DB & need to backup

2020-05-15 Thread Suhail Bamzena
I can look into that.. not very sure abt the storage infra.. On Fri, 15 May 2020, 17:26 Wolff, Ken L, wrote: > Depending on your storage subsystem, perhaps storage-level snapshots might > be an option? They often seem to be the best choice for VLDBs. > > > > *From:* Suhai

Re: Inherited an 18TB DB & need to backup

2020-05-15 Thread Suhail Bamzena
egen die Rechtschreibung - > > Mobile: +31-(0)6-1638 9607 > > http://www.enterprisedb.com/ > > *Don't walk behind me*; I may not lead. > *Don't walk in front of me*; I may not follow. > *Just walk beside me* and be my friend. > +*+ Albert Camus +*+ > > Op 15 mei 2

Re: Inherited an 18TB DB & need to backup

2020-05-15 Thread Suhail Bamzena
Yeah Rory want to pull one asap..hopefully by COB tonight.. On Fri, 15 May 2020, 17:35 Rory Campbell-Lange, wrote: > On 15/05/20, Suhail Bamzena (suhailsa...@gmail.com) wrote: > > Thanks Rory, the machine has the capacity to pull through pg_dumps but > like > > u rightly men

Re: Inherited an 18TB DB & need to backup

2020-05-15 Thread Suhail Bamzena
Thanks Gabriele... i will review this in detail. On Fri, 15 May 2020, 18:41 Gabriele Bartolini, wrote: > Hi Suhail, > > We developed Barman (www.pgbarman.org), which works with older versions > of PostgreSQL too. It works with very large databases and is open source > (GPL). > > This is an old a

Re: Inherited an 18TB DB & need to backup

2020-05-15 Thread Suhail Bamzena
ckups. > > (If it's mostly historical data, I'd split the database into multiple > instances, so that older data rarely needs to be backed up. The > application, of course, would have to be modified.) > > On 5/15/20 8:26 AM, Suhail Bamzena wrote: > > Thanks Rory, the

Re: Inherited an 18TB DB & need to backup

2020-05-16 Thread Suhail Bamzena
Lange wrote: > > On 15/05/20, Suhail Bamzena (suhailsa...@gmail.com) wrote: > > > I have very recently inherited an 18 TB DB that is running version 9.2. > > > Apparently this database has never been backed up > [...] > > A very simple solution could be just to dump

Re: Inherited an 18TB DB & need to backup

2020-05-17 Thread Suhail Bamzena
Thanks James... that is reassuring, will be working on it this week. On Mon, 18 May 2020, 04:33 James Sewell, wrote: > > > On Fri, 15 May 2020 at 17:09, Suhail Bamzena > wrote: > >> Hello All, >> I have very recently inherited an 18 TB DB that is running vers