Install in 6 easy steps

Never used the BigSQL PostgreSQL Distributions before? Follow these 5 easy steps. Already have BigSQL pgc installed? Jump to step #3.

  1. Read this short introduction to BigSQL’s package and update manager (pgc).

  2. Install pgc via command line to a sandbox:

    MAC / Linux:

    python -c "$(curl -fsSL http://s3.amazonaws.com/pgcentral/install.py)" 
    

    Windows:

    @powershell -NoProfile -ExecutionPolicy unrestricted -Command "iex ((new-object net.webclient).DownloadString('http://s3.amazonaws.com/pgcentral/install.ps1'))"
    
  3. Get into the product home directory by navigating via command line to the bigsql directory. Windows users don’t prefix the pgc command with ./ as shown in the below examples:

    cd bigsql
    
  4. Using the pgc command line tool, run the update command to get the lastest distribution:

    ./pgc update
    
  5. Then run the install, init, and start commands on pgdevops:

    ./pgc install pgdevops
    ./pgc init pgdevops
    ./pgc start pgdevops
    
  6. Open pgDevOps in browser:

    localhost:8051
    

What you get:

Easily build PostgreSQL development environments:

Eliminate wait times by giving developers the power to standup precompiled PostgreSQL versions on Windows, Linux, and Mac.

One-click PostgreSQL component installs:

In the package manager dashboard choose from an extensive list of community projects to extend your PostgreSQL capabilities.

Monitor your PostgreSQL databases:

Intuitive graphs, metrics, and one-click access to logfiles make it easy to monitor the implications of changes to code, queries, and infrastructure.

The plProfiler Console creates performance profiles of PL/pgSQL functions and stored procedures and increase efficiency of your code.

The pgBadger Console gives you advanced log analysis features.

Want to learn more about the DevOps philosphy behind BigSQL’s pgDevOps development? Read DevOps: Can’t we just all get along?

Got questions or suggestions? Get in touch with us at BigSQL Feedback.