I'm a newbie in Postgre and I have this Python Script which convert my excel file into a PD dataframe. After, the data is send into my PostgreSQL Database.
.....
engine =…
I'm new to pgAgent, and trying to set up a job that will export a file every 5 minutes (just for testing; once I have the syntax down it'll be dispersed to numerous jobs). The below test code works fine when I run it in a query editor, however…
Hi I started to explore pgAgent recently. Installation and testing had been done. However, there is one thing that bothers me about pgAgent. the thing will only run either SQL or batch code.
Suppose, in my database table contains different week…
When I use postgres, the job works, but when I use ydz2, the job doesn't work:
Couldn't get a connection to the database
Both of them are my local database.
Job Step
Job Step Statistics
Where should I configure it?
Thank you.
I am a month “old” in Postgresql. I try to combine the listen/notify events with asp.net. But I can't find any good examples. This one was the closest I could find, http://www.codeguru.com/columns/dotnet/postgres-tricks-in-.net.html. But I still…
I've installed pgAgent in our PostgreSQL database for scheduling our jobs, which really works like a charm!
However, after I restored a backup from our database in a test server, pgAgent simply won't launch. Interestingly enough, it seems that…
I have create a job via pgadmin in postgres. This is a test system. How can I export this job to a database on other computer (productive system)?
Greets
Benjamin
I have to lock users who don t work in the previous three months.
I'm very newbie!
I looked at the documentation and I do nt think I can do this by configuration.
(Is it true?)
So I have to develop a daily procedure ( with pgagent?) ,make a query…
Using postgres 9.5.5 on osx Sierra 10.12.1
The database & pgAdmin 4 (version 1.1) work fine, but when trying to save tables or take backups from pgAdmin (selecting data: YES), nothing is saved. The files are just not created.
The only feedback on…
How setup pgAgent step so Result or Output show the number of rows processed on my function?
my function already return the number of rows affected, but that isnt the value show in Result.
BEGIN
WHILE int_pending > 0 LOOP
.....…
I have created a job with steps, but when I click on "Run Now" in pgAdmin, nothing happens. Has anyone encountered and resolved this? Below is a screenshot for some details
my pgpass.conf
pgpass.conf
property
when I check the statistics, I have…
I installed pgagent using EnterpriseDB's installer on MacOS. However, pgagent doesn't show up in pgadmin after the installation. Even when I try to manually add pgagent as an extension, I get the error: extension "pgagent" is not available and that…
I'm trying this one more time:
I have an installation of PostgreSQL 12 on my local Windows machine. I have a database set up, and I have installed PG Agent. I can see also see PG Agent in PG Admin, and I've set up jobs with steps. Everything…
Good afternoon.
Red Hat 8.7.
Postgresql Pro Standard 14.8.
When execute:
pgagent_14 hostaddr=127.0.0.1 dbname=postgres user=postgres port=5432 password=somepassword
Error:
WARNING: Couldn't create the primary connection
Password checked in…
