time server - Search results in mailing lists
Mailing lists >> pgsql-admin >> Thread
2025-04-27 01:54:18 | Re: Intermittent missing chunk ERRORS (Sbob)
time when they informed me about the error they sent the select statement throwing the error and once I logged in I ran their select statement and it worked, no REINDEX had been
Mailing lists >> pgsql-admin >> Thread
2025-03-14 14:54:07 | PostgreSQL Memory consumption is too high (Siraj G)
Server spec: 16 vcpu and 128GB Consistently, CACHE % is 59 - 60% and USAGE is around 39 - 40%. Therefore we have just around 0.5% free available memory. I ran queries to get shared_buffers and other
Mailing lists >> pgsql-admin >> Thread
2025-02-26 22:06:49 | Super user password explicit in patroni yml (kamal deen)
server level. If we change the super user password at DB level should we update the same in patroni yml every time
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 19:07:43 | Re: Does export operation cancel SQLs? (Jeff Janes)
server process". So not a "user request". Most likely some client (or client library) has an internal timer
Mailing lists >> pgsql-admin >> Thread
2025-02-11 20:12:41 | FW: Adding Postgres Repository on Red Hat 9 causes SELinux Warnings "SELinux is preventing /usr/bin/gpg (Janet Einhorn)
Server. On some of these VMs, I installed only the Postgres-12 client: # sudo dnf install postgresql12.x86_64 Installation of the Postgres Repository RPM causes the following file, shown here with the security context. I noticed
Mailing lists >> pgsql-admin >> Thread
2025-02-08 07:45:19 | Seeking Advice: postgreSQL Major Version upgrade for pgpool-II and streaming replication setup (Motog Plus)
server upgradation, new version installation on standby, data copy from primary to standby should we then create the replication slot on primary and setup the streaming replication the same way as was done earlier - creating
Mailing lists >> pgsql-admin >> Thread
2025-02-07 12:38:06 | etcd failed on master node (daur exp)
Server. Feb 06 14:31:50 prod-pgsql01-uv01. systemd[1]: etcd.service: Consumed 1.668s CPU time
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))
Servers). But I don’t have the documentation to share – one I don’t have it. Two, even if I have it I can’t share it due to company policy. In a high level
Mailing lists >> pgsql-admin >> Thread >> Search in thread (3)
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: 1. Logical replication into a new Patroni cluster. That is not simple. 2. Following the steps
Mailing lists >> pgsql-admin >> Thread
2024-12-20 15:23:34 | Troubleshooting - PostgreSQL Session CPU Analyze (SOzcn)
time DESC LIMIT 30; When I attempt to log this query, it will only provide statistical responses, meaning the differences will not yield 100% accurate results on the actual server
Mailing lists >> pgsql-admin >> Thread
2024-12-17 17:41:33 | Re: Postgres upgradation (Ron Johnson)
time. Since pg_dump can be performed online, test the process beforehand. I'd bet that your app servers
Mailing lists >> pgsql-admin >> Thread
2024-12-14 21:28:55 | Why might it take so long to start up a cleanly-stopped instance? (Ron Johnson)
time. $ pg_ctl stop -wt9999 && pg_ctl start -wt9999 waiting for server to shut down
Mailing lists >> pgsql-admin >> Thread
2024-12-08 16:32:48 | Re: Postgres compatibility with RHEL (Shawn McKee)
server.x86_64 - (version 15.10-1PGDG) You can get the repos set up on CentOS 7 via: yum --disablerepo=* -y install https:///pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm We then upgraded the CentOS 7.9 system using the --link option
Mailing lists >> pgsql-admin >> Thread
2024-11-22 06:46:14 | Re: Guidance Needed for PostgreSQL Upgrade from 12 to 15 (Ron Johnson)
server, 1. "pg_dumpall -h $OldServer --globals > globals.sql" to get the roles, etc. Will need to remove the "postgres" role. 2. "pg_dump -h $OldServer -j$Threads -Fd $DB ..." for each database. 3. psql