bsislow
bsislow
we are simply attempting to extract the DDL from mysql in order to migrate an application to postgres. we are getting the following error for many tables: `ERROR Database error...
Consider integrating this functionality into the agent page under Activity so we can drill down and see the plan of active sessions: https://github.com/cybertec-postgresql/pg_show_plans
we're seeing strings of truncates waiting on other statements and so forth like such: ``` 2022-04-21 11:04:48 CDT [2280]: [1-1] user=temboard,db=temboard,app=temboard,client=[local] LOG: duration: 12014.963 ms statement: SELECT * FROM aggregate_data_single('metric_locks',...
How do we remove the check for "Streaming replication connection" after a cluster has been switched over into a primary? It shows as the following whether enabled or disabled: ...
Deleting an instance was taking a very long time. I reviewed foreign keys and came up with these recommendations to speed up the dependent removals. I recommend these for a...
we have 48 instances in our postgres farm for a given region. it's painful to go through each instance and modify the threshold for a given check for each one....
we noticed that temboard-agent is writing to `/var/log/temboard-agent/...log` _and_ `/var/log/messages`. is there a way to suppress writing to `/var/log/messages`? thanks.
we have a busy instance (regularly ~1300 TPS; INSERT-heavy) where we occasionally see the following in Chrome on the _Activity_ tab/page:  reloading the page fixes the issue for some...
when a job such as this runs, and `nodename` is bad (for example, it can also happen with `database` or `username` i believe), `cron.job_run_details` does not record a start or...
**Versions used:** PostgreSQL: 15.1 pg_cron: `pg_cron_15-1.4.2-1.rhel7.x86_64` when setting `cron.timezone` in our `postgresql.conf` file to any of the following: ``` US/Central CDT CST ``` ... a test job does not run...