Series

postgres

8 post(s) found.
  • PostgreSQL 14: TLS Connection

    @nabbisen

    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. ...

    Read
  • PostgreSQL 14.2 On OpenBSD 7.1: Install

    @nabbisen

    Summary In OpenBSD 7.1 release, PostgreSQL was upgraded to 14.2. This post shows how to install it on the latest OpenBSD. ...

    Read
  • PostgreSQL 13.5 On OpenBSD 7.0: Install

    @nabbisen

    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. ...

    Read
  • PostgreSQL on OpenBSD: Upgrade 11 to 12 with pg_dumpall

    @nabbisen

    Summary In upgrading OpenBSD from 6.8 to 6.9, I had to upgrade PostgreSQL server (12.6 -> 13.2), as written in OpenBSD’s Upgrade Guide) Here is how I carried it out due to the official readme of postgresql-server package: ...

    Read
  • PostgreSQL 12 On OpenBSD 6.7: Install

    @nabbisen

    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. ...

    Read
  • PostgreSQL 12: TLS Connection

    @nabbisen

    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. ...

    Read
  • PostgreSQL 11 On OpenBSD 6.5: Install

    @nabbisen

    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. ...

    Read
  • PostgreSQL 10 On OpenBSD 6.3: Install

    @nabbisen

    This post shows how to install PostgreSQL on OpenBSD and set it up. Environment OS: OpenBSD 6.3 DB: PostgreSQL 10. ...

    Read