Skip to main content
SimilarExport ZIP
100%

PostgreSQL installation tutorial

✓ Published0🌍 Public
115Dkatz
Last edited Oct 12, 2017
Created on Oct 12, 2017

This example presents a step-by-step guide for installing PostgreSQL across macOS, Linux, and Windows. It shows the terminal command `psql -U postgres` as the target for verifying a successful setup, then details OS-specific actions, such as using the Postgres.app on macOS, compiling from source via `wget` on Linux, and using the EnterpriseDB installer on Windows. The tutorial also covers checking the `$PATH` variable and verifying the server port with `lsof`.

AI-generated description

Similar vizzes

Loading thumbnail…

PostgreSQL command line cheatsheet

This example presents a text-based cheat sheet for PostgreSQL command-line tools, rendering a curated list of psql commands, configuration snippets, and handy SQL queries in a plain markdown document. It shows the core syntax for database management tasks, such as connecting to databases, listing tables and views, managing user roles, and adjusting server logging verbosity, alongside query examples for inspecting indexes, active sessions, and table sizes. The visualization relies on static code blocks and inline formatting, with no interactive graphics or JavaScript libraries; instead, it leverages the raw text content from a gist, emphasizing practical API references like `psql` meta-commands and `pg_stat_activity` queries.

AAngieLiang
68% match
Loading thumbnail…

Gist 9c2be44cd98af2520970bd40718e19fe

This example documents the manual installation steps for MongoDB on a Windows system. It shows a text-based procedure, outlining the sequence from downloading the installer, creating a data directory, setting an environment variable, and finally launching the database via the command line with `mongod --dbpath`. The presentation is a static list of instructions without any interactive visualization or external libraries like D3 or Three.js, relying instead on plain text formatting to convey the process. The data source is the gist's own authored content, with no rendering code involved.

MMistyBlunch
57% match
Loading thumbnail…

Gist 0c701eddfaa4b93ee172

Two terminal sessions show failed attempts to import OpenStreetMap data into a PostgreSQL database using Osmosis, a Java command-line tool. The visualization captures log output from sequential runs of the `osmosis` command, displaying errors from Java's `java.net.ConnectException` when the database connection is refused. The first attempt fails because the `--truncate-pgsql` task receives an unexpected `port` argument, while the second fails because PostgreSQL is not running. The display highlights the pipeline's reliance on database configuration and connection handling, rendered as plain terminal text.

CCaged
56% match
Loading thumbnail…

Configure macOS Catalina to connect to Oracle DB using RStudio and odbc library

This example demonstrates how to connect RStudio on macOS Catalina to an Oracle database using the odbc and DBI libraries. It shows the complete setup process, including installing unixODBC via Homebrew, downloading Oracle Instant Client files, configuring environment variables in `.bash_profile`, and editing the `odbc.ini` file to define the data source. The code uses `DBI::dbConnect()` with the `odbc::odbc()` driver to establish the connection and a SQL query `select sysdate from dual` to verify the setup.

MMattNickodemus
54% match
Loading thumbnail…

Shell script to import data into Postgres from https://www.nhgis.org. If you use this, you'll need to edit line 14 to include the census data you're importing.

This script sets up a Postgres database to hold U.S. Census block-group data, combining demographic race counts with spatial geometries. It first imports CSV race data into a table, then converts shapefiles to a uniform projection (EPSG:4326) using `ogr2ogr` and appends them via `shp2pgsql`. The code uses PostGIS for geometry support and creates a spatial index on the `geom` column. It relies on command-line tools like `dropdb`, `createdb`, and `psql`, processing files from the NHGIS source archive. The final output enables querying joined attribute and spatial data.

CCaged
50% match
Loading thumbnail…

A seed file for the Rate My Setup application

This seed file for the Rate My Setup application populates a PostgreSQL database with initial user, post, and rating records. It demonstrates structured SQL `INSERT` statements that define three user accounts with hashed passwords, two image posts with Unsplash URLs and captions, and three numeric ratings linking specific users to posts. The example showcases the database schema underlying the application's data model.

JJastor11
50% match
Loading thumbnail…

Gist b6841d55375225f550b287b3e0632119

This example demonstrates how to install Node.js and npm on Ubuntu 18.04 using shell commands, providing a step-by-step reference. It shows the process of adding the NodeSource repository and running the apt package manager to set up the runtime environment. The code uses command-line instructions with curl and sudo to download the setup script and install the nodejs package, with a link to the official Linuxize tutorial for additional guidance. The visualization is not graphical; it is a plain-text procedural guide.

MMistyBlunch
50% match
Loading thumbnail…

Gist 37128af71824779d01db3758902ca8ed

This example visualizes the installation steps for Node.js on Ubuntu using a procedural, code-driven diagram. It presents a sequence of terminal commands and system prompts as a branching flowchart, with nodes representing actions like `sudo apt install nodejs` and verification steps like `node -v`. The visualization uses D3.js to render the graph, likely employing `d3.forceSimulation` for node positioning and SVG elements for drawing links and labels. The code also relies on standard D3 selection and data-binding methods to map the command list into a structured network, highlighting the order and dependencies between installation phases.

MMistyBlunch
50% match