Subversion in Debian server/Ubuntu client

#In the debian server :

#Create an empty data repository
cd /data/aaworks/
svnadmin create R_repository

#Import already existing source files into it
svn import SeaWiFS_bio/Rfiles/Ekumen_R/ file:///data/aaworks/R_repository/Ekumen_R/

#List the imported files
svn list file:///data/aaworks/R_repository/Ekumen_R

#Create a working directory and checkout
cd ~
mkdir Ekumen_R/
svn checkout file:///data/aaworks/R_repository/Ekumen_R

cd Ekumen_R/
svn list

#After modifiying a source file, one can commit :
svn commit

#You can checkout files in the ubuntu client through ssh :
svn checkout svn+ssh://ekumen/data/aaworks/R_repository/Ekumen_R

Configuring postgresql in debian

After the installation from the debian packages, you should run :

sudo pg_createcluster 8.3 main

To make the server listen to the network edit /etc/postgresql/8.3/main/postgresql.conf and modify it to read :

listen_addresses = '*' # what IP address(es) to listen on;

and edit /etc/postgresql/8.3/main/pg_hba.conf and add a line for each user you would like to authorize the user called "myuser" who is located on network 201.171.245.62/32 for using the database "mydb" :

host mydb my user 201.171.245.62/32 md5

and then grant privileges to that user on the table geometry_columns :

psql mydb
GRANT select, insert, update, delete ON TABLE public.geometry_columns TO myuser;

debian : locales problem

export LANGUAGE=en_US.UTF-8
export LANG=en_US.UTF-8
export LC_ALL=en_US.UTF-8
locale-gen en_US.UTF-8
dpkg-reconfigure locales

debian : choosing java VM

update-alternatives --config java
update-alternatives --config javac