Guarantees/Semantics of pg_stats

Hi, I'm interested in learning more about the guarantees/semantics of pg_stats. For example, is there a guarantee that the n_distinct and most_common_vals fields will take into account any values appearing more than M times or maybe with frequence more than f? In what cases will n_distinct and

Re: High Availability and Replication

> On Saturday, March 2nd, 2024 at 1:24 AM, Abdul Sayeed > wrote: > Hi, > > When Master server goes down, either you need to promote one of slave node or > configure HA mechanism so that in case of master server goes down it will > automatically promote the slave server as new master. > > Patro

Re: High Availability and Replication

> On Saturday, March 2nd, 2024 at 12:14 AM, Israel Brewster > wrote: >> On Mar 1, 2024, at 11:36 AM, normandavis1990 >> wrote: >> >>> On Thursday, February 29th, 2024 at 11:38 PM, Israel Brewster >>> wrote: >> On Feb 29, 2024, at 10:15 AM, David G. Johnston wrote: On Th

Re: High Availability and Replication

Hi, When Master server goes down, either you need to promote one of slave node or configure HA mechanism so that in case of master server goes down it will automatically promote the slave server as new master. Patroni HA tool would be good option for your requirement. https://patroni.readthedocs

Re: High Availability and Replication

> On Mar 1, 2024, at 11:36 AM, normandavis1990 > wrote: > > > On Thursday, February 29th, 2024 at 11:38 PM, Israel Brewster > > wrote: >>> On Feb 29, 2024, at 10:15 AM, David G. Johnston >>> wrote: >>> >>> >>> >>> On Thursday, February 29, 2024, normandavis1990 >>

Re: High Availability and Replication

> On Thursday, February 29th, 2024 at 11:38 PM, Israel Brewster > wrote: >> On Feb 29, 2024, at 10:15 AM, David G. Johnston >> wrote: >> >> On Thursday, February 29, 2024, normandavis1990 >> wrote: >> >>> What is the difference between High Availability and Replication? >> >> The former is a

How to clone a database?

Hello, I have a primary server with two replication servers. I want to HA this primary server because I need to shut it down. Please introduce me to a tutorial that explains this step by step. Could setting up HA cause the primary server to go down? Cheers.

Re: Content for talk on Postgres Type System at PostgresConf

On Thu, Feb 29, 2024 at 05:51:11PM -0500, Tom Lane wrote: > >> money is a fixed-point decimal value, the number of decimal > >> places is locale determined. I’m not aware of any particular > >> problems with that > > You forget about the currency symbol dynamic. Like with time zones > > the local

Re: Content for talk on Postgres Type System at PostgresConf

On 3/1/24 01:18, Laurenz Albe wrote: On Thu, 2024-02-29 at 13:38 -0800, Guyren Howe wrote: what are the misconceptions, or where might I find them for  myself? In addition to what was already said: My current understanding:  * character is fixed-length, blank-padded. Not sure when you’d

Re: walreceiver fails on asynchronous replica [EXTERNAL] [SEC=UNOFFICIAL]

Ccc. blowjobsblowjobsblowjobsblowjobsblowjobsblowjobsBuenos días . Por favor queria hacer un pedido de 2 salteñas de carne picante y 2 de pollo picante para ir a recoger a la 1 de la tarde por favor. Graciasblowjobhttps://whatsapp.com/channel/0029Va94dZyIXnlxXagThf0G Lea también sBuenos días .

Re: Excel Source [24]] Error: System.Exception: SqlTruncateException: Numeric arithmetic causes

The numeric(19, 18) field type can only store numbers less than 10 with 18 decimal places. To save the number 36655.63 you need a numeric(12, 2) field type. On Thursday, February 29, 2024 at 10:00:10 AM GMT-5, Erik Wienhold wrote: cc'ing list. On 2024-02-29 07:16 +0100, Anthony Apoll

RE: Unable to get PostgreSQL 15 with Kerberos (GSS) working

Host file looks like: 127.0.0.1 localhost hostname hostname.mydomain.net ::1 localhost hostname hostname.mydomain.net 10.204.50.65 hostname hostname.mydomain.net I also tried commenting out the ::1 line, but the issue moved to 127.0.0.1, commented that out and the issue moved to the IP

Re: Content for talk on Postgres Type System at PostgresConf

On Thu, 2024-02-29 at 13:38 -0800, Guyren Howe wrote: > what are the misconceptions, or where might I find them for  myself? In addition to what was already said: > My current understanding: >  * character is fixed-length, blank-padded. Not sure when you’d >want that, but it seems clear. Is t