How to Install PostgreSQL DB Server on Your Android Phone using Termux | by OsChannel

#postgresql #android #phone
In this video, we will be installing a PostgreSQL Database Server on our Android device.

In order to install the PostgreSQL server on your Android Phone, you need to first install this Termux application. Termux is basically a terminal emulator app that lets you create a Linux like environment on your Android Phones.

Links to Download the Termux app:
Google PlayStore: https://play.google.com/store/apps/details?id=com.termux
Fdroid PlayStore(Recommended): https://f-droid.org/en/packages/com.termux
Github ( latest builds ): https://github.com/termux/termux-app/releases

Once the Termux app is Installed from Playstore, open it and type the below commands in the terminal:
—–
# Installing PostgreSQL:
apt install postgresql

# Create a directory for DB, and setting files:
mkdir ./postgres

# Initialize the PostgreSQL Database Cluster:
initdb ./postgres

# Now start the Postgres server:
pg_ctl -D ./postgres start

# To login to the Postgres DB and get shell access ( Postgres listens on localhost:5432 ) :
psql -d postgres

# To quit from Postgres:
q

# To stop the PostgreSQL database service:
pg_ctl -D ./postgres stop
—–

Commands CHEATSHEET:
https://gist.github.com/oschannel/1b4eb34f18cc7e573ce57a8c1ed5dc22

If you receive the “termux repo under maintenance” error while installing PostgreSQL refer my this video on how to fix it: https://youtu.be/kaCkPTX3p2E

Other Termux Issues? Read this: https://github.com/termux/termux-app#termux-application
—
Timeline:
00:00 Intro & Advantages
00:45 Termux Intro & Installation
01:38 Install & Start PostgreSQL Server
03:45 Login & Explore Postgres Shell
04:42 Stop PostgreSQL, CheatSheet & Outro

—
# About OsChannel:
OsChannel.com is a tech channel that makes tutorial videos/vlogs about all kinds of tech and mech.

# More termux / Android related videos:
https://www.youtube.com/playlist?list=PLXtILKFopTrOJVMJ7IgPs0ARaQsKlkOS7

# Watch more videos on Mac tricks, tips, shortcuts, and fixes:
https://youtube.com/playlist?list=PLXtILKFopTrOkqKU4Xez7jFP4gNMlQWrG

# Watch full Python Tutorials by OsChannel.com:
https://www.youtube.com/playlist?list=PLXtILKFopTrNdCoLax2kOrroJ6XCDsjOV

# Watch all Python #Shorts by OsChannel.com:
https://www.youtube.com/playlist?list=PLXtILKFopTrM9lM4HTn0c75qQuQF6muRn

# Watch all #Short Videos by Oschannel:
https://www.youtube.com/playlist?list=PLXtILKFopTrN2c95Eb_R5aSKiP8_lVcNw

# CHANNEL LINK:
https://www.youtube.com/c/OschannelDotCom

# LINK TO MY WEBSITE:
https://oschannel.com [ Currently redirected to Youtube ]