Linux Home Administration

PostgreSqlMove
Published: Wed 25 January 2023
Updated: Fri 19 April 2024
By Don Cohoon

In linux.

tags: systems db

Postgresql Move Database to Another Filesystem

Mainly used this on SBC (BeagleBone) computer to move a database from SD card (/var/lib...) to SSD disk (/data/lib...). A database will burn up an SD card quickly 😟
Table of Contents
- Postgresql Move Database to Another Filesystem
  
  List clusters on host
  
  Show …
read more
PostgreSQLUpgrade
Published: Wed 25 January 2023
Updated: Fri 19 April 2024
By Don Cohoon

In linux.

tags: systems db

PostgreSQL Install and Upgrade

Oh my, installing Ubuntu 22.04 installed PostgreSQL 14... wonder what version I am using...
Table of Contents
- PostgreSQL Install and Upgrade
  
  Establish Baseline
  
  What is installed?
  
  Which one is live
  
  Export and Import (pg_dump)
  
  Do the Upgrade (pg_upgrade)
  
  Remove old postgresql install
- !/bin/sh
  
  Continue …
read more
Docker
Published: Tue 24 January 2023
Updated: Fri 19 April 2024
By Don Cohoon

In linux.

tags: systems

Docker

Docker is a way to manage containers, which are like namespaces or jails. Here are some useful common commands to check out the status of these containers.
Table of Contents
- Docker
  
  Prune unused containers, images and cache
  
  Check a container's logs
  
  Inspect a container
  
  Check for container filesystem changes …
read more