Re: Enterprise Active Directory Authentication?

On Wed, 2021-03-24 at 22:26 +, Hilbert, Karin wrote: > Is it possible to allow connections from [active directory] groups instead of > individual accounts & if so, > can you tell me how the config files would be changed to allow it? The authentication is no problem, but you need to create th

Enterprise Active Directory Authentication?

I manage a PostgreSQL database cluster - PostgreSQL v12.4. Our database cluster is on a Linux VM, with OS: Flavor: redhat_7 Release: 3.10.0-1160.15.2.el7.x86_64 We have a repmgr cluster of 1 Primary & 2 Standby servers & use another server with PgBouncer to direct the connections to the curre

Re: Hello - About how to install PgAdmin4 on Debian 10

On 3/24/21 1:17 PM, Carlos Montenegro wrote: Yes Ray, I followed those instructions, but it seems the repository location changed. It is not available, but thank you so much for your support. It worked for me using the instructions listed here(per Ray's post): https://www.pgadmin.org/download

Re: Hello - About how to install PgAdmin4 on Debian 10

On 24/03/2021 20:17, Carlos Montenegro wrote: Yes Ray, I followed those instructions, but it seems the repository location changed. It is not available, but thank you so much for your support. It seems to be available for me: $ sudo apt update [] Hit:10 https://ftp.postgresql.org/pub/pg

Re: Hello - About how to install PgAdmin4 on Debian 10

Yes Ray, I followed those instructions, but it seems the repository location changed. It is not available, but thank you so much for your support. Best, Carlos On Wed, Mar 24, 2021 at 1:55 PM Ray O'Donnell wrote: > On 24/03/2021 19:08, Carlos Montenegro wrote: > > Hello dear Ray. > > Thanks for

Re: Hello - About how to install PgAdmin4 on Debian 10

Hello dear Ray. Thanks for your answer. Yes, I see pgadmin4 and then tried, but any success. How did you make the installation? Any advice? Best, Carlos On Wed, Mar 24, 2021 at 12:36 PM Ray O'Donnell wrote: > On 24/03/2021 17:17, Carlos Montenegro wrote: > > Hello dear community. > > your hel

Re: Hello - About how to install PgAdmin4 on Debian 10

On 24/03/2021 19:08, Carlos Montenegro wrote: Hello dear Ray. Thanks for your answer. Yes, I see pgadmin4 and then tried, but any success. How did you make the installation? Any advice? Hi Carlos, I had forgotten - pgAdmin has its own apt repository, which you need to add: https://www.pgadmi

Re: Hello - About how to install PgAdmin4 on Debian 10

On 24/03/2021 17:17, Carlos Montenegro wrote: Hello dear community. your help ! I am trying to install PgAdmin4 on Debian 10 following the instructions on here: https://wiki.postgresql.org/wiki/Apt but when execute: > sudo apt-get install pgadmin4 or >

Hello - About how to install PgAdmin4 on Debian 10

Hello dear community. your help ! I am trying to install PgAdmin4 on Debian 10 following the instructions on here: https://wiki.postgresql.org/wiki/Apt but when execute: > sudo apt-get install pgadmin4 or > sudo apt-get install pgadmin4 pgadmin4-apache2 the system says: The package pgadmin4 does

Re: ERROR: could not attach to dynamic shared area

Am 24.03.21 17:09 schrieb(en) Laurenz Albe: > > ERROR: could not attach to dynamic shared area > > LOG: background worker "parallel worker" (PID 51151) exited with exit code 1 ​ Is that repeatable? No, it isn't. I'm running PGSql 13 since ~4 Months (cluster upgraded from v. 10), and updated t

Re: ERROR: could not attach to dynamic shared area

Laurenz Albe writes: > On Wed, 2021-03-24 at 09:01 +0100, Albrecht Dreß wrote: >> in the logs of my database server, I found the following message: >>> ERROR: could not attach to dynamic shared area >>> LOG: background worker "parallel worker" (PID 51151) exited with exit code 1 > ... it could be

Re: ERROR: could not attach to dynamic shared area

On Wed, 2021-03-24 at 09:01 +0100, Albrecht Dreß wrote: > in the logs of my database server, I found the following message: > > > ERROR: could not attach to dynamic shared area > > LOG: background worker "parallel worker" (PID 51151) exited with exit code 1 Is that repeatable? If yes, it would b

Re: No enough privileges for autovacuum worker

On 3/24/21 1:16 AM, Андрей Сычёв wrote: I finally figured out how to tackle the problem: 1. When I manually execute ANALYZE on the table the error remains: [34938]-[192.168.67.81]-[DBeaver 7.3.2 - SQLEditor ]-[client backend]-[42501]-[postgres@fpdb] CONTEXT: SQL function "trigrams_vector" dur

Re: need clarification on CTE/join

Got it :-) thanks ! Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Wed, Mar 24, 2021 at 4:21 AM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Tuesday, March 23, 2021, Marc Millas wrote: > >> Hi, >> >> I cannot agree. >> I did an explain analyze with and without the

Re: No enough privileges for autovacuum worker

I finally figured out how to tackle the problem: 1. When I manually execute ANALYZE on the table the error remains: [34938]-[192.168.67.81]-[DBeaver 7.3.2 - SQLEditor ]-[client backend]-[42501]-[postgres@fpdb] CONTEXT: SQL function "trigrams_vector" during inlining [34938]-[192.168.67.81]-[DBe

ERROR: could not attach to dynamic shared area

Hi all, in the logs of my database server, I found the following message: ERROR: could not attach to dynamic shared area LOG: background worker "parallel worker" (PID 51151) exited with exit code 1 What is the meaning of the error? The box is running Debian Buster, using the official Postgr