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:

http://wiki.postgresql.org/wiki/Developer_FAQ

Happy Hacking :) ! 

Setup Linux for PostgreSQL Development (from Git)

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

Getting your Linux (Ubuntu / CentOS) machine ready for (PostgreSQL related) development

Ubuntu: sudo apt-get install build-essential git libxml2-dev libxslt-dev autotools-dev automake libreadline-dev zlib1g-dev bison flex libssl-dev libpq-dev ccache 

CentOS: sudo yum install git libxml2-devel libxslt-devel automake autoconf readline-devel zlib-devel bison flex gcc openssl-devel

Get Postgresql source (from Git)

• git clone https://git.postgresql.org/git/postgresql.git
• Would take some time (~1-15 minutes) but YMMV
• ./configure --prefix=/opt/postgres/master --enable-depend --enable-cassert 
• make -j4
• sudo make install
• cd contrib
• make -j4
• sudo make install
• /opt/postgres/master/bin/initdb -D /opt/postgres/master/data
• /opt/postgres/master/bin/pg_ctl -D /opt/postgres/master/data -l logfile start

If you want to know more about hacking on PostgreSQL in general, you could always refer to the (very) detailed PostgreSQL Developer FAQ:

http://wiki.postgresql.org/wiki/Developer_FAQ

Happy Hacking :) ! 

git checkout master && git pull && ./configure --prefix=/opt/postgres/master --enable-depend && make -j`nproc` && sudo make install && cd contrib && make -j`nproc` && sudo make install && cd .. && sudo chown -R postgres:postgres /opt/postgres/master

Setup Ubuntu for PgAdmin Development (from Git)

This article is a primer for those wanting to start developing on PgAdmin on an Ubuntu 12.10.

Getting Ubuntu ready for 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 libwxgtk2.8-dev
• sudo apt-get install libssl-dev

Install PostgreSQL Database

• Click here for detailed steps.

Get PgAdmin source

• mkdir pgadmin
• cd pgadmin/
• git clone git://git.postgresql.org/git/pgadmin3.git
• Would take some time (~10 minutes) but YMMV
• cd pgadmin3/
• bash bootstrap
• ./configure
• make
• make install

These steps should give you a freshly compiled PgAdmin3 binary, customized for your system.

Ubuntu is just too good !!!

Pending my previous post, I tried Ubuntu on my desktop system, and I am impressed :) !!

The reason ? Well I believe the most important reason is that 'It Just Works !!'.

Besides, on a macro scale, I found the following reasons as to why I am pretty impressed with Ubuntu:

• There is only one application for each task. (for e.g. There is one music player, one video player, one browser, one email client. And all of them just work out of the box).
  
• Things that shouldn't bother me, don't. (for e.g. I am never enquired about my IP address, gateway, workgroup name, dns server, mouse name, screen refresh rates, ... hufff, ... or the scores of things that linux distributions commonly ask)
• It Just Works !!!
  

If you need to try a 'powerful' linux distribution, please try Ubuntu (version 6.10)

If browsing, email, songs and movies is all you do. You'd probably love it. And me a programmer, if I am beginning to really like, I think you can understand why you ought to try it out.

.
.
.

I did learn quite a few things along the way, and I'd be posting everything that I learnt in the upcoming posts.

... till later.