Re: barman with postgres server/s

Hi, I had the opportunity to work with barman. In my opinion, to configure barman, you should have a separate dedicated system. Configure WAL archiving properly to ensure that all transaction logs are streamed to Barman like the following archive_command = 'rsync %p barman@backup_server:/path/to/

Re: Foreign Data Wrappers

The most interesting (IMHO) FDW implementation I have used is an Australian WFS service mounted locally as a Postgis table. Not wonderful performance, but full spatial query functionality. If performance was an issue, "create table as select * from FDW;" creates a local cache... Very useful fun

Re: Foreign Data Wrappers

Thanks for the pointers! I'll resume my task in the morning. If I get anywhere, I will post the outcome. R, Gus On Fri, Sep 6, 2024 at 9:35 PM Tom Lane wrote: > Gus Spier writes: > > If I understand the concepts correctly, FDW not only makes other > databases > > available, FDW also offers ac

Re: Foreign Data Wrappers

Gus Spier writes: > If I understand the concepts correctly, FDW not only makes other databases > available, FDW also offers access to .csv files, plain text, or just about > anything that can be bullied into some kind of query-able order. Has anyone > ever tried to connect to redis or elasticache?

Re: Foreign Data Wrappers

2024年9月7日(土) 9:55 Gus Spier : > > I find myself in new territory, Foreign Data Wrappers (FDW). I stumble closer > to success through the documentation, youtube videos, and various google > resources. But I've come across a concept that intrigues me very deeply. > > If I understand the concepts co

Re: Foreign Data Wrappers

> On Sep 6, 2024, at 17:55, Gus Spier wrote: > If I understand the concepts correctly, FDW not only makes other databases > available, FDW also offers access to .csv files, plain text, or just about > anything that can be bullied into some kind of query-able order. There two parts to FDWs: T

Foreign Data Wrappers

I find myself in new territory, Foreign Data Wrappers (FDW). I stumble closer to success through the documentation, youtube videos, and various google resources. But I've come across a concept that intrigues me very deeply. If I understand the concepts correctly, FDW not only makes other databases

Re: Issue with Restore dump with plpythonu, plpython3u installed on postgres16

On 9/6/24 05:58, Sam Son wrote: Thanks Adrian, I have tried your previous workaround and it worked fine. I will try this approach as well. If the previous solution(-s/-a) works then my update should work also. I offered it as possible solution should you run into out of sequence issues usin

Re: Is there a way to change email for subscription ?

On 2024-Sep-05, Muhammad Ikram wrote: > I want to change email for my PostgreSQL community subscriptions. Is there > a way to do it without unsubscribing and then subscribing to a new email ? Yes. You need to add your new email address as a secondary here https://www.postgresql.org/account/profi

Re: Using left joins instead of inner joins as an optimization

On Fri, Sep 6, 2024 at 7:05 AM Xavier Solomon wrote: > > explain select b_id from b natural left join a; > results in a `Seq Scan on b`. Whereas the query > > explain select b_id from b natural join a; > results in a join with sequential scans on both a and b. > I think your example is a little

Re: Using left joins instead of inner joins as an optimization

On Fri, 6 Sept 2024 at 23:05, Xavier Solomon wrote: > > create table a(a_id int primary key generated always as identity, a_data > > text); > > create table b(b_id int primary key generated always as identity, a_id int > > not null references a(a_id), b_data text); > > Then the query > > explain

barman with postgres server/s

Does anyone know a best practice when it comes to installing barman? Would barman be on its own system or does it make sense to have it running on a cascaded postgres server? I'm just getting started with it so I'd like to see how others have implemented its use in a variety of different implemen

Re: Issue with Restore dump with plpythonu, plpython3u installed on postgres16

Thanks Adrian, I have tried your previous workaround and it worked fine. I will try this approach as well. Regards, Samson G On Thu, Sep 5, 2024 at 3:50 AM Adrian Klaver wrote: > On 9/4/24 10:46, Sam Son wrote: > > Hi Adrian, > > > > Thanks for your suggestions. I will try your modifications a

Re: Is there a way to change email for subscription ?

I believe that's the only way to do it. On Thu, Sep 5, 2024 at 12:09 PM Muhammad Ikram wrote: > > Hi, > > I want to change email for my PostgreSQL community subscriptions. Is there > a way to do it without unsubscribing and then subscribing to a new email ? > > -- > Regards, > Muhammad Ikram > >

Using left joins instead of inner joins as an optimization

Hi All! I'm currently writing a view that joins many tables and I was wondering how PostgreSQL optimizes projections on such a view. In particular I was wondering if it is a correct and valid optimization technique to use left joins when they are equivalent to an inner join. I have created a mini

Re: Is there a way to change email for subscription ?

Hi back to you. I would unsubscribe the undesired email from the mailing-list, and then subscribe the desired email. Simple as that! Hope this help you. On 2024-09-05 12:09 a.m., Muhammad Ikram wrote: Hi, I want to change email for my PostgreSQL community subscriptions. Is there a way to