Development

What’s in the pipeline, how it works, how it’s made…

Moving the production database server IP address

x8dtu contains two jails for database servers: x8dtu-pg01 and x8dtu-pg02. At any given time, one is the production database server, and contains the IP address 127.1.54.32. Let’s assume x8dtu-pg02 is on PostgreSQL 10.6 and we are upgrading to PostgreSQL 11.1 on x8dtu-pg01 The new packages would be installed on x8dtu-pg01. pg_dump would be run on

Moving the production database server IP address Read More »

procedure OK under 10.6 but starts acting up under 11.1

I originally documented this so I would have a reference while tracking down the problem. I have since solved the issue and you can jump to the bottom of this post to find the solution. What I do not know is why this was not an issue under PostgreSQL 10.6 but was under PostgreSQL 11.1.

procedure OK under 10.6 but starts acting up under 11.1 Read More »

Scroll to Top