CLOSE_WAIT pileup and Application Timeout

2024-10-03 Thread KK CHN
List, I am facing a network (TCP IP connection closing issue) . Running a mobile tablet application, Android application to update the status of vehicles fleet say around 1000 numbers installed with the app on each vehicle along with a vehicle tracking application server solution based on Ja

Re: How to handle "could not find function xml_is_well_formed" when restoring database in Version 17

2024-10-03 Thread Adrian Klaver
On 10/3/24 08:20, George Weaver wrote: Thanks Tom and Christoph, Got it! The function xml_valid is also gone.  Does xml_is_well_formed accomplish the same objective? Gone from where? https://www.postgresql.org/docs/17/xml2.html xml_valid ( document text ) → boolean Parses the given docume

Re: How to handle "could not find function xml_is_well_formed" when restoring database in Version 17

2024-10-03 Thread George Weaver
Thanks Tom and Christoph, Got it! The function xml_valid is also gone.  Does xml_is_well_formed accomplish the same objective? Thanks, George On 01/10/2024 12:28 p.m., Tom Lane wrote: George Weaver writes: I am testing upgrading from Version 13 to Version 17.  I am getting the following

Re: Userland copy of pg_statistic - is there a solution?

2024-10-03 Thread Vinícius Abrahão
On Mon, Sep 30, 2024 at 8:31 AM Vinícius Abrahão wrote: > > Morning, > > postgres=# create table backup_pg_statistic as select * from pg_statistic; > 2024-09-30 08:25:56 BST [7400]: > user=vinnix,db=postgres,app=psql,client=[local] ERROR: column "stavalues1" > has pseudo-type anyarray > 2024-09-