Re: WAL Archiving and base backup

2022-01-12 Thread Issa Gorissen
Thx a lot. I thought about it but was not so sure about having a complex script (compared to the very simple version when using the exclusive backup - but this this is deprecated...). I will test your option with the simpler version and post it back to it can maybe land in PostgreSQL documenta

Re: WAL Archiving and base backup

2022-01-12 Thread Torsten Förtsch
On Wed, Jan 12, 2022 at 1:22 PM Issa Gorissen wrote: > So I have this question, how to script the making of base backup for > transfer on the slave server when the two SQL functions must be called > in the same connection, in Bash for example; is this doable? > Not sure if I understand the probl

Re: Unable to migrate from postgres-13 to 14

2022-01-12 Thread Tom Lane
Jasvant Singh writes: > pg_restore: error: could not execute query: ERROR: function > array_append(anyarray, anyelement) does not exist > Command was: CREATE AGGREGATE "public"."mode"("anyelement") ( > SFUNC = "array_append", > STYPE = "anyarray", > INITCOND = '{}', > FINALFUNC =

Re: pg_stat_statements

2022-01-12 Thread Simon Riggs
On Wed, 12 Jan 2022 at 13:17, Simon Riggs wrote: > > On Wed, 12 Jan 2022 at 10:31, Julien Rouhaud wrote: > > > > On Wed, Jan 12, 2022 at 10:22:38AM +, Simon Riggs wrote: > > > On Wed, 12 Jan 2022 at 03:03, Julien Rouhaud wrote: > > > > > > > > Unfortunately this is a known limitation. > > >

Re: How to read an external pdf file from postgres?

2022-01-12 Thread Ian Lawrence Barwick
2022年1月12日(水) 20:16 Amine Tengilimoglu : > > Hi; > > I want to read an external pdf file from postgres. pdf file will exist > on the disk. postgres only know the disk full path as metadata. Is there any > software or extension that can be used for this? Or do we have to develop > software

Re: How to read an external pdf file from postgres?

2022-01-12 Thread Дмитрий Иванов
What are you going to do with the data? If you want to analyze it in some way, I can't think of a better option with a Python function. Or do you just want to transfer them? There are options here too, but in this case I like Python better. -- Regards, Dmitry! ср, 12 янв. 2022 г. в 16:16, Amine T

Unable to migrate from postgres-13 to 14

2022-01-12 Thread Jasvant Singh
Hi, I am trying to migrate my database from postgres-13 to 14 but getting following error: pg_restore: error: could not execute query: ERROR: function array_append(anyarray, anyelement) does not exist Command was: CREATE AGGREGATE "public"."mode"("anyelement") ( SFUNC = "array_append", S

Re: pg_stat_statements

2022-01-12 Thread Simon Riggs
On Wed, 12 Jan 2022 at 10:31, Julien Rouhaud wrote: > > On Wed, Jan 12, 2022 at 10:22:38AM +, Simon Riggs wrote: > > On Wed, 12 Jan 2022 at 03:03, Julien Rouhaud wrote: > > > > > > Unfortunately this is a known limitation. > > > > I see this as a beneficial feature. > > > > If the same SQL is

Re: postgres event trigger workaround

2022-01-12 Thread Julien Rouhaud
Hi, On Wed, Jan 12, 2022 at 11:57:45AM +, Zwettler Markus (OIZ) wrote: > > PG event triggers are not firing on CREATE ROLE, CREATE DATABASE, CREATE > TABLESPACE by definition (would be nice if they do). > > Is there any workaround to react with ddl_command_start behavior on such an > event?

WAL Archiving and base backup

2022-01-12 Thread Issa Gorissen
Hello all, I've been upgrading some of our PostgreSQL instances from 9.x to 12.x and we're using a master/slave setup based on continuous archiving. I can read on https://www.postgresql.org/docs/12/continuous-archiving.html 25.3.3.2. Making an Exclusive Low-Level Backup that the exclusive me

postgres event trigger workaround

2022-01-12 Thread Zwettler Markus (OIZ)
Hi, PG event triggers are not firing on CREATE ROLE, CREATE DATABASE, CREATE TABLESPACE by definition (would be nice if they do). Is there any workaround to react with ddl_command_start behavior on such an event? Thanks, Markus

Re: How to read an external pdf file from postgres?

2022-01-12 Thread Peter Eisentraut
On 12.01.22 12:16, Amine Tengilimoglu wrote:      I want to read an external pdf file from postgres. pdf file will exist on the disk. postgres only know the disk full path as metadata. Is there any software or extension that can be used for this? Or do we have to develop software for it?  Or w

How to read an external pdf file from postgres?

2022-01-12 Thread Amine Tengilimoglu
Hi; I want to read an external pdf file from postgres. pdf file will exist on the disk. postgres only know the disk full path as metadata. Is there any software or extension that can be used for this? Or do we have to develop software for it? Or what is the best approach for this? I'd appr

Re: pg_stat_statements

2022-01-12 Thread Julien Rouhaud
On Wed, Jan 12, 2022 at 10:22:38AM +, Simon Riggs wrote: > On Wed, 12 Jan 2022 at 03:03, Julien Rouhaud wrote: > > > > Unfortunately this is a known limitation. > > I see this as a beneficial feature. > > If the same SQL is executed against different sets of tables, each > with different ind

Re: pg_stat_statements

2022-01-12 Thread Simon Riggs
On Wed, 12 Jan 2022 at 03:03, Julien Rouhaud wrote: > > Hi, > > On Tue, Jan 11, 2022 at 03:04:14PM +, Dirschel, Steve wrote: > > > > I'm not sure if this is the correct distribution list for this type of > > question but I'll try anyways. We have an app that uses multiple schemas. > > It will