Re: Does PGDG apt repository support ARM64?

2022-03-31 Thread Daniele Varrazzo
> On 3/31/22 18:22, Daniele Varrazzo wrote: > > Are arm packages available at all? If so, what is the right procedure > > to install them? On Fri, 1 Apr 2022 at 06:07, Adrian Klaver wrote: > > From here: > > https://apt.postgresql.org/pub/repos/apt/dists/ > > I see them in Debian: > > Buster on

Re: Does PGDG apt repository support ARM64?

2022-03-31 Thread Daniele Varrazzo
Uhm... I'm not practical with apt repos, but, in the Release file, Buster has: ``` Origin: apt.postgresql.org Label: PostgreSQL for Debian/Ubuntu repository Suite: buster-pgdg Codename: buster-pgdg Date: Tue, 29 Mar 2022 13:35:36 UTC Architectures: amd64 arm64 i386 ppc64el ``` whereas Stretch h

Re: Does PGDG apt repository support ARM64?

2022-03-31 Thread Adrian Klaver
On 3/31/22 18:22, Daniele Varrazzo wrote: Hello, Psycopg binary files are built on Debian Stretch images. I have noticed that, on arm64 platforms, even if the pgdg apt repository is configured, apt-get will install libpq 9.6 (from the Debian repository), not the 14 available in pgdg. As a result

Does PGDG apt repository support ARM64?

2022-03-31 Thread Daniele Varrazzo
Hello, Psycopg binary files are built on Debian Stretch images. I have noticed that, on arm64 platforms, even if the pgdg apt repository is configured, apt-get will install libpq 9.6 (from the Debian repository), not the 14 available in pgdg. As a result, certain features are not available on psyc

Locking a table read-only temporarilty

2022-03-31 Thread Digimer
Hi all,   I've been looking up locking, and perhaps I'm being dense, but I'm struggling to figure out how to create a lock to make a table read-only for a short period of time.   I want to set a table to be read-only, so that any other clients that try to UPDATE

Re: PG12: Any drawback of increasing wal_keep_segments

2022-03-31 Thread Stephen Frost
Greetings, On Thu, Mar 31, 2022 at 12:58 Marc wrote: > On 29 Mar 2022, at 17:17, Stephen Frost wrote: > > Greetings, > >- Alvaro Herrera (alvhe...@alvh.no-ip.org) wrote: > > On 2022-Mar-22, Shukla, Pranjal wrote: > > Are there any disadvantages of increasing the “wal_keep_segments” to a > hi

Re: PG12: Any drawback of increasing wal_keep_segments

2022-03-31 Thread Marc
On 29 Mar 2022, at 17:17, Stephen Frost wrote: Greetings, * Alvaro Herrera (alvhe...@alvh.no-ip.org) wrote: On 2022-Mar-22, Shukla, Pranjal wrote: Are there any disadvantages of increasing the “wal_keep_segments” to a higher number say, 500? Will it have any impact on performance of streamin