Re: function signature allow "default" keyword

On 15.05.23 10:33, jian he wrote: function idea. allow function calling using the default keyword for any of the input arguments. example: https://dbfiddle.uk/FQwnfdmm So something like this "SELECT * FROM customer_orders(2579927, 'order_placed_on DESC', default

Re: "PANIC: could not open critical system index 2662" - twice

On 9/05/2023 3:32 am, Andres Freund wrote: > Attached is a rough prototype of that idea (only using datconnlimit == > -2 for now). > I guess we need to move this to -hackers. Perhaps I'll post subsequent > versions below > https://www.postgresql.org/message-id/20230314174521.74jl6ffqsee5mtug%40awor

How can I change replication slot's restart_lsn from SQL?

Hi, I'm working on a workaround for a bug in Pg (https://www.postgresql.org/message-id/flat/Yz2hivgyjS1RfMKs%40depesz.com) I want to create replication slot, and advance is manually, keeping it always a bit lagging behind real replication slot. I can create slot, no problem: select pg_create_logic

Packed raster data in postgresql?

Hello all, is it possible to store also packed raster data (e.g. jpg, lzw tiff, ...) in PostgreSQL? Thanks & best regards mikeE.

Re:

I works, thank you postgres [429007]=# select pg_xact_commit_timestamp('53013547'); ┌───┐ │ pg_xact_commit_timestamp│ ├───┤ │ 2023-05-15 16:10:00.150823+02 │ └───┘ (1 row) On Tue, May 16, 2023 at 5:25 AM Ki

Re: Packed raster data in postgresql?

On 5/16/23 10:03, Elstermann, Mike wrote: Hello all, is it possible to store also packed raster data (e.g. jpg, lzw tiff, ...) in PostgreSQL? You can store any binary data you want in columns of type "bytea". -- Born in Arizona, moved to Babylonia.

Re: How can I change replication slot's restart_lsn from SQL?

On Tue, May 16, 2023 at 04:23:02PM +0200, hubert depesz lubaczewski wrote: > Hi, > I'm working on a workaround for a bug in Pg > (https://www.postgresql.org/message-id/flat/Yz2hivgyjS1RfMKs%40depesz.com) > I want to create replication slot, and advance is manually, keeping it > always a bit lagging

Re: Packed raster data in postgresql?

Hi út 16. 5. 2023 v 19:09 odesílatel Ron napsal: > On 5/16/23 10:03, Elstermann, Mike wrote: > > Hello all, > > > > is it possible to store also packed raster data (e.g. jpg, lzw tiff, ...) > in PostgreSQL? > > > You can store any binary data you want in columns of type "bytea". > or you can us

Re: "PANIC: could not open critical system index 2662" - twice

On Tue, May 16, 2023 at 10:20 AM Evgeny Morozov < postgres...@realityexists.net> wrote: > On 9/05/2023 3:32 am, Andres Freund wrote: > > Attached is a rough prototype of that idea (only using datconnlimit == > > -2 for now). > > I guess we need to move this to -hackers. Perhaps I'll post subsequen

Postresql HA 2 nodes

Hi everyone, we're looking for the best solution for a 2-nodes cluster in HA with Postegresql 15. after some checks we are noticed about pgpool for the management of balancing and automatic failover. Can it be considered a viable and manageable solution for production? Thanks, Marcello

Re: Postresql HA 2 nodes

On 5/16/23 16:30, Marcello Lorenzi wrote: Hi everyone, we're looking for the best solution for a 2-nodes cluster in HA with Postegresql 15. after some checks we are noticed about pgpool for the management of balancing and automatic failover. Can it be considered a viable and manageable solutio

Re: "PANIC: could not open critical system index 2662" - twice

Hi, On 2023-05-16 14:20:46 +, Evgeny Morozov wrote: > On 9/05/2023 3:32 am, Andres Freund wrote: > > Attached is a rough prototype of that idea (only using datconnlimit == > > -2 for now). > > I guess we need to move this to -hackers. Perhaps I'll post subsequent > > versions below > > https:/

Postgres Incompatibility

Hi Experts I noticed this problem when creating a backup on Postgres 13 and restoring it on Postgres 15. CREATE FUNCTION sync.show_pg_subscription1() RETURNS SETOF pg_subscription LANGUAGE sql AS $$ SELECT * from pg_subscription; $$;

Re: How can I change replication slot's restart_lsn from SQL?

On Tue, 2023-05-16 at 19:35 +0200, hubert depesz lubaczewski wrote: > > I'm working on a workaround for a bug in Pg > > (https://www.postgresql.org/message-id/flat/Yz2hivgyjS1RfMKs%40depesz.com) > > I want to create replication slot, and advance is manually, keeping it > > always a bit lagging behi

Re: How can I change replication slot's restart_lsn from SQL?

On Wed, May 17, 2023 at 08:16:41AM +0200, Laurenz Albe wrote: > On Tue, 2023-05-16 at 19:35 +0200, hubert depesz lubaczewski wrote: > > > I'm working on a workaround for a bug in Pg > > > (https://www.postgresql.org/message-id/flat/Yz2hivgyjS1RfMKs%40depesz.com) > > > I want to create replication s