PostgreSQL general set of Questions.

2021-08-08 Thread A Z
1) Are there free scripts for CREATE TYPE (native type), more advanced, or sorts of types out there, online, free for commercial use? With function support, too? Can someone reply with a link or a suggestion? 2) How may I get PostgreSQL to output the create table statement(s) for one or more

Re: autovacuum worker started without a worker entry

2021-08-08 Thread Ninad Shah
Most probably, it runs a wraparound process, however, if you may see what command was invoked by that worker, it would be helpful. Regards, Ninad Shah On Mon, 9 Aug 2021 at 01:48, Luca Ferrari wrote: > On Thu, Aug 5, 2021 at 6:27 PM Vijaykumar Jain > wrote: > > postgres/varsup.c at master · p

Re: JWT decoder

2021-08-08 Thread Masih Tavassoli
That was not the question, the question is how do you decode base64url (not base64) in postgres sql? On Monday, August 9, 2021, 02:08:44 PM GMT+10, rob stone wrote: Hello, On Mon, 2021-08-09 at 02:16 +, Masih Tavassoli wrote: > Hi experts, > > I am trying to find a way to decode

Re: JWT decoder

2021-08-08 Thread Masih Tavassoli
There are lots of decoders but I need to do it within postgresql. On Monday, August 9, 2021, 01:24:33 PM GMT+10, Mladen Gogala wrote: You could probably use Pl/Python. Python has base64 module and urllib module which can deal with all URL strings I am aware of.  Pl/Perl would probabl

Re: JWT decoder

2021-08-08 Thread rob stone
Hello, On Mon, 2021-08-09 at 02:16 +, Masih Tavassoli wrote: > Hi experts, > > I am trying to find a way to decode a URL request header and extract > its JSON fields in postgreql . > > I can do this in Oracle sql using  > > select    (utl_raw.cast_to_varchar2 (utl_encode.base64_decode( > ut

Re: JWT decoder

2021-08-08 Thread Mladen Gogala
You could probably use Pl/Python. Python has base64 module and urllib module which can deal with all URL strings I am aware of. Pl/Perl would probably do as well. On 8/8/21 10:16 PM, Masih Tavassoli wrote: Hi experts, I am trying to find a way to decode a URL request header and extract its J

JWT decoder

2021-08-08 Thread Masih Tavassoli
Hi experts, I am trying to find a way to decode a URL request header and extract its JSON fields in postgreql . I can do this in Oracle sql using  select    (utl_raw.cast_to_varchar2 (utl_encode.base64_decode( utl_raw.cast_to_raw (regexp_replace ( ( 'eyJhbGciOiJSUzI1NiIsImtpZCI6InBhLWFwaS1zaWdu

Re: autovacuum worker started without a worker entry

2021-08-08 Thread Luca Ferrari
On Thu, Aug 5, 2021 at 6:27 PM Vijaykumar Jain wrote: > postgres/varsup.c at master · postgres/postgres (github.com) > I think, this block when it is about to assign the next xid, it does the > math, and triggers an autolauncher start. > I might be wrong, I did not run a backtrace though :) > >

Re: pgcrypto - real life examples to encrypt / decrypt

2021-08-08 Thread Luca Ferrari
On Fri, Aug 6, 2021 at 8:27 PM Reid Thompson wrote: > > someone mentioned an alternative earlier that they couldn't remember -- i > think it may have been pgsodium that they were thinking of > https://github.com/michelp/pgsodium > Yes, thanks. For some reason I was remembering "selenium" someth

max_worker_processes - Check How Many Worker Processes are Currently Active

2021-08-08 Thread Avi Weinberg
Hi, Is it possible to check how many worker processes and logical replication workers are currently running I would like to find out how close I'm to the max limit. max_logical_replication_workers max_worker_processes Thanks IMPORTANT - This email and any attachments is intended for the abov

Re: Test mail for pgsql-general

2021-08-08 Thread Bikal Gurung
Hi, I am running rocky-linux 8.4. I have successfully added the yum repo as specified at https://www.postgresql.org/download/linux/redhat/ . However, whenever I do `yum -q -C list` I always get the following error, Importing GPG key 0x442DF0F8: Userid : "PostgreSQL RPM Building Project " Fi