Tag: databases

Complete Un-installation of PostgreSQL from Mac OS X Lion

Complete Un-installation of PostgreSQL from Mac OS X Lion

In response to a question on stackoverflow, here is a short guide on how to completely uninstall PostgreSQL 9.1 from Mac OS X Lion.

  1. Open a terminal window

    Utilities->Terminal

  2. Run the uninstaller

    sudo /Library/PostgreSQL/9.1/uninstall-postgresql.app/Contents/MacOS/installbuilder.sh

    PostgreSQL Uninstall Wizard
    PostgreSQL Uninstall Wizard in Progress

    Data not removed after PostgreSQL Uninstallation
  3. Remove the PostgreSQL and data folders (Wizard will notify you that these were not removed)

    sudo rm -rf /Library/PostgreSQL

  4. Remove the ini file

    sudo rm /etc/postgres-reg.ini

  5. Remove the PostgreSQL user

    System Preferences -> Users & Groups

    Unlock the settings panel by clicking on the padlock and enter your password

    Select the PostgreSQL user and click on the minus button.

Remove PostgreSQL User

 

ERD Modelling using Barker’s Notation

ERD Modelling using Barker’s Notation

A key process in database development is obviously database modelling and the main diagrams used are ERD. A number of notations exist, some particular to evangelised by particular DBMS. Here I am documenting a short course/notes about ERD modelling using the Barker’s notation, which is greatly adopted by Oracle.

As usual here is the link, do feel free to comment!

Short notes on Barker’s ERD Notation

Theme: Overlay by Kaira