Skip to main content

Questions tagged [cron]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
2 answers
38 views

Using pgdump_all and cron

I have a daily cron job to dump my database. Part of the crontab includes the following: 01 01 * * * root /etc/cron.d/backupDaily.sh and part of the backup script contains the following: ...
Manngo's user avatar
  • 2,849
0 votes
0 answers
28 views

Temporary shutdown of autovacuum during rush hour

I have been asked to temporarily disable autovacuum in PostgreSQL 14.3. From 7 a.m. to 5 p.m., autovacuum is to be turned off, and at other times it is to be turned back on. I intend to achieve this ...
Patryk's user avatar
  • 1
0 votes
2 answers
2k views

PostgeSQL Schedule Jobs

I am looking a way that can give the ability to schedule jobs on PostgreSQL, for example to schedule execution of some procedures or statements based on interval or on specific schedule. I tried ...
Stavros Koureas's user avatar
1 vote
0 answers
594 views

Refresh materialized view on Postgresql 11 on RDS

We are currently on Postgres 11.13 on AWS RDS. I am trying to create a materialized view that takes about 6-7 minutes to run. What is the best way to keep this MV mostly up to date? I was thinking of ...
Asif's user avatar
  • 111
3 votes
2 answers
281 views

mysql backup password without root home

What's the best way to provide a MySql root password (~/.my.cnf) to cron job without root to have the home folder? the server I'm using is centos
Rait's user avatar
  • 47
1 vote
0 answers
50 views

Replicating/Inserting 300M MYSQL records from 6 Remote Servers on Local using Unique Identifier

I have 6 remote servers that dial phone numbers daily. I have a total record count of over 300 million combined and now I want to procress on them. The table data looks like this using this query ...
Aun Zaidi's user avatar
-1 votes
1 answer
376 views

How to create a cronjob backup for mysql slave?

There are few other threads about this question using mysqldump but however i tend to not use mysqldump but instead backup the whole files in /mysql. I would like to create a cronjob in mysql slave ...
user avatar
0 votes
0 answers
828 views

Schedule Postgres pg_cron jobs to trigger by something other than Cron expression

I have some pg_cron jobs that run at night time. They basically run some plpgsql Procedures and trigger based off CRON expressions. The problem is that some of my JOBS are dependent on the jobs that ...
XxAemaethxX's user avatar
0 votes
1 answer
1k views

SQL Server create cron job without SQL Server Agent

I'm creating a cron job on SQL Server. As per my knowledge, the only way possible to create a job is through SQL Server Agent. However, the services(listed on services.msc) of VM assigned to me do not ...
Yash's user avatar
  • 13
2 votes
2 answers
7k views

"connection failed" error for pg_cron extension

Installed pg_cron and scheduled job, though there is connection error because job is not done and cron.job_run_details table shows connection failed error message. As doc says: Important: Internally, ...
Oto Shavadze's user avatar
0 votes
1 answer
986 views

Supabase postgres cron job not working special case

I'm having the problem, while insering a row using rpc through the nodejs library, with user service_role. i gave permission to all roles. Without exception. And for service_role I even gave it all ...
Mohamed Allal's user avatar
1 vote
1 answer
904 views

Set crontab backup job for Mariadb Databases from 1 remote server to another [closed]

I'm connecting to a Ubuntu Server remotely using SSH, where are x number of MariaDB databases. Now I want to set a crontab job to automatically create backup for all of them to another server where ...
dan morcov's user avatar
0 votes
0 answers
932 views

pg_cron connection refused with postgres login

I am trying to run a function periodically with pg_cron but every time it wants to execute it throws connection refused. the cron job is created using the postgres user. pg_hba.conf local all ...
user avatar
2 votes
1 answer
115 views

Programming query execution Postgres

I need to execute update querys routinely over a Postgres table. Is it possible to program an automatic execution of the query, let's say, every day at 15:00 hs? The Postgres version is 9.5, I'm ...
guillermo_dangelo's user avatar
1 vote
4 answers
417 views

Integration: Keep two systems in sync

I have a GIS system with 40 tables, ranging from 1,000 to 60,000 rows per table. The tables are the system of record for assets in a municipality. The GIS assets in the tables get integrated to a ...
User1974's user avatar
  • 1,477
-3 votes
2 answers
3k views

Need a shell script that can run a oracle query and produce output in .csv format

Can you please help- need a shell script that will have a oracle query inside it and produce a .csv format output in specific location, that script should be a scheduled in a cron job which runs, the ...
Kilaru Krishna Chaitanya's user avatar
0 votes
1 answer
473 views

cron command running postgres at high cpu [closed]

I can see that a cron command is running under a postgres user and killing the CPU but I have no idea how it's being executed or how to stop it !
Storm's user avatar
  • 121
0 votes
0 answers
182 views

mysqldump writes dumped data to output

I'm trying to bring incremental backups to one old setup. The script I create worked perfectly when run directly. However when I run it from crontab or when redirecting shell output all data is ...
kworr's user avatar
  • 156
