Re: Using PostgreSQL for service discovery and health-check

On 2/9/23 09:40, Dominique Devienne wrote: On Thu, Feb 9, 2023 at 5:51 PM Adrian Klaver > wrote: On 2/9/23 08:16, Dominique Devienne wrote: > On Thu, Feb 9, 2023 at 5:05 PM Adrian Klaver mailto:adrian.kla...@aklaver.com> The flip side of that is

Re: Using PostgreSQL for service discovery and health-check

On 2/9/23 09:40, Dominique Devienne wrote: On Thu, Feb 9, 2023 at 5:51 PM Adrian Klaver > wrote: On 2/9/23 08:16, Dominique Devienne wrote: > On Thu, Feb 9, 2023 at 5:05 PM Adrian Klaver mailto:adrian.kla...@aklaver.com> The flip side of that is

Re: Using PostgreSQL for service discovery and health-check

On Thu, Feb 9, 2023 at 5:51 PM Adrian Klaver wrote: > On 2/9/23 08:16, Dominique Devienne wrote: > > On Thu, Feb 9, 2023 at 5:05 PM Adrian Klaver The flip side of that is that with known ports it would it easier to > have a process on the Postgres machine or in the database that checks > the por

Re: Using PostgreSQL for service discovery and health-check

On 2/9/23 08:16, Dominique Devienne wrote: On Thu, Feb 9, 2023 at 5:05 PM Adrian Klaver > wrote: Is there more then one server providing the same service? Yes. That was my PS: basically. The client can connect to any one, randomly. We need at least one

Re: Using PostgreSQL for service discovery and health-check

On Thu, Feb 9, 2023 at 5:05 PM Adrian Klaver wrote: > On 2/9/23 07:30, Dominique Devienne wrote: > > In a normally 2-tier system, where "desktop" native apps connect > > directly to PostgreSQL to access data, some things must be mediated via > > a middle-tier service (i.e. 3-tier architecture). T

Re: Using PostgreSQL for service discovery and health-check

On 2/9/23 07:30, Dominique Devienne wrote: Hi. I'm requesting advice on something I'm about to start on. In a normally 2-tier system, where "desktop" native apps connect directly to PostgreSQL to access data, some things must be mediated via a middle-tier service (i.e. 3-tier architecture). Th

Re: Using PostgreSQL for service discovery and health-check

On Thu, Feb 9, 2023 at 4:46 PM David G. Johnston wrote: > On Thu, Feb 9, 2023 at 8:30 AM Dominique Devienne > wrote: > >> That's basically my plan. Now come the questions: >> 1) will updating a row every second (for example) create issues? >> 2) if yes to #1 above, what would be good mitigation

Re: Using PostgreSQL for service discovery and health-check

On Thu, Feb 9, 2023 at 8:30 AM Dominique Devienne wrote: > > That's basically my plan. Now come the questions: > 1) will updating a row every second (for example) create issues? > 2) if yes to #1 above, what would be good mitigation tactics? Use > different table for service vs heartbeat? Special

Using PostgreSQL for service discovery and health-check

Hi. I'm requesting advice on something I'm about to start on. In a normally 2-tier system, where "desktop" native apps connect directly to PostgreSQL to access data, some things must be mediated via a middle-tier service (i.e. 3-tier architecture). That service is HTTP based thus clients (the "des