PostgreSQL

01 May 2025 15:34

You can always start. And containers are really useful for this. You can snapshot them, find out what you did wrong etc.

PostgreSQL

01 May 2025 15:33

)) the point is I have never had real practice

PostgreSQL

01 May 2025 15:32

Or maybe other different things

PostgreSQL

01 May 2025 15:31

Ahem, you want a server with PostgreSQL you mean?

A free server won't be possible for a full process I guess. Why not your local machine?

PostgreSQL

01 May 2025 15:11

Hey guys , maybe someone knows free servers to practice except git

PostgreSQL

30 Apr 2025 20:07

I have not yet seen ready-made tools that do this automatically

PostgreSQL

30 Apr 2025 20:00

Hello yes aurora postgresql has pg_cron but how existing sql jobs will move to aurora

PostgreSQL

30 Apr 2025 19:44

Anyone can tell how to migrate SQL server agent jobs to Aurora postgresql

PostgreSQL

30 Apr 2025 10:59

I got blocked by spam bot for some minutes, and that’s it

PostgreSQL

29 Apr 2025 20:27

Do you guys know a way to tell telegram it was not me?

PostgreSQL

29 Apr 2025 20:26

Although if they got his tele prob via cookies, most likely they got access to storage on device right?

PostgreSQL

29 Apr 2025 20:25

Pls don’t ban me.. telegram’s gonna ban me 100%..

PostgreSQL

29 Apr 2025 20:24

Did you get infected

PostgreSQL

29 Apr 2025 19:43

hello guys i have a problem with postgresql in intellij
Can anyone help me ?

PostgreSQL

28 Apr 2025 22:18

Yeah I just use dump psql and restore it via cli. Maybe I’m missing what you are searching for, but that allows rebuilding the db with exact schema and data, you might need to grant permissions again tho if you are using a new user to connect to db.

Just use a simple init-grant-perm.sql file ^_^

PostgreSQL

01 May 2025 15:33

I mean I think writing queries is not enough

PostgreSQL

01 May 2025 15:32

??😅

Use Podman or VM if you have fear of formatting your root disk.

PostgreSQL

01 May 2025 15:32

I wanna understand how it is imported like maybe using some api

PostgreSQL

01 May 2025 15:30

The full process - from importing data till analyzing

PostgreSQL

30 Apr 2025 20:10

https://aws.amazon.com/es/blogs/database/migrate-sql-server-to-amazon-aurora-postgresql-using-best-practices-and-lessons-learned-from-the-field/
Check this doc which it has several recommendations in order to migrate jobs but in my opinion you still are going to fix some issue manually although you use some tool

PostgreSQL

30 Apr 2025 20:04

Convert sql server jobs to csv file , fix sql if need and then load to cron.job table

PostgreSQL

30 Apr 2025 19:59

Hi!
Aurora postgresql has pg_cron extension, so you can use it

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/PostgreSQL_pg_cron.html

PostgreSQL

30 Apr 2025 11:01

I deleted every single message for everyone saying sorry in all groups as I did here. I wrote to Telegram Support telling what happened specifying user IDs, username and what I did to counter what happened hoping that i will not receive a ban for this in the future

PostgreSQL

30 Apr 2025 06:09

Nope, hopefully nobody reported you and their spam beeps didn't go off

PostgreSQL

29 Apr 2025 20:27

I logged out from infected device

PostgreSQL

29 Apr 2025 20:25

Check your sessions from Privacy and enable 2FA

PostgreSQL

29 Apr 2025 20:25

Id burn you’re OS to the ground

PostgreSQL

29 Apr 2025 20:24

Please do not click the link

PostgreSQL

28 Apr 2025 22:24

If you mean "replication" in the sense that the replica is continuously kept up to date by the primary, then binary replication is the only in-core solution. If you just mean "take a copy of a database at a point in time," you can use pg_dump as mentioned above.

PostgreSQL

28 Apr 2025 18:05

Are there any other replication methods that copy these as well?