![]() ![]() ![]() Go - as this is our programming language of choice, we need to install it in our local environment.Prerequisitesīefore we start working on this application, there are a few things we need to get set up: In this article, we will be looking at how we can use Postgres in a Go application. According to the official documentation, it is “a powerful, open-source object-relational database system with over thirty years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.” PostgreSQL is one of the most popular SQL databases today. ![]() Building a simple app with Go and PostgreSQL In my spare time, I enjoy watching sci-fi movies and cheering for Arsenal FC. How To Install PostgreSQL 12 on Ubuntu 20.04/18.04/16.Emmanuel John Follow I'm a full-stack software developer, mentor, and writer. If all configuration is correct you will be able to see the PostgreSQL server on the left side.Įnd of the article, we’ve seen how to install pgAdmin 4 on Ubuntu 20.04/18.04/16.0 and explore more on the pgAdmin web UI. Now, click on the “ Connection tab”, provide server details like PostgreSQL IP/host, database user, and password Under the “ General” section, Give PostgreSQL server name with description Step 6: Add a PostgreSQL server to administer with pgAdminĬlick on “Add New Server” (you can add local or remote PostgreSQL server) Once you login you will get the below screen. Login with Credentials which we have created in step 3 Rules updated Step 5: Access pgadmin4 on web browser May 16 12:28:13 PostgreSQL systemd: Started The Apache HTTP Step 4: Configure firewall on Ubuntu (Optional) sudo ufw allow http sudo ufw allow https May 16 12:28:13 PostgreSQL apachectl: AH00558: apache2: Could not relia> May 16 12:28:12 PostgreSQL systemd: Starting The Apache HTTP Server. Process: 25828 ExecStart=/usr/sbin/apachectl start (code=exited, status=0/> Loaded: loaded (/lib/systemd/system/rvice enabled vendor pres>Īctive: active (running) since Sun 12:28:13 EDT 4min 37s ago Replace Email ID and configure your strong password.Īfter installation Apache service will be started $ systemctl status apache2 Processing triggers for desktop-file-utils (0.24-1ubuntu4) Step 3: Configure pgAdmin4 credentials sudo /usr/pgadmin4/bin/setup-web.sh Processing triggers for gnome-menus (3.36.0-1ubuntu1). Processing triggers for hicolor-icon-theme (0.17-2). Processing triggers for mime-support (3.64ubuntu1). Selecting previously unselected package pgadmin4. Selecting previously unselected package pgadmin4-web. Selecting previously unselected package pgadmin4-desktop. Selecting previously unselected package pgadmin4-server. 195104 files and directories currently installed.) Selecting previously unselected package libapache2-mod-wsgi-p圓. Get:3 pgadmin4/main all pgadmin4 all 5.2 Get:2 pgadmin4/main all pgadmin4-web all 5.2 Get:1 pgadmin4/main amd64 pgadmin4-desktop amd64 5.2 Libapache2-mod-wsgi-p圓 pgadmin4 pgadmin4-desktop pgadmin4-serverĠ upgraded, 5 newly installed, 0 to remove and 206 not upgraded.Īfter this operation, 300 kB of additional disk space will be used. The following NEW packages will be installed: Libapache2-mod-wsgi-p圓 pgadmin4-desktop pgadmin4-server pgadmin4-web The following additional packages will be installed: The following package was automatically installed and is no longer required: Run 'apt list -upgradable' to see Step 2: Install pgAdmin4 on Ubuntu sudo apt install pgadmin4 Manage keyring files in instead (see sudo sh -c 'echo "deb $(lsb_release -cs) pgadmin4 main" > /etc/apt//pgadmin4.list & apt update'Ģ06 packages can be upgraded. Sample Output: wget -quiet -O - | sudo apt-key add. Sudo sh -c 'echo "deb $(lsb_release -cs) pgadmin4 main" > /etc/apt//pgadmin4.list & apt update' See also: Step 1: Add PostgreSQL APT repository wget -quiet -O - | sudo apt-key add. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |