BAM - BigSQL Manager

BAM is an easy to use graphical PostgreSQL update and application manager that enables you to install multiple versions of Postgres, install related community projects and services (like PostgreSQL Studio and ODBC drivers) along with developer tools such as Java and Perl and control running services.

BAM Installation

BigSQL Manager is installed by default with the Windows and OSX graphical installer.

For Linux or to install in a BigSQL sandbox, use PGC command line to download and install.

1. Navigate to the location of your pgc instance. On my OS X system this was in the User home directory -- ~/PostgreSQL .

$ cd ~/PostgreSQL

2. Install bam2


$ ./pgc install bam2
['bam2']
Get:1 http://s3.amazonaws.com/pgcentral bam2-1.1.0
  Unpacking bam2-1.1.0.tar.bz2

3. Check pgc status.


$ ./pgc status
pg95 running on port 5432
bam2 stopped on port 8050

Start BAM

Start bam from the pretty good command line interface (pgcli)


$ ./pgc start bam2

BAM GUI

Now open up your favorite web browser and navigate to the following URL => http://localhost:8050

You should see a list of installed and available components. You can use the the package manager to download, install, or remove components. You can also stop and start already installed server components:

Status

To see a live snapshot of your system status, navigate to the "Status" page using the menu on the left:

PostgreSQL Detail

Click through the name of a component to get to the components details page to see configuration details, to start or stop a server, or learn about the community who developed the component. For PostgreSQL, details include a real-time monitoring view of the database activity and configuration information.

Test/Beta Components

If you are interested in testing beta versions of PostgreSQL and components being added to the BigSQL distributions, turn on test components in settings. This enables you to see the full list of components in test or beta quality and try them in a development (non-production) setting.

In your settings, you can choose to show test components.

You will be able to see all test/beta components in the component list, highlighted in yellow.