Re: Is there a guide to use PostgresSQL as alternative to MariaDB/MySQL in OpenStack?

2022-11-04 Thread Tony Shelver
On Sat, 5 Nov 2022 at 01:15, Larry Sevilla wrote: > Hi, > > I'm studying OpenStack Zed using Ubuntu 22.04 with the following guides: > > https://docs.openstack.org/install-guide/ > > And I have successfully installed OpenStack services and tested Horizon. > > > But the guide uses MariaDB/mysql. >

Re: Setting up replication on Windows, v9.4

2022-11-04 Thread Ron
On 11/4/22 17:59, Brad White wrote: I'm setting up a backup for our primary postgres server using the archived WAL files. Then I'll try to upgrade it to Streaming Replication. Then I'll upgrade the system to v.latest. For now, we are on v.9.4. FYI: v9.4 has been EOL for 2 years 9 months.   (An

Re: Setting up replication on Windows, v9.4

2022-11-04 Thread Ian Lawrence Barwick
2022年11月5日(土) 10:02 Ian Lawrence Barwick : > > 2022年11月5日(土) 7:59 Brad White : ... > > Interestingly, the recovery file says > > # Note that recovery.conf must be in $PGDATA directory. > > # It should NOT be located in the same directory as postgresql.conf > > Those seem contradictory. > > I don't

Re: Setting up replication on Windows, v9.4

2022-11-04 Thread Ian Lawrence Barwick
2022年11月5日(土) 7:59 Brad White : > > I'm setting up a backup for our primary postgres server using the archived > WAL files. > Then I'll try to upgrade it to Streaming Replication. > Then I'll upgrade the system to v.latest. > For now, we are on v.9.4. > > I do a base backup from the primary to a d

Is there a guide to use PostgresSQL as alternative to MariaDB/MySQL in OpenStack?

2022-11-04 Thread Larry Sevilla
Hi, I'm studying OpenStack Zed using Ubuntu 22.04 with the following guides: https://docs.openstack.org/install-guide/ And I have successfully installed OpenStack services and tested Horizon. But the guide uses MariaDB/mysql. https://docs.openstack.org/install-guide/environment-sql-database-ub

Setting up replication on Windows, v9.4

2022-11-04 Thread Brad White
I'm setting up a backup for our primary postgres server using the archived WAL files. Then I'll try to upgrade it to Streaming Replication. Then I'll upgrade the system to v.latest. For now, we are on v.9.4. I do a base backup from the primary to a directory on the NAS. "C:\Program Files\Po

Re: Unable to use pg_verify_checksums

2022-11-04 Thread shashidhar Reddy
Thank you Guillaume! On Fri, 4 Nov, 2022, 12:49 pm Guillaume Lelarge, wrote: > Hi, > > Le ven. 4 nov. 2022 à 07:12, shashidhar Reddy < > shashidharreddy...@gmail.com> a écrit : > >> Hello, >> >> I am using postgres version 11, in the process of upgrade >> using pg_upgrade I am trying to run chec

AW: Reducing bandwidth usage of database replication

2022-11-04 Thread Sascha Zenglein
I have set the status interval to 600s and it still sends a status message every 30s. I also tried setting every available option higher, with no success: checkpoint_warning = 93s max_standby_streaming_delay = 130s max_standby_archive_delay = 45s wal_receiver_status_interval = 600s wal_receiver_t

Re: Reducing bandwidth usage of database replication

2022-11-04 Thread Simon Riggs
On Thu, 3 Nov 2022 at 15:28, Ben Chobot wrote: > I want to use the postgres-native logical replication to have multiple > clients receive and send data to a central database. > Real-time is far less important than network usage, and with my current test > setup it appears both instances communi

Calculating average block write time

2022-11-04 Thread Thomas Kellerer
I can easily calculate the average block read time using pg_stat_database and divide blk_read_time by blks_read. While there is a column blk_write_time, it seems that there is no cummulative measure for the total number of blocks written. Am I missing something, or is this simply not tracked (a

Re: Reducing bandwidth usage of database replication

2022-11-04 Thread Simon Riggs
On Thu, 3 Nov 2022 at 08:40, Sascha Zenglein wrote: > It is, unfortunately, too much for our requirements. > I was able to increase wal_receiver_status_interval so that the publisher > only contacts the subscriber every 30 seconds instead of every 10. > But I am not able to increase it further. >

Re: Some questions about Postgres

2022-11-04 Thread Laurenz Albe
On Thu, 2022-11-03 at 10:42 -0700, Christophe Pettus wrote: > > On Nov 3, 2022, at 10:38, Siddharth Jain wrote: > > I read an old article comparing MySQL to Postgres and wanted to get answers > > to following questions. > > Given your questions, I suspect that you read the technical note from U

Re: autovacuum hung on simple tables

2022-11-04 Thread Laurenz Albe
On Fri, 2022-11-04 at 02:50 +, senor wrote: > I'm still trying to get a better understanding of the autovacuum process. > This is a different postgres installation as my previous posts and confusing > me in new ways. > Still 11.4 running on CentOS 7 and 8 nvme in software raid Not good. Tha

How to avoid intstantiating multiple JVM instances across different sessions to use FDW?

2022-11-04 Thread 王刚
Hi there, I am recently implementing a new FDW, which would internally instantiate a JVM instance to invoke JNI calls, and the JVM instance would be created in a session when a new query that hit the foreign table comes. I notice for each session, PG would fork a new process. While the JVM insta

Re: Unable to use pg_verify_checksums

2022-11-04 Thread Guillaume Lelarge
Hi, Le ven. 4 nov. 2022 à 07:12, shashidhar Reddy a écrit : > Hello, > > I am using postgres version 11, in the process of upgrade using pg_upgrade > I am trying to run checksums on version 11 but getting error > > pg_verify_checksums: data checksums are not enabled in cluster > > when trying to