25 Apr 2013

PgAdmin doesn't (directly) support restoring from PLAIN format backups (yet)


Was working with my team at office recently and had a request from the team to learn how to 'Restore' an existing backup using PgAdmin. I thought this was easy, since PgAdmin allows for both 'Backup' and 'Restore' but investigating further, I found that PgAdmin only allows for Restore in formats other than 'PLAIN'.

Cross-checked this on the internet and found references here, here and here saying the same thing. 

PgAdmin doesn't (directly) support Restore'ing from plain text backups. To restore a backup, backed up using PLAIN format, you'd need to pass it through a command line utility called 'psql' that is available in both PgAdmin as well as postgres server installations.

I think it's high time that PgAdmin support this feature, especially when all the building blocks are already in-place. Lets see if I could take out time and submit a patch for this.

... till later.

26 Mar 2013

Christian Marriage Registration (Delhi, India)

(Please scroll down to the read the entire-post to know more)



Documents required for Christian Marriage Registration
(a.k.a. Documents required for Solemnization and Registration of Marriages under Indian Christian Marriage Act, 1872)

Workflow to get your Christian Marriage
Registered with the Delhi Government

  • Who: Mr. Kom (Joint Registrar, Christian Marriage Act)
    • He doesn't do Special Marriage Act. etc. He is the *ONLY* person authorized for marriages solemnized in Delhi. One user commented him to be a very down to earth / humble / helpful person, however, as with all Marriage Registrars, he is very particular about Documentation / Process.
  • Where:  ITO, Sales Tax office , 4th floor, A.C.P. office. (Sometimes rooms change, please confirm room at reception first)
    • This address is correct as of ~December 25th 2016. 
  • Fee
    • Rs. 200/- If requesting Registration within 1 month of Marriage
    • Rs. 700/- If requesting Registration after 1 month of Marriage
    • Rs. 1500/- If requesting Tatkal Marriage Registration
  • When: Take an appointment
    • Please read comments (Paul and Mona) below to know the phone number, or you can approach the venue and take an appointment.
  • Documentation: (Carry originals. Recommended to carry a photocopy) 
    • Pastor License
      • Mandatory
    • Pastor Letter (on Church Letterhead)
      • Generally asked if marriage took place outside Delhi
    • Photographs
      • 6-8 Individual Passport size each
      • Joint-photographs of Husband / Wife
      • Marriage Pictures / Wedding Invitation Card if possible
    • Delhi based Identification Proofs (PAN / Aadhaar / etc.)
    • 2 witnesses and two ID proofs (aadhaar / pan) for each witness
      • Collect witness application form from concerned office
    • Affidavit for each Witness (stating they were present at the wedding)
      • Required only if the 2 Witness (required during Marriage Registration) are *not* the same 2 Witnesses that signed in the Church Marriage Certificate
    • Other documents
      • If one (of those getting married) comes from a different religion
        • Carry a Church Baptized Certificate
      • If one is a Foreign National
        • A No-Objection certificate from the Embassy (of the foreign national) in India
      • If one is a Divorcee
        • A copy of divorce papers 


28 Jan 2013

Setup Ubuntu for PostgreSQL Development (from tarball)

This very brief article is a primer for those wanting to start developing on PostgreSQL (on Ubuntu 12.10):

Getting Ubuntu ready for (PostgreSQL related) development

  • sudo apt-get install build-essential
  • sudo apt-get install git
  • sudo apt-get install libxml2-dev
  • sudo apt-get install libxslt-dev
  • sudo apt-get install autotools-dev
  • sudo apt-get install automake
  • sudo apt-get install libreadline-dev
  • sudo apt-get install zlib1g-dev

Get Postgresql source

  • Download: http://ftp.postgresql.org/pub/source/v9.2.2/postgresql-9.2.2.tar.bz2
  • tar -jxf postgresql-9.2.2.tar.bz2
  • ./configure
  • make
  • make install
If you want to know more about hacking on PostgreSQL in general, you could always refer to the (very) detailed PostgreSQL Developer FAQ:
Happy Hacking :) !