Install PostgreSQL 10 Lubuntu 14.04
Hi! The Tutorial shows you Step-by-Step How to Install PostgreSQL 10 on Lubuntu 14.04 Trusty LTS GNU/Linux.
And PostgreSQL 10 for Lubuntu 14.04 is a Major Release that contains several substantial Changes and Improvements.
Moreover, PostgreSQL 10 contains a number of Extensive Changes that May affect Compatibility with Previous Releases.
Especially relevant: A dump/restore using pg_dumpall, or use of pg_upgrade, is Required for those wishing to Migrate Data from PostgreSQL 9 and Below.

Open a Shell Terminal emulator window
Ctrl+Alt+t on desktop
(Press “Enter” to Execute Commands)How to Add PostgreSQL 10 Lubuntu Apt Repository
Installing PostgreSQL for Lubuntu.
sudo apt install postgresql-10
If Got “User is Not in Sudoers file” then see: How to Enable sudo
How to Getting-Started with PostgreSQL 10 Admin