śr., 27 lip 2022 o 08:08 hubert depesz lubaczewski
napisał(a):
> On Tue, Jul 26, 2022 at 10:48:47AM -0700, Adrian Klaver wrote:
> > On 7/26/22 9:29 AM, Ron wrote:
> > > On 7/26/22 10:22, Adrian Klaver wrote:
> > > > On 7/26/22 08:15, Rama Krishnan wrote:
> > > > > Hi Adrian
> > > > >
> > > > >
>
On Wed, Jul 27, 2022 at 7:50 AM Wiwwo Staff wrote:
> Since changing ph_hda.conf file to give users access involves the restart
> of server, many companies I work(ed) use a bastion host, where users ssh
> to, and are allowed "somehow" use postgresql.
>
> Still, those users need some login shell.
>
Hi all,
We are investigating a performance issue with searching on a GIN with
gin_trgm_ops indexed column. This specific (organization_id,aggregate_type)
has in total 19K records and the (organization_id) has in total 30K
records. The search record table has in total 38M records.
The table and
Hi,
On Wed, Jul 27, 2022 at 02:49:45PM +0200, Wiwwo Staff wrote:
> Since changing ph_hda.conf file to give users access involves the restart
> of server, many companies I work(ed) use a bastion host, where users ssh
> to, and are allowed "somehow" use postgresql.
You mean pg_hba.conf right? It d
Hi,
Your first sentence is wrong. Changing pg_hba.conf file does not require
server restart. It is enough to reload the configuration using "pg_ctl
reload", "select pg_reload_conf();" in psql or just sending SIGHUP from
linux terminal to postmaster process after changing the pg_hba file.
To achiev
Since changing ph_hda.conf file to give users access involves the restart
of server, many companies I work(ed) use a bastion host, where users ssh
to, and are allowed "somehow" use postgresql.
Still, those users need some login shell.
It would be great to give them psql as a login shell (in /etc/
Based on my initial testing native logical replication seems easier and faster
to setup than pglogical, and may be easier for our team to administer.
One sticking point is monitoring the health of native logical replication.
Are there some native logical replication functions or calls that can, f
