Learning is an Art

At times we need to export the data from database to a comma seperated file(CSV) through psql command terminal, here is a quick and easy way to do it

WANdisco is offering some free online training sessions over the next few weeks, for any that are interested.

The topics will include:

Introduction to Subversion for Developers – 5th May

All About Subversion Hook Scripts – 19th May

Using Subversion Locking – 2nd June

All About Subversion Checkouts – 16th June

Using the Subversion Diff Command – 30th June

Branching and Merging in Subversion 1.6.9 – 14th July

Feel free to see the website for more information:
http://wandisco.com/webinar/subversion/training

To install latest version of postgresql we first we need to add pgdg repository to list of repositories open terminal and fire following commands, you need to be root.

Once repository is installed properly use yum to install postgresql as shown below

You can do above in a single line choice is yours.

Initialize the database

Start the database server

Voila your database server is setup and ready to use.

Here I am with my first youtube upload I have been trying a while to do some videos for demos but was not able to do it, so I went ahead first created a flash demo using wink and after googling around for a while I came across nice utility from iWisoft which is flash to video converter and conversion was pretty easy and straight forward. There is no audio added to it, I have used annotations for explaining things where ever required. This was my maiden effort may not be that good but still someone might find it useful, enjoy and have fun.

This video covers some basics of TortoiseSVN a client for Subversion.
Steps covered are checking out your code, adding some existing content, commiting changes to repository, reverting to older revision and how to view log and compare two revisions.

In this article I am going to put on links to various useful Subversion resource available on internet which can get you started with using Subversion easily; whether you are end user or a developer looking for an API for language of your choice and I hope you all can contribute to grow this list further I am aware that there is exhaustive list already available on tigris site.

Lets start this list

Subversion Home : Home of the great tool you can find the binaries for latest version from the website based on operating system of your choice it also includes collabnet certified binaries.

TortoiseSVN : Most preferred Subversion client for windows

VisualSVN : Great tool to get you started quickly with Subversion without any hassles comes with Apache and wizard based setup is just awesome for newbies

AnkhSVN : Visual studio integration for all M$ fans

RapidSVN : Multi-platform GUI front-end

SVNKIT : Java API for Subversion, pretty easy to get started lot’s examples available and documentation is just awesome

PySVN : Python API for Subversion, nice pythonic interface, some people might differ and point out Subvertpy is more pythonic, I like both of them equally.

This list is In progress and I will keep updating it.

I recently setup Subversion on Centos as well as RHEL, so thought will share the steps followed though it’s pretty straight forward it will help people looking for it and will be available to me for future references as well

Step1 Install rpmforge repository

Step2 Install Subversion

Step3 Install mod_dav_svn (Only required if you planning Apache Integration)

Voila and you are done, go to command prompt and type following

You should see output as below

I just go a mail on Subversion mailing list informing that today is the 6th Birthday of Subversion for those who are thinking what is Subversion they can read here.

So Subversion has come along pretty well since it’s 1.0 release 6 years back and this day I would like to thank all developers who have put in there efforts to make Subversion what it is today; it stands tall among the many commercial tools.

So how I celebrated the Subversion’s birthday I went to svnforum.org and tried to answer queries of people as thats the way you can help Subversion adoption to grow among masses.

Developers are doing there bit by developing it; so we as a part of community need to contribute in what ever way possible.

This day I wish many many happy returns of the day to Subversion and want to congratulate Subversion community for great going looking ahead to more great accomplishments in future.

Few days back I was trying to create database in a batch job using createdb.exe and I encountered this problem createdb.exe prompts for password and there is no way of passing password from command line as an argument.
I tried to find out how to do this but in vein there is no way you can pass password as an command line argument; than after looking around for sometime and googling I found two ways of doing it

• Setting up PGPASSWORD environment variable : This method is not preferable as it’s insecure more for further details read this

• Setting up password in pgpass.conf : The file is to be located
  %APPDATA%\postgresql\pgpass.conf

File has the following format

Each of the first four fields may be a literal value, or *, which matches anything.

For further details the postgres documentation

Here I am going to talk about three useful and handy subcommands  of svnadmin that will help us in dumping our data and restoring it back to fresh repository, restore is very critical, as we keep on backing up data but we seldom bother about restoring it to check if everything is working fine or not. I would like to put one point across that your backup is as good as your last restore.

Dumping the repository

This is the simplest option for dumping the repository for purpose of backing up your repository. If you want to do an incremental back than you need to specify –incremental flag and give start and end revision for same.

Restoring the repository back

Verify the restore

Habit of restoring the data regularly is very important for having usable backup.

This article covers how to setup domain authentication for Subversion with Apache using mod_auth_sspi , I am running Apache 2.2 and Subversion 1.5. First of all you need to get SSPI module from its new home at sourceforge , module can be directly downloaded from here. Once you have downloaded the module extract using some zip utility there will be a bin folder inside the extracted folder and inside bin folder there will a file named mod_auth_sspi.so take this file and drop it in Apache’s modules folder.

Once you are done with above steps we now need to modify Apache’s httpd.conf to include the domain authentication for our Subversion repository make changes to httpd.conf as shown below,  first we need to ensure that we have required modules loaded

To mod_dav_svn to work you need to uncomment the line which loads mod_dav module Apache look for it and uncomment if its commented.

Now the real magic configuration starts which will enable us to authenticate Subversion users against AD domains make changes in httpd.conf as shown below

Once done with above changes save the file and restart Apache and try accessing the URL http://<yourservername>/svn/myrepo you will be prompted for authentication saying “Subversion Domain” enter your domain name without domain as we have SSPIOmitDomain On and based on Subversion authorization file i.e authz in our scenario you will be able to see repository or you will get forbidden error.

We are done with setting up domain authentication, in-case you face any problem with above settings feel free to write to me.

LoadModule sspi_auth_module   modules/mod_auth_sspi.so
LoadModule dav_svn_module     modules/mod_dav_svn.so
LoadModule authz_svn_module   modules/mod_authz_svn.so