How to install PostgreSQL and pgAdmin on Arch Linux
PostgreSQL is an open source, community driven, standard compliant object-relational database system.
Install the postgresql package. It will also create a system user called postgres.
sudo pacman -S postgresql
su -
su postgres
initdb --locale=C.UTF-8 --encoding=UTF8 -D /var/lib/postgres/data --data-checksums
exit
systemctl enable postgresql.service
systemctl start postgresql.service
exit
sudo -u postgres psql postgres
\password postgres
\qTo install pgAdmin 4 download the AUR package and install it using the commands:
sudo pacman -S base-devel
makepkg
sudo pacman -U package_file