Extracting Oracle Java installation from exe

Reading Time: 1 minute This has been tested in JDK 7. Please download 7Zip application. WinRAR does not assist along this process 1.Download a desired JDK version from prior downloads at http://www.oracle.com/technetwork/java/javase/downloads/java-archive-downloads-javase7-521261.html 2.Create a folder in where you want to keep the jdk, 3.Copy the downloaded .exe file in here, 4.Right click on exe and 7-Zip>>Extract Here, 5.Right click on

Backing up and restoring with pg_dump and psql in PostgreSQL

Reading Time: 1 minute Backing up the data [code] pg_dump –host HOSTADDR –port 5432 –username “wins_qa” –format plain –encoding UTF8 –schema-only –no-owner –file %HOME%”\Desktop\create_query.sql” –schema “wins_qa” “gwinsq01” [/code] this query will; create only creation queries, not involve role owner information, only select the schema “wins_qa”, only select the database”gwinsq01″, For more information consult the PostgreSQL Documentation at https://www.postgresql.org/docs/current/static/app-pgdump.html   Restoring