PostgreSQL on OpenBSD: Upgrade 15 to 16 with pg_upgrade
Summary
OpenBSD gives us good documentation as a series of the project. (For example, the man pages are cared and kept maintained.) It’s applied to principal service packages as well as the OS. So is as to PostgreSQL.
... ReadMariaDB 10.9 on OpenBSD 7.3: Install
Summary
MariaDB is one of the popular relational database management systems (RDBMS), forked from MySQL by some of the original developers. It is open source licensed under GNU GPL 2, and ready for both community and enterprise use with long history and large knowledge to manage and maintain.
... ReadPostgreSQL on OpenBSD: Upgrade 14 to 15 with pg_upgrade
Summary
OpenBSD gives us good documentation as a series of the project. (For example, the man pages are cared and kept maintained.) It’s applied to principal service packages as well as the OS. So is as to PostgreSQL.
... ReadPostgreSQL 14.5 on OpenBSD 7.2: Install
Summary
In OpenBSD 7.2 release, PostgreSQL was updated to 14.5. This post shows how to install it on the latest OpenBSD.
... ReadPostgreSQL 14: TLS Connection
Summary
To use PostgreSQL as external database servers, it’s better to use TLS/SSL connection. This post shows how to generate certificates, configure servers and verify them.
... ReadPostgreSQL 14.2 on OpenBSD 7.1: Install
Summary
In OpenBSD 7.1 release, PostgreSQL was upgraded to 14.2. This post shows how to install it on the latest OpenBSD.
... ReadPostgreSQL 13.5 on OpenBSD 7.0: Install
Summary
OpenBSD 7.0 was released and PostgreSQL was upgraded to 13.4 then. In addition, it is now 13.5. The installation process of PostgreSQL server in OBSD 7.0 is almost the same to that in the earlier.
... ReadMariaDB 10.6 (and NextCloud): COMPRESSED Row is read-only by default
PostgreSQL on OpenBSD: Upgrade 12 to 13 with pg_dumpall
Summary
In upgrading OpenBSD from 6.8 to 6.9, I had to upgrade PostgreSQL server (12.6 to 13.2), as written in OpenBSD’s Upgrade Guide. Here is how I carried it out due to the official readme of
... Readpostgresql-serverpackage:PostgreSQL 12 on OpenBSD 6.7: Install
OpenBSD 6.7 was released last month and PostgreSQL was upgraded from 11.7 to 12.2 then. The installation process of PostgreSQL server in OBSD 6.7 is almost the same to that in 6.5.
... ReadPostgreSQL 12: TLS Connection
Introduction
To use remote PostgreSQL server as database server, it’s better to use TLS/SSL connection. This post shows a simple and easy way with self-signed certificate.
... ReadPostgreSQL 11 on OpenBSD 6.5: Install
This post shows how to install PostgreSQL on OpenBSD and set it up. I wrote about the same theme last year, and now the version of PostgreSQL in OpenBSD has been upgraded 10.3 -> 11.2 as the OpenBSD has 6.3 -> 6.5. Happily, what I had to do was just to follow the same process.
... ReadPostgreSQL 10 on OpenBSD 6.3: Install
This post shows how to install PostgreSQL on OpenBSD and set it up.
✿ ✿ ✿Environment
- OS: OpenBSD 6.3
- DB: PostgreSQL 10.3
✿ ✿ ✿Procedure
* note: In code areas, the leading
... Read#means execution by superuser; It is equal to usingdoascommand (as root), while the leading$means by general users.
13 post(s) found.