Postgresql : Pg cron

[@shailendrasisodiya8243]

2024-01-21 12:38:00.001 IST [3628] LOG: cron job 1 starting: SELECT insert_into_emp(); 2024-01-21 12:38:00.007 IST [3628] LOG: cron job 1 connection failed this is what is showing in my log files dont know whats wrong

[@how_and_why]

How to use pg_profile extension in AWS RDS, i checked on Google it says we need to have the package at OS level but RDS doesn't support os access, how to do it?

[@ricardochavarriafdz5928]

ERROR: syntax error at or near "pg_dump"

[@ricardochavarriafdz5928]

output syntax error at or near "pg_dump"

[@vinithvicky2017]

Hello, Can we do this in AWS RDS Postgres ? If yes, then can tell how to install pg_cron ?

[@EMultiSkillsDatabaseServices]

Yes , it can be done in rds .

[@mohamedboudekak8574]

Hello, thanks for the explanation, however i tried the backup line and it doesn't work. The cron is succesfully created but it doesn't work select cron.schedule('0 0 * * *', $$pg_dumpall > /home/odoo/backup/MyDB_$(date +%F).sql'$$); i've searched evrywhere in the web and stuck any help would be amazing, thank you

[@EMultiSkillsDatabaseServices]

Did you check the permission at os level and also it it working as expected through cronjob?

[@EMultiSkillsDatabaseServices]

Did you try with permissions

[@ricardochavarriafdz5928]

@@EMultiSkillsDatabaseServices ERROR: syntax error at or near "pg_dump" LINE 1: pg_dump -d mydb -n borrame > schema.sql

[@jakajhah-0]

Did you find the answer?

[@jakajhah-0]

You need to ensure that pg_hba has trust authentication for this that solved my issue