Skip to main content

PostgreSQL and pgAdmin4 installation on Ubuntu 18.04 LTS

PgAdmin4 is an open source PostgreSQL management tool 

designed for multiple PostgreSQL database versions. It is a 

tool  written in python and jquery and can be installed on 

Windows, Mac, and Linux. It provides multiple deployment

models, can be installed as a desktop application or a server 

application running behind the webserver such as Apache2.


We're going to install and configure  PgAdmin4 in  'Server Mode' on Ubuntu 

18.04 server. 


Pre-requisites:


root user / sudo  access. 



PostgreSQL installation on Ubuntu 18.04 Server


To install the PostgreSQL database from the official repository, add the Postgres

 key and repository by running following commands


wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc \ 

| sudo apt-key add -


sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ `lsb_release -cs`-

pgdg main" >> /etc/apt/sources.list.d/pgdg.list'



Update the system

sudo apt update



Install PostgreSQL and its dependent repositories

 sudo apt -y install postgresql postgresql-contrib



Once the installation is complete login with default user named as

"postgres" and run psql command

from command line


su - postgres

psql



Now add new password to the default postgres user using following command as 






Pgadmin4 installation from Repository 



1. Adding postgreSQL repository (Downloading the key first)  


Download the key and add the repository using following commands:


wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc \ 

| sudo apt-key add -


sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ `lsb_release -cs`

-pgdg main" >> /etc/apt/sources.list.d/pgdg.list'




2. Installation of Pgadmin4 


update the system if not done already 


sudo apt update


sudo apt install pgadmin4 pgadmin4-apache2 -y



you can add your own email address and password























Once the installation is complete , you can access the Pgadmin4 

tool from application finder.

















































Labels:

Comments

Post a Comment

Popular posts from this blog

Setting up X11 Access to the Solaris GUI Gnome Desktop

How to   access the GUI desktop environment on a Solaris 11 SPARC server from Windows, MAC, Solaris or Linux desktop computer. As most of the time SPARC based servers are installed using the Oracle Solaris 11 Text  Installer (installing the solaris-large-server group of software packages), the desktop  environment is not installed (mostly to keep the system lightweight) . So the only option for connecting remotely to the server is with an SSH client and a command line interface  (Known as Terminal). Most widely used software to connect to a command line is Putty. For beginners , who haven’t worked on any unix/linux system , it takes time to adjust to the commands and syntax of terminals (The so called black screen).   Installation Overview To accomplish our task   we will   follow these three steps: 1. Install the Gnome desktop environment on our SPARC server. Note – If we use the text installation method, the Oracle Solaris Desktop package (solar...
Post a Comment
Read more

AWK one liners [part one]

AWK was initially developed in 1977 by Alfred Aho , Peter J Wienberger  and Brian Kernighan. And hence the name(AWK) derived from  their respective initials. AWK was designed basically for text processing and used mostly for  extraction  a nd manipulation of data. For more info  :  visit here Lets start with the examples. 1. Print Specific Column from a file sample file created awk '{print $1 "   " $3}' abc.txt awk '{print $1 "   " $3}' abc.txt 2. Print all data from a table awk '{print $0}' abc.txt
Post a Comment
Read more

Root Password Recovery Solaris 11

1. Set the auto-boot options to false.  ldm set-variable auto-boot\?=false Ldom-name 2. To check the disk resources attached to your ldm  ldm list -o disk Ldom-name 3. Check for any existing services on Primary/IO Domain  ldm list-services primary 4. You can use the existing one , if any or else create a new one. l dm add-vds primary-cdrom primary 5. Add a vdsdev to the service created in step 4 l dm add-vdsdev options=ro  /tmp/sol-11_2-text-sparc.iso  cdrom01@primary-cdrom where ro=read-only /tmp/sol-11_2-text-sparc.iso = path of The Solaris 11 iso image   6. Add a virtual disk to the vdsdev created in step 5 l dm add-vdisk cdrom cdrom01@primary-cdrom Ldom-name 7. From the primary domain break into the ldom whose password is to be recovered telnet 0 500x (ldm port number) Trying 0.0.0.0.. Connected to 0 Escape character is '^]' telnet> send break c)ontinue, s)ync, r)eset? Enter r Resetting.. NOTICE: ...
Post a Comment
Read more