PostgreSQL

05 October 2024 21:46

just put everything on the cloud bro

PostgreSQL

05 October 2024 21:45

Then get an amazon linux instance to run that management tasks.

Or amazon/windows (windows task scheduler itself, btw, is a fine tool, I like it more than cron. Also a good generic service runner on windows, btw. Windows, hoewer, has a lot of deficiences as a server, especially as a cloud-based server).

PostgreSQL

05 October 2024 21:43

U are postgresql DBA

PostgreSQL

05 October 2024 21:43

Didn't see any one.

Seen, however, a lot doing exactly opposite (even helped a bit).

PostgreSQL

05 October 2024 21:42

Cloud to cloud communication

PostgreSQL

05 October 2024 21:41

Yeah, but why migrate to the cloud if you host local applications?

PostgreSQL

05 October 2024 21:40

Okay, But we have migrated so many databases from on prem SQL server to azure sql. It's working very good

PostgreSQL

05 October 2024 21:39

To save cost. Because SQL server is very costly. But postgresql is free

PostgreSQL

05 October 2024 21:38

SQL server DBA only work in windows environment. Now it's moving to azure.

PostgreSQL

05 October 2024 21:37

Because cloud is a lie that will bite back once you have actual workloads

PostgreSQL

05 October 2024 21:36

Why. Now most of companies are migrating their databases to cloud.

PostgreSQL

05 October 2024 21:35

Pgagent cannot install since its aurora postgresql

PostgreSQL

05 October 2024 21:30

We just connect aurora postgresql using dbeaver in windows

PostgreSQL

05 October 2024 21:30

you are sql server server dba, go cron or ask admins

PostgreSQL

05 October 2024 21:16

Anyone can please share batch file script to do automate postgresql db backup using task scheduler

PostgreSQL

05 October 2024 21:46

Cloud will stay around, just as Java did. I tried to sit both out... 😏

Anyway. I'd assume Aurora (which is *not* PostgreSQL, btw.) will provide some backup schedule. As it is not PostgreSQL, chances are quite good that a pg_basebackup or even pg_dump will fail anyway. Also, where did you plan to _store_ your backups? On premise?!? ;-)

PostgreSQL

05 October 2024 21:43

Lower speed, higher cost, higher chance of data leak....

PostgreSQL

05 October 2024 21:43

I can understand for a website or something that needs to be public, but i really don't understand why you would migrate everything "on the cloud"

PostgreSQL

05 October 2024 21:42

That sounds stupid. Keep your internal stuff internal, offline, on prem

PostgreSQL

05 October 2024 21:41

Application is also moved to cloud

PostgreSQL

05 October 2024 21:41

U can use linux to run sql server too, but not mostly common out there

PostgreSQL

05 October 2024 21:39

even, you don't have a provisional infrastructure and even cpu and usages increases whiteout knowing the core reasons of this is really suck.... the only option u get is by upscalling, and even most of cloud support they knew nothing and have no clue if u incounter an issue in the vm or server ur running ur database on

PostgreSQL

05 October 2024 21:38

SQL server DBA and postgresql DBA completely different track

PostgreSQL

05 October 2024 21:37

100 percent agree on that, Edoardo 👍👍

PostgreSQL

05 October 2024 21:36

Then I guess you should have an option included out there on aurora or amazon platform to automate this for sure...

PostgreSQL

05 October 2024 21:35

you guys work only in linux environment not windows and work only on prem postgres not cloud?

PostgreSQL

05 October 2024 21:35

use task scheduler then on windows, or you can install PGAGENT on postgres database and automate this by having steps include on the job itself. Either of the these options should work fine

PostgreSQL

05 October 2024 21:30

We have postgresql in windows

PostgreSQL

05 October 2024 21:29

How to do that. any script pls

PostgreSQL

05 October 2024 07:51

🚀 We're Hiring: PostgreSQL DBA (3-7 Years Experience)

Join our team to manage and optimize PostgreSQL databases, with a focus on performance tuning and 24/7 support. 💻 Strong Linux/Unix skills required.

🌍 Location: Remote
📩 Apply: DM your resume!