Installing PostgreSQL on your Pardus Linux

Let's say that you want to play around with a sql database engine...
I personnaly recommand PostgreSQL, it will satisfy your needs and seems to be the most inovative gpl kid in the database town.
In Pardus installing it is performed by installing the postgresql-server package.
You can optionnally install the kPoGre package which is a kde administration tool for postgreSQL.
To install these, use PiSi of course... you can do it using the command line or the click-o-friendly gui frontend as you prefer ^^
Once you are done downloading and installing, start your postgreSQL engine through the ServiceManager module of TASMA your Pardus Control Center.
Select your PostgreSQL Database Server and start it up...
Now you need to create a role to your username...
For this you need to create your user in postgreSQL, and to achieve that, you have to call createuser from the postgres user.
amine@dan ~ $ su
Password:
dan amine # su postgres
postgres@dan amine $ createuser amine
Shall the new role be a superuser? (y/n) y
CREATE ROLE
Obviously you would have changed amine by your username ^^
Now that you are known by postgreSQL as a superuser, you can come back to your regular being, and create the database you will be using.
To do so, call the createdb command with the database name...
postgres@dan amine $ exit
dan amine # exit
amine@dan ~ $ createdb example
CREATE DATABASE
Now that the database is created, let's play around with it...
You can use kPoGre if you have installed it (for the Gui Lover :-), or give a try to the command line interactive terminal :
amine@dan ~ $ psql -d example
Welcome to psql 8.1.9, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

example=#
Congratulations, you are ready for playing with your freshly installed fully fledged database engine !
Tip : If you don't like typing psql -d databaseName everytime,  just use your username as databaseName... psql will try that one by default if called without arguments...
Have fun !

Svn server... out of the box... or almost ^^

Pardus Linux gives the opportunity to start your own local svn server very quickly !
Just launch Tasma, your friendly Pardus Configuration Center, and from the System module, click on the Service Manager.
Here you can see listed as an available service (but not currently running) the SVN server.
Click on it and then run it...
Wait young Jedi, you are not totally done yet ! ^^
If you type ps -eaf | grep svnserve in your Yakuake (I am in love with this terminal since the first day I launched it !), you will find something like this :
apache 3755 1 0 23:55 ? 00:00:00 /usr/bin/svnserve --foreground --daemon --root=/var/svn

Oh ho... has Pardus made it work directly...
well not really... Actually there is no such thing as /var/svn yet !
First thing first let's create the directory :
$ su
# mkdir /var/svn
In order to create repositories, you have to use svnadmin :
# svnadmin create /var/svn/repository

Have a look at http://svnbook.red-bean.com/en/1.1/ch06s03.html for more information as how to
administer your server...
Personnally I prefer accessing it through ssh.
In order to do that, use your Service Manager to fire the ssh server... and then you can access your svn server thanks to the url :
svn list svn+ssh://localhost/var/run/repository
It will ask you for a password and then will not give you any error message... meaning your server is ready for the initial import !!
Enjoy !

Let's get started

I thought I had to start a blog and be serious about it...
But I just kept delaying and procrastinating...
But pardus made it happen ! ^^
It's an amazing linux distribution made in Turquey.
The distribution was so great, that I felt that I had to try to help the developpers there in return...
I ended up contacting the fine people at Pardus to try to help the french translation.
In return I was given a developer access in no time, and asked if I had a blog to be linked to the pardus planet !
And here the blog is created ^^
More to come soon !