backup

Started by Andy Hartmanover 1 year ago5 messagesgeneral
Jump to latest
#1Andy Hartman
hartman60home@gmail.com

anyone use Powershell in an automated fashion to do DB backup? Would you
share your example?

Thanks.

#2Adrian Klaver
adrian.klaver@aklaver.com
In reply to: Andy Hartman (#1)
Re: backup

On 10/7/24 08:48, Andy Hartman wrote:

anyone use Powershell in an automated fashion to do DB backup?  Would
you share your example?

Search engine of your choice: "powershell postgresql backup script"

Using DuckDuckGo I see 6 relevant entries right of the top.

 Thanks.

--
Adrian Klaver
adrian.klaver@aklaver.com

#3Ron
ronljohnsonjr@gmail.com
In reply to: Andy Hartman (#1)
Re: backup

On Mon, Oct 7, 2024 at 11:48 AM Andy Hartman <hartman60home@gmail.com>
wrote:

anyone use Powershell in an automated fashion to do DB backup? Would you
share your example?

PS can execute utilities, so using it as a wrapper for pg_dump and
pg_restore (just like a bash script) is perfectly viable.

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> crustacean!

#4Muhammad Usman Khan
usman.k@bitnine.net
In reply to: Andy Hartman (#1)
Re: backup

Hi,
You can refer the following:
Automating PostgreSQL Backups with Python Using pg_basebackup | by Usman
Khan | Sep, 2024 | Medium
<https://medium.com/@usman.khan9805/automating-postgresql-backups-with-python-using-pg-basebackup-fe8e32d61a9a&gt;
Automating PostgreSQL Backups with PG Back Web: The Complete Walkthrough |
by Usman Khan | Sep, 2024 | Medium
<https://medium.com/@usman.khan9805/automating-postgresql-backups-with-pg-back-web-the-complete-walkthrough-7a0aade69b1c&gt;

On Mon, 7 Oct 2024 at 20:48, Andy Hartman <hartman60home@gmail.com> wrote:

Show quoted text

anyone use Powershell in an automated fashion to do DB backup? Would you
share your example?

Thanks.

#5Andy Hartman
hartman60home@gmail.com
In reply to: Muhammad Usman Khan (#4)
Re: backup

Thanks, I'll check it out.

On Mon, Oct 7, 2024 at 11:25 PM Muhammad Usman Khan <usman.k@bitnine.net>
wrote:

Show quoted text

Hi,
You can refer the following:
Automating PostgreSQL Backups with Python Using pg_basebackup | by Usman
Khan | Sep, 2024 | Medium
<https://medium.com/@usman.khan9805/automating-postgresql-backups-with-python-using-pg-basebackup-fe8e32d61a9a&gt;
Automating PostgreSQL Backups with PG Back Web: The Complete Walkthrough |
by Usman Khan | Sep, 2024 | Medium
<https://medium.com/@usman.khan9805/automating-postgresql-backups-with-pg-back-web-the-complete-walkthrough-7a0aade69b1c&gt;

On Mon, 7 Oct 2024 at 20:48, Andy Hartman <hartman60home@gmail.com> wrote:

anyone use Powershell in an automated fashion to do DB backup? Would you
share your example?

Thanks.