How postgres is refreshing TLS certificates

2021-07-27 Thread M Tarkeshwar Rao
Hi all, We are working on a activity in which I need to refresh the TLS certificate without restarting the my application pod. This feature is already there in Postgres. Can anyone please suggest us how postgres is implemented the same? Regards Tarkeshwar

Re: I need another option.

2021-07-27 Thread Vijaykumar Jain
On Wed, Jul 28, 2021, 11:10 AM obi reddy wrote: > Hello Everyone . "c --clean (drop) database objects before recreating", > is there any other option for this. please let me know > You'll have to give more information on what you see and what you want or does not work the way you would want. On

I need another option.

2021-07-27 Thread obi reddy
Hello Everyone . "c --clean (drop) database objects before recreating", is there any other option for this. please let me know

Re: RDS Proxy war stories?

2021-07-27 Thread Alvaro Herrera
On 2021-Jul-27, Quinn David Weaver wrote: > Hi, > > Does anyone here have experience to share regarding Amazon's RDS > Proxy? Subjective or quantitative, positive or negative, anything you > have is great. I know one instance of its use. The RDS instance it serves is very large (it used the lar

RDS Proxy war stories?

2021-07-27 Thread Quinn David Weaver
Hi, Does anyone here have experience to share regarding Amazon's RDS Proxy? Subjective or quantitative, positive or negative, anything you have is great. (I've found information to be thin on the ground, probably because RDS Proxy has been around for such a short time (just over a year). As you c

Re: PostgreSQL reference coffee mug

2021-07-27 Thread Daniel Gustafsson
> On 27 Jul 2021, at 20:32, Matthias Apitz wrote: > A question to PostgreSQL.org: Are we allowed to use the PostgreSQL logo > on such produced mugs without selling them, just as a gift. > And can we put our own logo together with the one of PostgreSQL on the > same coffee mug. > > To whom our L

Re: PostgreSQL reference coffee mug

2021-07-27 Thread Matthias Apitz
El día lunes, julio 26, 2021 a las 09:05:39a. m. +0200, Pavel Stehule escribió: > po 26. 7. 2021 v 8:56 odesílatel Matthias Apitz napsal: > > > > > Hello, > > > > Nearly 20 years ago, I ordered some 50 vi-reference coffee mugs like this > > one here (not exactly the same, but to give you an idea

Re: sort order

2021-07-27 Thread Tom Lane
Marc Millas writes: > Re-reading my post, I see that even the élise is not sorted correctly on > w10... Sort orders aren't even particularly guaranteed on different releases of the same platform, let alone totally different platforms. glibc made major changes to their collation rules not long ag

Re: sort order

2021-07-27 Thread Marc Millas
Re-reading my post, I see that even the élise is not sorted correctly on w10... Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Tue, Jul 27, 2021 at 7:07 PM Marc Millas wrote: > Hi, > > context: > one postgres 12 on centos 7 > one postgres 12 on windows 10 > both on machines with

Re: PHP: query with parameter for SET

2021-07-27 Thread Ray O'Donnell
On 27/07/2021 18:20, Pavel Stehule wrote: When you use client side prepared statements, then it can be possible. But I don't know how it works in PHP. Server side prepared statements are not possible in this case. "set" statement has not execution plan. But you  You can use Adrian's proposal,

Re: PHP: query with parameter for SET

2021-07-27 Thread Pavel Stehule
Hi út 27. 7. 2021 v 19:10 odesílatel Ray O'Donnell napsal: > Hi everyone, > > Using PHP (or indeed maybe more generally), is it possible to issue a > SET TIME ZONE statement with a parameter for the new runtime setting? > > In a PHP application I'm issuing a SET TIME ZONE command just after the

Re: PHP: query with parameter for SET

2021-07-27 Thread Adrian Klaver
On 7/27/21 10:10 AM, Ray O'Donnell wrote: Hi everyone, Using PHP (or indeed maybe more generally), is it possible to issue a SET TIME ZONE statement with a parameter for the new runtime setting? In a PHP application I'm issuing a SET TIME ZONE command just after the database connection is cr

PHP: query with parameter for SET

2021-07-27 Thread Ray O'Donnell
Hi everyone, Using PHP (or indeed maybe more generally), is it possible to issue a SET TIME ZONE statement with a parameter for the new runtime setting? In a PHP application I'm issuing a SET TIME ZONE command just after the database connection is created, and for security I'd like to pass th

Re: Logical replication from Rds into on-premise

2021-07-27 Thread Rama Krishnan
Awesome, thanks! Can you please share docs my Rds version is 12.3 On Tue, 27 Jul, 2021, 19:00 Miles Elam, wrote: > On Tue, Jul 27, 2021 at 4:38 AM Dave Cramer > wrote: > >> >> Does RDS allow logical replication >> > > Yes, it does. I believe it was patched for v9.6, but v10 and above support >

Re: Logical replication from Rds into on-premise

2021-07-27 Thread Rama Krishnan
Hi Dave, Rds support logical replication but the question of how to make replication between RDS into on premise On Tue, 27 Jul, 2021, 17:08 Dave Cramer, wrote: > > Dave Cramer > www.postgres.rocks > > > On Mon, 26 Jul 2021 at 18:43, Cory Nemelka wrote: > >> >> On Mon, Jul 26, 2021 at 12:06 PM

sort order

2021-07-27 Thread Marc Millas
Hi, context: one postgres 12 on centos 7 one postgres 12 on windows 10 both on machines with french as default the centos 7 lc_collate and lc_ctype: fr_FR.UTF_8 the w10 lc_collate and lc_ctype: French_France.1252 create table test (ble text, id serial primary key); insert into test(ble) values('

Re: Logical replication from Rds into on-premise

2021-07-27 Thread Miles Elam
On Tue, Jul 27, 2021 at 4:38 AM Dave Cramer wrote: > > Does RDS allow logical replication > Yes, it does. I believe it was patched for v9.6, but v10 and above support it out of the box, and the RDS version of PostgreSQL shares that support. I have used it with v10 and v11, and it works exactly l

Re: Logical replication from Rds into on-premise

2021-07-27 Thread Dave Cramer
Dave Cramer www.postgres.rocks On Mon, 26 Jul 2021 at 18:43, Cory Nemelka wrote: > > On Mon, Jul 26, 2021 at 12:06 PM Rama Krishnan > wrote: > >> Hi all, >> >> I have a postgres server on Aws RDS no i want to replicate the data or >> logical replication into the on-premise server. I have gone