Re: [PERFORM] Backup taking long time !!!

Greetings, * julyanto SUTANDANG (julya...@equnix.co.id) wrote: > Please elaborate more of what you are saying. What i am saying is based on > the Official Docs, Forum and our own test. This is what we had to do to > save time, both backing up and restoring. > >

Re: [PERFORM] Backup taking long time !!!

Hi Stephen, Please elaborate more of what you are saying. What i am saying is based on the Official Docs, Forum and our own test. This is what we had to do to save time, both backing up and restoring. https://www.postgresql.org/docs/9.6/static/functions-admin.html When PostgreSQL in the mode

Re: [PERFORM] Backup taking long time !!!

Greetings, * julyanto SUTANDANG (julya...@equnix.co.id) wrote: > Thanks for elaborating this Information, this is new, so whatever it is the > procedure is *Correct and Workable*. Backups are extremely important, so I get quite concerned when people provide incorrect information regarding them.

Re: [PERFORM] Backup taking long time !!!

Hi All, Especially for Stephen Frost, Thank you very much for your deeply explanation and elaboration! Anyway, all has clear, i am not disagree with Stephen, i am the lucky one get in corrected by Expert like you. in short, please use pg_basebackup for getting snapshot and don't forget for the

Re: [PERFORM] Backup taking long time !!!

Hi Stephen, > > When PostgreSQL in the mode of Start Backup, PostgreSQL only writes to > the > > XLOG, then you can safely rsync / copy the base data (snapshot) then > later > > you can have full copy of snapshot backup data. > > You are confusing two things. > > After calling pg_start_backup,

Re: [PERFORM] Backup taking long time !!!

> 20 янв. 2017 г., в 19:59, Stephen Frost написал(а): > >>> How are you testing your backups..? Do you have page-level checksums >>> enabled on your database? >> >> Yep, we use checksums. We restore latest backup with recovery_target = >> 'immediate' and do COPY

Re: [PERFORM] Backup taking long time !!!

Vladimir, * Vladimir Borodin (r...@simply.name) wrote: > > 20 янв. 2017 г., в 19:59, Stephen Frost написал(а): > >>> How are you testing your backups..? Do you have page-level checksums > >>> enabled on your database? > >> > >> Yep, we use checksums. We restore latest

Re: [PERFORM] Backup taking long time !!!

Greetings, * julyanto SUTANDANG (julya...@equnix.co.id) wrote: > Best practice in doing full backup is using RSYNC, but before you can copy > the DATADIR, you might you pg_start_backup to tell the server not to write > into the DATADIR, because you are copying that data. After finished copy > all

Re: [PERFORM] Backup taking long time !!!

Greetings, * julyanto SUTANDANG (julya...@equnix.co.id) wrote: > CORRECTION: > > "you might you pg_start_backup to tell the server not to write into the > DATADIR" > > become > > "you might *use* pg_start_backup to tell the server not to write into the > *BASEDIR*, actually server still writes

Re: [PERFORM] Backup taking long time !!!

Hi Dinesh, Best practice in doing full backup is using RSYNC, but before you can copy the DATADIR, you might you pg_start_backup to tell the server not to write into the DATADIR, because you are copying that data. After finished copy all the data in DATADIR, you can ask server to continue

Re: [PERFORM] Backup taking long time !!!

CORRECTION: "you might you pg_start_backup to tell the server not to write into the DATADIR" become "you might *use* pg_start_backup to tell the server not to write into the *BASEDIR*, actually server still writes but only to XLOGDIR " Regards, Julyanto SUTANDANG Equnix Business