Install PostgreSQL 9.x on Debian Stretch 9 32/64-bit
The Tutorial Shows You How-to Install and Getting-Started with Latest PostgreSQL 9.x Database for Debian Stretch 9 i386/amd64 Kde/Gnome/Xfce/Lxde Linux.
As with every annual release, PostgreSQL 9.x includes many New Features to make working with PostgreSQL easier, more flexible and more fun for application developers, administrators and architects.
The New PostgreSQL Features include:
- Additional JSON constructor and extractor methods
- Automatically updatable VIEWs
- Parallel pg_dump to speed backups of large databases
- LATERAL JOINs
Further, PostgreSQL 9.4’s User-Defined Background Workers allow developers to write task managers, request handlers, parallel processors, queuing tools and other helper applications to enable PostgreSQL as a workload coordinator.
One example of this already released is Mongres, a background worker which accepts MongoDB queries, interprets them and passes them on to PostgreSQL.
To the PostgreSQL Database Installation Debian Stretch 9 Guide Bottom You find Link to Quick-Start with PostgreSQL on Debian.
Download Latest PostgreSQL DB for Linux:Linux PotrgreSQL Installer
Open Terminal Window
(Press “Enter” to Execute Commands)
Access the Target location
(Usually Downloads go in the Home folder or the Temporary directory /tmp)
Or when downloaded with Firefox maybe:
To Verify that it’s there List the contents with:
Give Permissions and Start PostgreSQL Installer
su -c "chmod +x ./postgresql-9.*.run"
su -c "./postgresql-9.*.run"
Follow PostgreSQL Installation Wizard
Set the PostgreSQL Installation Path.
Set the PostgreSQL Data Path.
Set-Up the Postgres Administrator.
Set the PostgreSQL Server Listening Port.
Set the PostgreSQL Database Locale in Use.
Start PostgreSQL Installation.
Last Eventually Add some PostgreSQL Tools…
Getting-Started Quickly with PostgreSQL on Linux Debian:PostgreSQL Quick-Start Guide