timer database - Search results in mailing lists
Mailing lists >> pgsql-admin >> Thread
2025-04-26 20:09:32 | Intermittent missing chunk ERRORS (Sbob)
database. Today they passed me another error (the one above) and once I was able to login I ran the same query the app team referenced and it ran without any errors. I asked them
Mailing lists >> pgsql-admin >> Thread
2025-04-02 07:55:26 | psql formatting question (Edwin UY)
database to learn PostgreSQL more. I do am looking for a remote job :-) Anyway, on to the question. I am pretty sure the answer will be a NO but maybe it isn't. Are there
Mailing lists >> pgsql-admin >> Thread
2025-03-12 01:41:12 | Re: Any better way to ensure WAL continuity over failovers ? (harinath kanchu)
time is a big bottleneck and sometimes you have to use superuser to get the last few connections reserved, in case the user is bombarding the database
Mailing lists >> pgsql-admin >> Thread
2025-03-09 23:37:20 | Re: Getting out ahead of OOM (Joe Conway)
time I looked. 3. If nothing else, avoid setting a memory.limit on the cgroup. That will at least get you back to not getting whacked unless there is host level memory pressure. The blogs
Mailing lists >> pgsql-admin >> Thread
2025-02-21 02:33:40 | Re: Create a Database or a Schema -- when to do what? (Bruce Momjian)
On Fri, Feb 14, 2025 at 06:26:21AM +0100, Laurenz Albe wrote: This blog
Mailing lists >> pgsql-admin >> Thread
2025-02-20 18:00:35 | May data be corrupted after an interrupted, but afterwards sucessfully replayed recovery? (Dietrich, Benjamin)
time in recovery - and stopped (see logs below [1]). The original problem is solved and the cluster now successfully started an finished recovery. But when I restarted the cluster it HINTed: 2025
Mailing lists >> pgsql-admin >> Thread
2025-02-19 23:46:45 | Re: Does export operation cancel SQLs? (Siraj G)
time: 0:00:30.074 user=postgres database=postgres host=[local]" timestamp: "2025-02-19T05:32:33.042884Z" On Wed, Feb 19, 2025 at 9:38 PM Jeff
Mailing lists >> pgsql-admin >> Thread
2025-02-13 11:11:03 | rolconfig and datconfig (Fabrice Chapuis)
time zone │ │ │ │ │ rolbypassrls │ boolean │ │ │ │ │ => rolconfig │ text[] │ C │ │ │ │ oid │ oid │ │ │ │ └────────────────┴──────────────────────────┴───────────┴──────────┴─────────┘ postgres [591176]=# \d pg_database
Mailing lists >> pgsql-admin >> Thread
2025-01-29 08:40:07 | Re: PID=2299350| 19| LISTEN| PGE-58P01:ERROR: could not access status of transaction 432906091 (Laurenz Albe)
time the signal is delivered, the information about the transaction is already gone. Use shorter database
Mailing lists >> pgsql-admin >> Thread >> Search in thread (2)
2025-01-27 21:28:54 | RE: [EXT] Re: Oracle to postgres migration (Wong, Kam Fook (TR Technology))
time is not sufficient to troubleshoot a challenging problem. 10. Optimizer – good luck. Find some good articles and study them (swim or drown). There a only a handful of stuff you can tweak
Mailing lists >> pgsql-admin >> Thread
2025-01-07 09:57:19 | Re: Advice Needed: Simultaneous Upgrade of Two-Node PostgreSQL 11 Cluster (Laurenz Albe)
time you have to restore your database from a backup. There are two paths you can consider
Mailing lists >> pgsql-admin >> Thread
2024-12-20 15:23:34 | Troubleshooting - PostgreSQL Session CPU Analyze (SOzcn)
time::numeric) OVER ())::numeric, 2) AS cpu_portion_pctg, pss.query, psa.client_addr AS client_host FROM pg_stat_statements pss JOIN pg_database
Mailing lists >> pgsql-admin >> Thread
2024-12-18 19:12:56 | Seeking Recommendations for Oracle to PostgreSQL Synchronization Tools (Henry Ashu)
time and expertise. I look forward to your recommendations. Thank you *Henry Ashu* Database Administrator
Mailing lists >> pgsql-admin >> Thread
2024-12-17 18:07:30 | Re: Postgres upgradation (Ron Johnson)
databases... run pg_dump multiple times. export PGHOST=oldserver pg_dumpall -gvf globals.sql 2> /dev/null
Mailing lists >> pgsql-admin >> Thread >> Search in thread (2)
2024-11-22 06:46:14 | Re: Guidance Needed for PostgreSQL Upgrade from 12 to 15 (Ron Johnson)
database at a time. That's up to you. I would set these config params