Linux-Postgres Musings

To take a dump from linux server and compress it
psql -U username -F filename
psql -U postgres -d postgres -f chameli.sql
pg_dump -U postgres postgres -f  /tmp/chameli.sql
tar -cvzf abc.tar.gz chameli.sql
tar -zcvf archive-name.tar.gz directory-name
To use a dump file to setup db in win machine 
Use
pg_restore.exe --host "localhost" --port "5432" -U "postgres" --dbname "postgres" --verbose --schema "public" "C:\Users\abhinav\Downloads\new03march.backup"

Comments

Post a Comment

Popular posts from this blog

Using cookies with HttpURLConnection

Before the advent of REST, we services were stateful. There were cookies sent with every HTTP request to maintain the state of the client using the services. When we use HttpURLConnection (Java) we need to discretely mention the cookies in the header and store it somewhere for maintaining the session. Below is an attempt using a singleton class for maintaining the session details and some sample HTTP methods: First our Singleton to maintain the cookies in memory between successive transactions: package singletonCookieManager; import java.net.CookieManager; /**  * @author absin  *  */ public class EaqerInitializedCookieHelper { private static final CookieManager instance = new CookieManager(); // private constructor to avoid client applications to use constructor private EaqerInitializedCookieHelper() { } public static CookieManager getInstance() { return instance; } } Next, wherever you want to use this class initialize it as such private static jav
Read more

SPARQL

Sparql can be used to query structured data sets like DBPedia. These queries can be run on SPAQL enpoints like http://lod.openlinksw.com/sparql or http://dbpedia.org/sparql/. The queries can be slightly different, but for an experienced SPARQLer (which I hope to be one day) this won't be a problem. Here are a few of my first queries, the structure will be purpose followed by the query: The urban and metro population of Patna PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX dbr: <http://dbpedia.org/resource/> select ?populationUrban  ?populationMetro where {   dbpedia:Patna  dbo:populationUrban ?populationUrban;                  dbo:populationMetro ?populationMetro  . } Details of Hemmingway: prefix dbpedia: <http://dbpedia.org/resource/> prefix dbpedia-owl: <http://dbpedia.org/ontology/> select ?abstract ?thumbnail where {    dbpedia:Ernest_Hemingway dbpedia-owl:abstract ?abstract ;                            dbpedia-owl:thumbn
Read more

ffmpeg for Google Speech API

ffmpeg -i call.mp3 -acodec pcm_s16le -ar 16000 call.wav  The following command will convert an audio file into a mono wav at a specified sample rate of 8000: ffmpeg -i /home/absin/Downloads/RT7345201f37e6ae014fcbbc353400bce8.mka -ar 8000 -ac 1 /home/absin/Downloads/audio.wav The following command will take a frame from a video ffmpeg -i input.flv -ss 00:00:14.435 -vframes 1 out.png
Read more