postgresql for windows

Walter Grimm
Walter Grimm used Ask the Experts™
on
Does anyone know of a good tool to handle postgresql differential BU without rep, currently I am using native Wal procedure, but I am investigating, there are some good Linux tools, but could not find any windows apps, that don't blow my developer one person budget
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
lcohanDatabase Analyst

Commented:
I'm not exactly sure what you are after when you say
good tool to handle postgresql differential BU without rep
however from description above refering to WAL files if you look for good tool to manage Postgres "differential" backups, PITR, etc then maybe have a look at "Barman" here:  https://www.pgbarman.org/about/
I'm not sure if it is free/open source but I know we're using it for our backups and it's fairly easy to use and working great so it may be worth to have a look at it.

Author

Commented:
Thanx for info. As far as I know I have only found barman for Linux I use some text in the pgconfig {which does not work} which copies the Wal file to new dir, there I can zip and upload to bu server,

It does not work 100% on win currently
lcohanDatabase Analyst

Commented:
You are correct and sorry for misleading answer so what do you actually need? A windows tool that "ships" the WAL files to a
bu server
? Is that "bu server" a readonly/hotstandby type of server? Wold it help to setup replication between the two rather than using that process as described at link below for Windows?
This way your "master" database table(s) will be kept in sync at the subscriber - "bu server" side?

https://www.sigterritoires.fr/index.php/en/replicating-a-postgresql-database-in-a-windows-workstation/

For administration purpose there's Navicat for Windows for instance and at some point I used it to schedule "jobs" against Postgres running on Linux as I'm windows platform DBA mainly and not familiar with cron jobs, etc..
https://www.navicat.com/en/products/navicat-for-postgresql

Author

Commented:
Thanx, I want to set up servers, but keep it simple tight and secure, no replication, standby etc, no remote admin

I just want to save a Wal every min, zip and push to backup, at midnight I perform full bu,

In case of crash I pull all files and restore, hit it sort of running with config file,

Will check links, thanx

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial