Postgresql database and application server compatibility
Hello Postgresql community, My name is Rickson. I hope this email finds you well and I hope that I’m asking this question in the right forum. If this is not the right mailing list, please let me know in which forum should I be asking this question. We will soon be upgrading all of our application infrastructure. Currently we have Postgresql 9.6 installed in our Centos Linux 7 database server which talks to our application installed in our Windows application Server which has a Windows Server 2012 R2 installed in it. We will be moving from Postgresql 9.6 to Postgresql 13.XX which will be installed in our Rocky Linux 8 database server which will talk to our application which will be installed in our Windows application Server which will have a 2022 Windows Server installed in it. Please forgive me if this question is too novice in nature. Will Postgresql 13.XX installed in Rocky Linux 8 database server have any issues communicating with our application installed in our Windows application Server with a 2022 Windows Server. Please note that our application is compatible with the database Postgresql 13.XX as well as Windows Server 2022 === From Postgresql 9.6 installed in our Centos Linux 7 database server To Postgresql 13.XX installed in our Rocky Linux 8 database server === From Windows application Server with a 2012 Windows Server R2 edition To Windows application Server with a 2022 Windows Server Thanks, Rickson
RE: Postgresql database and application server compatibility
Thanks Laurenz. Regards, Rickson -Original Message- From: Laurenz Albe Sent: Friday, September 30, 2022 12:53 PM To: Rickson Marshall ; pgsql-general@lists.postgresql.org Subject: Re: Postgresql database and application server compatibility EXTERNAL EMAIL On Fri, 2022-09-30 at 01:36 +, Rickson Marshall wrote: > We will be moving from Postgresql 9.6 to Postgresql 13.XX which will be > installed in our > Rocky Linux 8 database server which will talk to our application which will > be installed > in our Windows application Server which will have a 2022 Windows Server > installed in it. > > Please forgive me if this question is too novice in nature. Will Postgresql > 13.XX installed > in Rocky Linux 8 database server have any issues communicating with our > application installed > in our Windows application Server with a 2022 Windows Server. > > Please note that our application is compatible with the database Postgresql > 13.XX as well > as Windows Server 2022 If your application works with PostgreSQL v13, it will work no matter on which operating system the server is running. Make sure to upgrade the PostgreSQL client library on the application server as well. The more recent that is, the better. Test well. Yours, Laurenz Albe
