Just a Blog

Raspbian Version: Pi 4 OS System: Raspbian/buster (use lsb_release -cs to print) Verified Date: 2020/04/12

1. Uninstall old versions

$ sudo apt-get remove docker docker-engine docker.io containerd runc

2. Install Tool Chain

$ sudo apt-get update

$ sudo apt-get install \
    apt-transport-https \
    ca-certificates \
    curl \
    gnupg-agent \
    software-properties-common

3. Add GPG key

$ curl -fsSL https://download.docker.com/linux/raspbian/gpg | sudo apt-key add -

4. Add repository

$ sudo vim /etc/apt/sources.list.d/docker.list

Add this line and save:

# add docker repository
deb [arch=armhf] https://download.docker.com/linux/raspbian buster stable

5. Install via apt

 $ sudo apt-get update
 $ sudo apt-get install docker-ce docker-ce-cli containerd.io

Troubleshooting

You may encounter this error when apt install running:

Errors were encountered while processing:
 aufs-dkms

We can simply ignore it. Because aufs-dkms is not a dependency of docker-ce, but a recommendation.

Docker is not default to use aufs anymore; It now default prefer to use overlayfs2, which have been merged to the linux kernel mainline since 3.18.

[1] https://docs.docker.com/engine/install/debian/ [2] https://github.com/raspberrypi/linux/issues/3021#issuecomment-508704040

System: Windows 10 Software: Drive File Stream Error: After installation and login then encounter a error message: “Can't reach Google Drive”

Solution:

Open your Registry Editor, In HKEY\_LOCAL\_MACHINE\Software\Google\DriveFS, create two new DWORD values, DisableCRLCheck and DirectConnection, assigning value data as 1.

Reference: https://tinyapps.org/blog/201909120700_can't_reach_google_drive.html

After installation Mastodon under the official guide, I notice that PgHero keep showing this error. Here is the way to solve it.

1. Edit postgresql.conf

sudo vim /etc/postgresql/9.5/main/postgresql.conf

Add the following to your postgresql.conf:

sharedpreloadlibraries = 'pgstatstatements' pgstatstatements.track = all pgstatstatements.max = 10000 trackactivityquery_size = 2048

Then restart the PostgreSQL server: sudo systemctl restart postgresql

2. Create extension

sudo -u postgres psql

postgres=# \c mastodon_production

mastodon_production=# CREATE extension pg_stat_statements;

3. Refresh your PgHero Page

All items are green!

Reference:

• https://github.com/ankane/pghero/blob/master/guides/Query-Stats.md
• https://github.com/tootsuite/mastodon/issues/935