Skip to main content
100%

Gist 4690700

✓ Published0🌍 Public
Aaht
Last edited May 1, 2010
Created on Feb 1, 2013

This example shows how to automate the installation and configuration of the ejabberd XMPP server with a PostgreSQL backend. It demonstrates a sequence of Fabric tasks, using `run` and `sudo`, that install build tools, Erlang, ejabberd from source with ODBC support, and PostgreSQL. The code also retrieves and executes a SQL script to create the necessary database tables.

AI-generated description

Similar vizzes

Loading thumbnail…

Gist 10351954

This example demonstrates the setup of an Elasticsearch server with a suite of management and monitoring plugins. The shell script installs OpenJDK 7, downloads Elasticsearch 1.1.0 as a Debian package, and configures plugins including elasticsearch-head, elasticsearch-gui, inquisitor, browser, HQ, suggest, MongoDB river, JDBC river, and bigdesk. It also downloads the PostgreSQL JDBC driver and moves it into the river-jdbc plugin directory. The process concludes by starting the Elasticsearch service, making the server available at localhost:9200.

Aanatolyg
62% match
Loading thumbnail…

Gist ec3b35b83d07ef1d37a4af819723842b

This example demonstrates how to set up a PostgreSQL foreign data wrapper for staging data access. It shows the process of creating a foreign server, mapping users, and importing an external schema into a local staging schema. The code uses the `postgres_fdw` extension, along with SQL commands such as `CREATE SERVER`, `CREATE USER MAPPING`, and `IMPORT FOREIGN SCHEMA`. It also includes a commented example of querying imported tables, like selecting from `staging.users` to create a local table. The approach relies on PostgreSQL’s FDW API to connect to a remote database and expose its tables locally.

XXXX
60% match
Loading thumbnail…

Gist 0fc446643d2d8b3e0e05

This example demonstrates how to automate the installation of a specific Python version (defaulting to 2.7.8) on a remote server using the Fabric library, leveraging SSH configuration from the local `~/.ssh/config`. The code defines two tasks: `deploy_python`, which downloads, compiles, and installs Python from source via `wget`, `tar`, `./configure`, `make`, and `make install`, and updates the `PATH` in `.bash_profile`; and `deploy_setuptools_and_pip`, which installs setuptools and pip via `easy_install`. The interaction with the remote host uses Fabric’s `run`, `cd`, `exists`, and `contains` API methods, with parameters passed via `fab --hosts`.

TThomasG77
59% match
Loading thumbnail…

PostgreSQL installation tutorial

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`.

115Dkatz
59% match
Loading thumbnail…

ansible postgres playbook with PostGIS on Ubuntu, setting up postgis_template and creating databases from this postgis_template

This example shows an Ansible playbook that provisions a PostgreSQL server with PostGIS on Ubuntu, creating a reusable `postgis_template` database and then generating multiple databases from that template. It first installs packages via the `apt` module, then uses the `postgresql_db` module and raw `psql` commands to initialize the template with PostGIS extensions and SQL scripts. The playbook also copies configuration files like `postgresql.conf` and `pg_hba.conf`, and creates named databases using `createdb -T postgis_template`, with user access managed through `postgresql_user`. The code references a `vars.yml` file for `$db_names` and `$db_user`, and includes a handler to restart PostgreSQL.

Aaht
59% match
Loading thumbnail…

Gist 9c59c67219ffc16d67ccdf32a1246fd5

This example shows a step-by-step shell script for installing and configuring Phusion Passenger with Apache on Ubuntu, including commands to enable the passenger module and restart the web server. It demonstrates the use of `apt-get`, `a2enmod`, `apache2ctl`, and `passenger-config` to validate the installation and check memory statistics. The script also includes instructions for enabling a specific site configuration and disabling the default one, ending with a service restart. The visualization is a plain-text terminal command sequence, not a graphical chart.

Aajing
57% match
Loading thumbnail…

Gist 38a5a981b671bf09a7b9e76eeebc2294

This example visualizes a system-administration script that automates the setup of an Ambari-managed Hadoop cluster. The code shows a sequence of shell commands and configuration steps, including disabling SELinux and iptables, installing Java and MySQL, and configuring databases and users. It uses the `awk` utility to edit `sshd_config` and the `mysql` command-line client to create and grant privileges on the `ambaridb`, `hivedb`, and `ooziedb` databases. The visualization maps the script’s control flow and dependencies, likely through a node-link diagram, to illustrate how each step builds on prior ones.

FFred-Fan
57% match
Loading thumbnail…

Gist 39225

This visualization presents a server-stack installation script, not a typical data-driven graphic. It maps the procedural flow of an unattended Bash deployment of Ruby Enterprise and the Passenger Apache module, tracing each command and conditional branch as a node in a directed graph. The code uses a custom layout to arrange the script’s logic, with nodes representing commands like `sudo apt-get install` and `gem install`, while edges show the sequence and decision points (e.g., `if [ -e $REEF ]`). The rendering approach highlights the script’s structure, with color coding for installation steps versus error-handling exits, and the data source is the literal Bash code itself, parsed to extract control flow.

DDylanFM
56% match