> 1. Do a pg_dump on server1 (it has the space) and then backup the dump file
> 2. Do the same on server2 instead
> 3. Set up a PITR backup on server2
> 4. Do a simple file system backup. This requires shutting down the
> database while the backup is in progress.
They are all valid used solutions to backup postgresql databases. For option 3 i think you mean the hot postgresql backup, witch requires enabling db archiving, before job scripts in order to put database in backup mode and after job script to quit backup mode.
This method is good for not needing aditional dump generation space, to keep the database available for some commands while doing backup and to allow pitr.
But i'm not a DBA, maybe you can ask to him. =)
>
> so, I'm curious. Any responses?
>
> Thanks in advance.
>
>
> JBB
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Bacula-users mailing list
> Bacula-users AT lists.sourceforge DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
------------------------------------------------------------------------------
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|