RaspberryPi4B: Difference between revisions
| Line 30: | Line 30: | ||
===[[Postgres|PostgreS(QL)]]=== | ===[[Postgres|PostgreS(QL)]]=== | ||
// create a docker container | |||
[[Docker|docker]] run -p 5432:5432 --name postgres -e POSTGRES_PASSWORD=Halloo0@1 -e POSTGRES_DB=postgres -e POSTGRES_USER=postgres -v pgdata:/var/lib/postgresql/data -d postgres | [[Docker|docker]] run -p 5432:5432 --name postgres -e POSTGRES_PASSWORD=Halloo0@1 -e POSTGRES_DB=postgres -e POSTGRES_USER=postgres -v pgdata:/var/lib/postgresql/data -d postgres | ||
// -p <HOSTPORT>:<CONTAINERPORT> | // -p <HOSTPORT>:<CONTAINERPORT> | ||
| Line 37: | Line 38: | ||
// -n <NAME> | // -n <NAME> | ||
C:\Uwes\Programme\PostgreSQL\12\bin> .\psql.exe -h uweheuer.spdns.de -U postgres | // test access | ||
C:\Uwes\Programme\PostgreSQL\12\bin> .\psql.exe -h uweheuer.spdns.de -U postgres postgres | |||
// clean up everything | |||
docker stop postgres | docker stop postgres | ||
docker rm postgres | docker rm postgres | ||
docker volume rm pgdata | |||
==Configuration== | ==Configuration== | ||
Revision as of 20:53, 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)
// create a docker container docker run -p 5432:5432 --name postgres -e POSTGRES_PASSWORD=Halloo0@1 -e POSTGRES_DB=postgres -e POSTGRES_USER=postgres -v pgdata:/var/lib/postgresql/data -d postgres // -p <HOSTPORT>:<CONTAINERPORT> // -e <ENV_VARIABLE>=<VALUE> // -v <VOLUME_NAME>:<CONTAINER_DIR> // -n <NAME>
// test access C:\Uwes\Programme\PostgreSQL\12\bin> .\psql.exe -h uweheuer.spdns.de -U postgres postgres // clean up everything docker stop postgres docker rm postgres docker volume rm pgdata
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