Category: PostgreSQL
Anything related to the PostgreSQL DBMS
Upgrading PostgreSQL and PHP
One thing has annoyed me for years, and that is the ports tree refusing me to configure and download newer versions of PHP and PostgreSQL while an older one is installed.
Read More → Upgrading PostgreSQL and PHPUpgrading PostgreSQL from 13.4 to 14.0
Here’s a summary of my adventure upgrading PostgreSQL from 13.4 to 14.0 on my laptop running FreeBSD current.
Read More → Upgrading PostgreSQL from 13.4 to 14.0Getting Bareos up & running on FreeBSD stable/12
I’m in the process of figuring out if Bareos can replace AMANDA in my shop. What is better than setting up a test server and do as many mistakes as possible before going live?
Read More → Getting Bareos up & running on FreeBSD stable/12Upgrading PostgreSQL from 9.5.7 to 9.6.3
All commands were done as the root user unless indicated. This time it was necessary to create a new ZFS hierarchy of filesystems rooted at /var/db/postgres/data96. Also, the new PostgreSQL DBMS runs as the postgres user, not the pgsql user.
Read More → Upgrading PostgreSQL from 9.5.7 to 9.6.3Poststeder i Norge
Her er en oppskrift for å få alle Norges poststeder inn i en egnet tabell. Last ned Postnummerregister_ansi.txt fra Bring.
Read More → Poststeder i NorgeUpgrading PostgreSQL 9.4.6 to 9.5.1
All commands were done as the root user unless indicated.
Read More → Upgrading PostgreSQL 9.4.6 to 9.5.1Upgrading PostgreSQL 9.2.10 to 9.4.1
I decided to upgrade my PostgreSQL server today. I did this upgrade slightly different than the last time. All commands were done as the root user unless indicated.
Read More → Upgrading PostgreSQL 9.2.10 to 9.4.1Upgrading PostgreSQL from 9.1.5 to 9.2.0
Today, I decided to upgrade PostgreSQL from 9.1.5 to 9.2.0 on one of my computers. Ironically, PostgreSQL 9.2.1 was released today, but until the FreeBSD ports hierarchy catches up, the most recent version available is 9.2.0, unless of course you want to do everything yourself.
Read More → Upgrading PostgreSQL from 9.1.5 to 9.2.0A verbose startup script for PostgreSQL on FreeBSD
The default startup script for PostgreSQL on FreeBSD doesn’t give much clue when starting and stopping the DBMS. Here’s a patch to remedy this annoyance.
Read More → A verbose startup script for PostgreSQL on FreeBSD