0 votes
0 answers
543 views

MySQL pooled connections and crontab jobs (not reusing connections)

I have several cron jobs running and the task that cron has to do is execute a file that in turn checks and compares crawled data with data in the database, if it exists then the script ends and if it ...
MartinJJ's user avatar
  • 101
2 votes
1 answer
2k views

Query to delete all rows which are not referenced in any other tables

Let's say i have a table called images. Images table is referenced in many other tables (movies, books, tv_series) through a foreign key. My question is if it is possible to write a query which will ...
Daniel G's user avatar
0 votes
1 answer
965 views

MongoDB scripts triggered by cron - how to achieve reasonable password security

We would like to do nightly purging of old data out of our mongo cluster. First thought is to write shell script which connects to one of the mongos and issues a remove instruction. evalString='db.fs....
ubienewbie's user avatar
5 votes
1 answer
2k views

Passwordless mysqldump via shell script in /etc/cron.daily

I'm aware that there are dozens of questions similar to this, but it seems none has a definitive answer to my problem, so that's why I'm posting this... I hope in the right place. The problem: I ...
Vila's user avatar
  • 223
5 votes
1 answer
4k views

Pg_cron crontab log issue

We're trying to configure periodic jobs in PostgreSQL. To do this, we have installed on Linux machine, with Postgres 9.6 running, the citusdata pg_cron project. System information: OS: Linux pg 4.4....
Martina Muscariello's user avatar
1 vote
0 answers
42 views

What's the best way to programatically have a MySQL DB update another MySQL DB

I am currently working for a service provider that offers Windows software for inventory control. This software connects to a MySQL DB on a dedicated server. So when this software is updated it ...
lz430's user avatar
  • 11
0 votes
3 answers
207 views

How to avoid server crash during backup of dabase using a crontab [closed]

I'm on shared hosting, so I want to avoid using too much system resources. I have a crontab that schedules a MySQL database backup. The database is about 2gb before compression. When that crontab runs,...
Muhammad's user avatar
1 vote
2 answers
4k views

Routinely deleting aged postgresql rows via cron

I have a Django website with a postgresql 9.3.10 backend. The website contains dynamic user-generated content (think of it as a form of 9gag). There are some tables from which I routinely delete aged ...
Hassan Baig's user avatar
  • 1,979
2 votes
1 answer
4k views

CRON and RMAN Backups

We run RMAN backups via CRON jobs, but find the out-of-the-box emails with CRON to almost do what we want. I know we can channel the RMAN output to /dev/null so no email is sent, which for any ...
John Eisbrener's user avatar
1 vote
1 answer
3k views

How does mysqldbcopy function

I have a database called LIVE and I want to create a scenario were I copy the LIVE database every night at 2:30 am. I want the copied database to be called REPORT. So every night I want the REPORT ...
tase akpobome's user avatar
0 votes
1 answer
615 views

MySQL DB Replication

Okay so here's my scenario. I have two applications that share some tables from the same DB. Let's call them App1 and App2. Lets also assume the DB used here is called DB1. App1 and App2. App1 is on ...
Amjad's user avatar
  • 101
23 votes
3 answers
147k views

Date range query for past 24 hour in Mongo shell

I am setting a cron job to collect results from MongoDB database profiler. I'd like to collect results within a 24 hrs period. I plan to run mongo command with javascript. Question is, in Mongo shell,...
Howard Lee's user avatar
  • 1,019
0 votes
0 answers
173 views

Need to Sync Oracle DB table data with mysql [duplicate]

I have a table with some data in oracle which i want to sync with mysql table once in a day, like a cron job. Is there any tool available which i can use as a cron job in Linux?. Thanks,
serverliving.com's user avatar
1 vote
2 answers
1k views

Are certain environment variables required for mysql login-path?

I created a bash script that backs up my database, db_backup.sh It basically just runs these commands: DB=/home/linuxuser/backups/backupfilename.sql.gz mysqldump --login-path=local db_name | gzip &...
Buttle Butkus's user avatar
1 vote
2 answers
2k views

Sync 8 tables of differents databases on same server

I will use eight wordpress websites and i need to sync ther wp-user tables so each single user can connect through all websites. All of these will be on the same server, using the same MySQL user, but ...
Jacques-Alexandre Bossu's user avatar
0 votes
0 answers
309 views

What is the best way to execute a MySQL script periodically on Linux

I want to execute some SQL everyday in a Linux server using MySQL to UPDATE some column's values. In order to do that I use the UPDATE ... SET ... WHERE ... statement. I want to know which is the ...
william's user avatar
  • 21
2 votes
1 answer
2k views

Prevent postgres function of running more than 1 instance at the same time

DBMS: Postgres 9.3.4 OS: Debian 7 I have a plpgsql function that will be put in crontab to run every 15 minutes. The function should finish in about 8 minutes, but just in case it takes more than 15 ...
Ivan De Sousa Paz's user avatar