Re: what is the solution like oracle DB's datafile
wrote: > - Oracle was developed earlier, and one can argue that in those days file > systems > were not so great, so there was more need to write your own Correct me if I'm wrong, but didn't Postgres (or Ingres upon which it's based) development start in the early-to-mid 70's and Oracle's only in the late 70's - early 80's? [1] https://en.wikipedia.org/wiki/Ingres_(database)#Early_history [2] https://en.wikipedia.org/wiki/PostgreSQL#History E. > Laurenz Albe
Re: what is the solution like oracle DB's datafile
Le mar. 27 déc. 2022 à 11:37, Eagna a écrit : > > > wrote: > > > - Oracle was developed earlier, and one can argue that in those days > file systems > > were not so great, so there was more need to write your own > > > Correct me if I'm wrong, but didn't Postgres (or Ingres upon which it's > based) development start in the early-to-mid 70's and Oracle's only in the > late 70's - early 80's? > > [1] https://en.wikipedia.org/wiki/Ingres_(database)#Early_history > [2] https://en.wikipedia.org/wiki/PostgreSQL#History > > " The origins of PostgreSQL date back to 1986 as part of the POSTGRES project at the University of California at Berkeley and has more than 35 years of active development on the core platform." ( https://www.postgresql.org/about/) -- Guillaume.
Re: best practice to patch a postgresql version?
On 2022-12-27 13:33:06 +0800, qihua wu wrote: > But on a critical production database, we need to cut down the downtime as > much > as possible. If just remove a version, and then install a new version, both of > them need a downtime. I'm pretty sure that an `apt install` first replaces all the binaries and only then restarts the database. But even if does shudown the database before replacing the binaries and starts it afterwards, the database is down maybe for a second or two. > If we can install several versions on different location, > switching version will have a shorter downtime: just stop the old version and > start using the new binary, and we have no downtime when remove/install a new > version. I doubt that you are much faster. And if your application can't tolerate a downtime of a few seconds I hope you have some cluster solution with multiple active nodes running already. hp -- _ | Peter J. Holzer| Story must make more sense than reality. |_|_) || | | | h...@hjp.at |-- Charles Stross, "Creative writing __/ | http://www.hjp.at/ | challenge!" signature.asc Description: PGP signature
