sudo apt install postgresql postgresql-client
sudo su - postgres
psql
ALTER USER postgres PASSWORD 'postgres';
ALTER SYSTEM SET listen_addresses TO '*';
exit
exit
Install PgAdmin4
If Curl Command not Install run
sudo apt install curl
curl https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo apt-key add
sudo sh -c 'echo "deb https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/$(lsb_release -cs) pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list && apt update'
sudo apt install pgadmin4
sudo /usr/pgadmin4/bin/setup-we.sh
With a deep passion for technology and over 8 years of experience, I have built a successful career as a skilled professional specializing in IT infrastructure, system administration, and voice communication systems. I have had the privilege of serving in key roles such as Technical Operations Manager and Voice President, where I led the planning, implementation, and management of complex technical environments, including Amazon AWS, VOIP, Freeswitch, and Free PBX.
I am also the creator of TechnTrick, a blog aimed at supporting IT professionals with practical tutorials, expert advice, and in-depth resources on a wide range of technologies. My goal is to make complex IT concepts accessible to all, helping others navigate and master the ever-evolving landscape of technology.
