English speaking PostgreSQL public chat. This group is for discussions on PostgreSQL-related topics and strives to provide best-effort support as well.
Friends, if anyone has worked with data languages other than JSON and YAML, please dm 🌷
Читать полностью…Crunchy provided several tutorial and demo environments https://www.crunchydata.com/developers/tutorials
Читать полностью…You can always start. And containers are really useful for this. You can snapshot them, find out what you did wrong etc.
Читать полностью…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?
Hey guys , maybe someone knows free servers to practice except git
Читать полностью…I have not yet seen ready-made tools that do this automatically
Читать полностью…Hello yes aurora postgresql has pg_cron but how existing sql jobs will move to aurora
Читать полностью…Anyone can tell how to migrate SQL server agent jobs to Aurora postgresql
Читать полностью…I got blocked by spam bot for some minutes, and that’s it
Читать полностью…Do you guys know a way to tell telegram it was not me?
Читать полностью…Although if they got his tele prob via cookies, most likely they got access to storage on device right?
Читать полностью…Go to aws, click on EC2, launch your instance and select *free tier Ubuntu machine then Google "how to install postgres on EC2 ubuntu". After you done with set up Google "how to generate sample data in Postgres", after that Google to how to analyze data then do that. Google or chatgpt skills will take you far in life.
Читать полностью…??😅
Use Podman or VM if you have fear of formatting your root disk.
I wanna understand how it is imported like maybe using some api
Читать полностью…The full process - from importing data till analyzing
Читать полностью…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
Convert sql server jobs to csv file , fix sql if need and then load to cron.job table
Читать полностью…Hi!
Aurora postgresql has pg_cron extension, so you can use it
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/PostgreSQL_pg_cron.html
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
Читать полностью…Nope, hopefully nobody reported you and their spam beeps didn't go off
Читать полностью…