In the “Create – Server” window on the “General” tab enter the following for the “Name”: learning_data_science.The “Create – Server” window will open (Figure 2, upper center).Right click on Servers, and then click on Create and then select “Server…” (Figure 2, upper left).It will open in a web browser (e.g., Chrome) and should look similar to Figure 1. To set up a database server connection using pgAdmin follow these steps: A screenshot of pgAdmin 4 opened in Chrome. For a description of database servers see the “DBMS Software” section of the post Databases and Data Management Systems. The next step before creating a database is to create a database server connection. For instance, if you are a MacOS guru you may choose to use Homebrew for the install. Feel free to use which ever method you prefer. If you are an experienced user then there are other options for installing PostgreSQL on your computer. You can always go back later and configure this. You may asked to configure Stack Builder.Click OK to begin the install which may take several minutes.Be sure to keep track of the password as you’ll need it to create a server connect in the next section. You will also be asked to create a password.You will be asked to select a port that PostgreSQL will “listen” on. Run the installer, and follow the instructions provided.If you have an older computer you may need to opt for the 32-bit version, the most recent of which as of the writing of this blog, was 10.14. As of the writing of this post the most recent 64-bit version was 13.1. Most recent computers support 64-bit platforms. Download the most recent version of of PostgreSQL that works with your computer.This will take you to the EDB page for PostgreSQL Database Download. Under “Interactive installer by EDB” click on “Download the Installer”.Under “Packages and Installers” click on your operating system.Go to the PostgreSQL downloads page here:.To install PostgreSQL follow these steps: The next step is to install PostgreSQL on your computer. Follow the installation instructions that are provided, and accept all default setting.Once the install files have downloaded, double click to open and begin the install.Click on the download link for the most recent version of the install files (e.g.Scroll down the page a short ways, and under pgAdmin 4 click on the link for your operating system.In a future post I’ll provide an in depth review of pgAdmin and DBeaver, a free multi-platform database tool for developers, database administrators, analysts and all people who need to work with databases. pgAdmin is a free general user interface (GUI) for administering PostgreSQL databases and interacting with the data within. While there are several ways to create a PostgreSQL database, for this post we are going to use pgAdmin for this purpose. If you are not familiar with version control using Git and GitHub, I recommend going back and working through the hands on tutorials in my series on version control starting with “ Version Control: An Overview.” Creating a PostgreSQL Database If you’d like an overview of database software then see the post Databases and Data Management Systems. Since data analysis and management are best learned by doing, the objective of this and future posts is to get readers hands on experience using PostgreSQL and R. In this post, we’ll install pgAdmin and PostgreSQL, and create a database. In the previous post I introduced the learning-data-science GitHub repository, defined forking a repository, and provided instructions for forking the learning-data-science repository and cloning it to your computer.
0 Comments
Leave a Reply. |