Let I first state that I am not a DBA-guy but I do have a question regarding restoring remote databases using PG Admin.
I have this PG Admin tool (v4.27) running in a Docker container and I use this portal to maintain two separate Postgress…
I'm attempting to setup a new postgresql 9.6 installation. I realize this is not the latest version but, due to some third party limitations, it's what I'm required to use.
The installation itself works just fine and I've been able to get my…
I have his query
INSERT INTO public.mb51_helper(
plant)
VALUES ('1826')
;
Every hour. I have setup all everything. PgAgent Service is running in services but it is not executing the query.
I have Postgresql server 12.1 running at Debian 9.11 & I managed the databases with pgadmin 4.18 at the windows client.
Later at the server I installed pgagent:
sudo apt-get update
sudo apt-get install pgagent
I found that pgagent.sql is created…
I have created a database and it is going to have some temporary values such as login type and some hask keys that I want it to be deleted after certain period of time.
I have installed postgres on docker.
I found out a solution through pgagent, but…
I am using centOS 8 and trying to install pgAgent in version 3.4.0 on my server.
What I have done so far:
Successfully installed cmake, cpack, ctest, wxWidgets-3.1.3, wxGTK-2.8.12.
Uninstalled wxWidgets-3.1.3 by using 'make uninstall' after…
I'm trying to schedule a batch file to backup a database on postgres. However, the job gets stuck on status "r" with no indication of what's going on, however a 0kb SQL file is created. When I run the batch file manually, it executes perfectly fine.…
I have installed PgAgent in my suse linux VM from the rpm:
postgresql10-pgagent-4.0.0-2.4.x86_64.rpm
But after resolving dependencies , I and unable to run the pgagent command
Getting the following:
If 'pgagent' is not a typo you can use…
I am creating daily backup scheduler for my PostgreSQL database, For that I installed Pg-agent and also created job scheduler. I have created one .bat file and written script in it which is working fine. What I want that when I am executing .bat bat…
I need to run some SQL scripts (which are basically SELECT queries) every time some new data enters the database.
When I say enters the database, I do not mean INSERT/UPDATE queries executed on an existing database/table(s), but rather every time a…
I want to make a systemd unit for pgagnent.
I found only init.d script on this page http://technobytz.com/automatic-sql-database-backup-postgres.html, but I don't know how to exec start-stop-daemon in systemd.
I have written that…
My company currently applies PostgreSQL 10 and windows server 2008 OS.
I need to run a C wrote calculation program in .exe file each month.
However, it is not perfect to double click and run it every month. Furthermore, I would like to be able to…
I am trying to install pgAgent. I have installed greenplum. Have't install postgres separately. I am using pgAdmin3. I have downloaded the pgagent3.4.0.
When I am running this pgagent.sql file in windows, its redirecting to pgAdmin3 to install the…
On one of our servers pgAgent service does not start with the message "ERROR: Couldn't register event handle" (see DBA Question). So I decided to compile the binary from the source, to further investigate the problem.
I installed Visual Studio…
