Showing posts with label database. Show all posts
Showing posts with label database. Show all posts

Monday, November 25, 2013

Start/Stop PostgreSQL on Mac

Start PostgreSQL:-
sudo -u postgres /Library/PostgreSQL/9.3/bin/pg_ctl -D /Library/PostgreSQL/9.3/data start
Stop PostgreSQL:-
sudo -u postgres /Library/PostgreSQL/9.3/bin/pg_ctl -D /Library/PostgreSQL/9.3/data stop
Stop PostgreSQL from auto-starting on reboot:-
sudo launchctl unload -w /Library/LaunchDaemons/com.edb.launchd.postgresql-9.3.plist 
Make PostgreSQL auto-start on reboot:-
sudo launchctl load -w /Library/LaunchDaemons/com.edb.launchd.postgresql-9.3.plist 
Refs
http://www.xtuple.org/faq/xtuple-faq/postgresql/how-do-i-stop-postgresql-service-mac 
https://gist.github.com/abhishekdev/1960888

Sunday, May 15, 2011

Running Oracle SQL Developer 3.0 on Ubuntu

This free graphical tool from Oracle looks very powerful for database development and seems to be equivalent to Microsoft SQL Server Management Studio. Its feature list is quite impressive. This version (v3.0.04.34, March 2011) incorporates Data Modeler and Query Builder support. It can also make a read-only connection to non-Oracle databases (MySQL, SQL Server, MS Access, Sybase, DB2 UDB and Teradata).

  • Download "SQL Developer for other platforms" from Oracle and unzip it.
  • Create a new directory called ".sqldeveloper" in the home directory.
  • Create a new text file called "jdk" in ".sqldeveloper" and add a JDK (Java Development Kit) installation path to the file; for example,
/usr/lib/jvm/java-6-sun
  • Allow the uncompressed "sqldeveloper.sh" to be executed as program.
  • Run "sqldeveloper.sh".