RaspberryPi4B: Difference between revisions

From Wiki RB4
Line 37: Line 37:


  C:\Uwes\Programme\PostgreSQL\12\bin> .\psql.exe -h uweheuer.spdns.de -U postgres test1DB
  C:\Uwes\Programme\PostgreSQL\12\bin> .\psql.exe -h uweheuer.spdns.de -U postgres test1DB
docker stop postgres
docker rm postgres


==Configuration==
==Configuration==

Revision as of 12:50, 30 September 2021

Type Information

  • Raspberry 4B 8GB (1,5 GHz Quad-Core ARM-Cortex A72 CPU)
  • bought at pi3g.com via their shop buyzero.de at 12/08/2021 as Raspberry Pi 4 Server Set:
    • 64GB microSD
    • USB C 5 Volt 3 Ampere Netzteil
    • microHDMI auf HDMI Kabel
    • FLIRC Gehäuse
    • CAT 6 LAN Kabel 2 m

Installation

Initial Operation

  • copy empty file named 'ssh' to root at microSD to enable SSH access
  • microSD to slot
  • plug-in USB power supply
  • login via SSH with user 'pi' and pwd 'raspberry'
  • enable WLAN via raspi-config
  • set fixed IP for LAN and WLAN via fritz.box to 192.168.178.(72|73)
  • update OS via
sudo apt update
sudo apt dist-upgrade

Docker

Installation by:

sudo curl -fsSL https://get.docker.com | sh
sudo usermod -aG docker pi // to enable docker commands w/o sudo for user pi, works after logout and login

Test by:

docker 
docker version
sudo docker run hello-world // w/o sudo or pi not added to group docker there will be an error

PostgreS(QL)

docker run -p 5432:5432 -d -e POSTGRES_PASSWORD=postgres -e POSTGRES_USER=postgres -e POSTGRES_DB=test1DB -v pgdata:/var/lib/postgresql/data --name postgres postgres
// -p <HOSTPORT>:<CONTAINERPORT>
// -e <ENV_VARIABLE>=<VALUE>
// -v <VOLUME_NAME>:<CONTAINER_DIR>
// -n <NAME>
C:\Uwes\Programme\PostgreSQL\12\bin> .\psql.exe -h uweheuer.spdns.de -U postgres test1DB

docker stop postgres
docker rm postgres

Configuration

  • disable WLAN by adding to /boot/config.txt and reboot
#UH 18-08-2021 switch off WLAN
dtoverlay=disable-wifi

Operation

On/Off

  • on/off by plug-in/off power supply

Reboot

sudo reboot

Update

sudo apt-get update && sudo apt-get upgrade