Re: Connection error to new pg15 instance

I suspect it may have something to do with ssl. The FATAL error in the log said "no encryption". I'm not sure what that means. When I look at a connection to one of our pg14 instances from the same API server, I see this in the logs: 2023-06-04 00:03:06.210 UTC,"b2bc_api","b2bcreditonline",16024,"

Re: Interconnected views

On Fri, Jun 2, 2023 at 9:36 AM Oliver Kohll wrote: > Hi, > > Just wondering, does anyone else create apps which might not have 'big' > data, but quite complex arrangements of views joining to each other? > > If so, do you have scripts to aid refactoring them e.g. drop/recreate/test > them in the

Re: Can't send mail to `pgsql-zh-gene...@lists.postgresql.org`

Sure, I subscribe it, and let it send me a test mail. Yours, Wen Yi -- Original -- From: "Adrian Klaver"

Re: Can't send mail to `pgsql-zh-gene...@lists.postgresql.org`

On 6/3/23 18:46, Wen Yi wrote: Hi team, I want to use the `pgsql-zh-gene...@lists.postgresql.org` mail list, and I send a test mail to it. But my mail box told me that my mail was be returned: host makus.postgresql.org[72.32.157.229] said: 550 This message was classified as SPAM (in reply to

Can't send mail to `pgsql-zh-gene...@lists.postgresql.org`

Hi team, I want to use the `pgsql-zh-gene...@lists.postgresql.org` mail list, and I send a test mail to it. But my mail box told me that my mail was be returned: host makus.postgresql.org[72.32.157.229] said: 550 This message was classified as SPAM (in reply to end of DATA command) Can

Connection error to new pg15 instance

Hi all, I'm in the process of migrating from an RDS pg14 instance to pg15.3. As part of the migration process, the application code makes a test connection to the new instance. This failed. I tried manually connecting to the kube pod where the test query was submitted from, and from there was able

Re: How to remove user specific grant and revoke

> On 04/06/2023 00:08 CEST Andrus wrote: > > > Should I ran separate revoke commands for every user to remove those > > revokes ? > > How to remove user-spefic grants ? > After running revoke commands in psql, GRANT commands disappeared magically. > It looks like pgAdmin does not allow execute REV

Re: How to remove user specific grant and revoke

> On 03/06/2023 23:34 CEST Andrus wrote: > > psql (12.2 (Debian 12.2-2.pgdg100+1)) > Type "help" for help. > > sba=# REVOKE ALL ON public.kaspriv FROM alekspoluh; > REVOKE > sba=# \o result.txt > sba=# \dp public.kaspriv > > sba=# \q > #grep alekspoluh result.txt > Returns nothing. So output

Re: How to remove user specific grant and revoke

Hi! Should I ran separate revoke commands for every user to remove those revokes ? How to remove user-spefic grants ? After running revoke commands in psql, GRANT commands disappeared magically. It looks like pgAdmin does not allow execute REVOKO commands. After running script which add

Re: How to remove user specific grant and revoke

Hi! After this command pgAdmin still shows revoke and grant commands for alekspoluh role. How to remove all grant and revoke assignments for role ? Please confirm that \dp public.kaspriv no longer shows an ACL for alekspoluh after running: REVOKE ALL ON public.kaspriv FROM alekspoluh;

Re: How to remove user specific grant and revoke

> On 03/06/2023 22:33 CEST Andrus wrote: > > I tried > alter role alekspoluh reset all This only resets role-specific settings, not privileges. > After this command pgAdmin still shows revoke and grant commands for > alekspoluh role. > How to remove all grant and revoke assignments for role ? P

Re: How to remove user specific grant and revoke

Hi! I tried alter role  alekspoluh reset all After this command pgAdmin still shows revoke and grant commands for alekspoluh  role. How to remove all grant and revoke assignments for role ? Andrus. 03.06.2023 20:50 Andrus kirjutas: Hi! > REVOKE must be executed by the grantor (sba_owne

Re: How to remove user specific grant and revoke

> On 03/06/2023 18:14 CEST Andrus wrote: > > > Or just execute those REVOKE ALL commands (except for PUBLIC) that pgAdmin > > already gives you. > pgAdmin gives > REVOKE ALL ON TABLE public.kaspriv FROM someuser; > I ran it but pgAdmin still gives this statement. What are the current table privil

Re: How to remove user specific grant and revoke

Hi! Or just execute those REVOKE ALL commands (except for PUBLIC) that pgAdmin already gives you. pgAdmin gives REVOKE ALL ON TABLE public.kaspriv FROM someuser; I ran it but pgAdmin still gives this statement. Andrus.

Re: Number of dashes in the expanded view of psql

On 6/3/23 03:12, Rajiv Harlalka wrote: Hello,      While watching results of some internal tables in pg , looked that the number of dashes between records depends on the char length of the longest column (referring to dashes here -[ RECORD 1 ]-). Wouldn't it be better to have a bet

Re: custom background worker task for \copy?

Thanks. Yes, an option. Was considering that as well. Joe > On Jun 2, 2023, at 9:41 PM, Laurenz Albe wrote: > > On Fri, 2023-06-02 at 11:36 -0700, Joe Carlson wrote: >> I have SQL that does it with \copy (select * from where…) … And that >> is fine. >> But it would be nice to be able to run

Re: pg_upgrade and schema complexity...

On 6/2/23 21:22, Adrian Klaver wrote: On 6/2/23 18:06, Ron wrote: On 6/2/23 19:58, Adrian Klaver wrote: On 6/2/23 17:44, Ron wrote: Ran into this when upgrading from 13.11 to 15.3... The pg_restore phase failed with "ERROR: out of shared memory", and recommended that I increase max_locks_per

Re: How to remove user specific grant and revoke

> On 03/06/2023 14:46 CEST Erik Wienhold wrote: > > > On 03/06/2023 09:16 CEST Andrus wrote: > > > > DROP REVOKE ALL ON TABLE public.kaspriv FROM all EXCEPT public; > > DROP GRANT SELECT ON TABLE public.kaspriv FROM all EXCEPT public; > > > > This will be one-time action. It can be done manually

Re: How to remove user specific grant and revoke

> On 03/06/2023 09:16 CEST Andrus wrote: > > User groups table is defined as > > CREATE TABLE IF NOT EXISTS public.kaspriv > ( > id serial primary key, > user character(10) NOT NULL, > group character(35) NOT NULL > ... > ) > > There are hundreds of users. Earlier time grant and revoke commands we

Number of dashes in the expanded view of psql

Hello, While watching results of some internal tables in pg , looked that the number of dashes between records depends on the char length of the longest column (referring to dashes here -[ RECORD 1 ]-). Wouldn't it be better to have a better method for number of such dashes as for

No Greek stop words in FTS ?

Hi, I maintain a project (diofanti.org ) that tracks public spending in Greece. It’s a PG instance hosting 55M+ json documents with searching functionality on top of them. It relies heavily on to_tsvector(‘greek’, ..), as users search for company names, invoice descriptio

How to remove user specific grant and revoke

User groups table is defined as     CREATE TABLE IF NOT EXISTS public.kaspriv     (     id serial primary key,     user character(10) NOT NULL,     group character(35) NOT NULL     ...     ) There are hundreds of users. Earlier time grant and revoke commands were executed for every