[DebianGIS-dev] CVS Update: postgis/debian/sofiles.in copyright mktemplate_gis mktemplate_gis.sh postgis_env.sh postgres_lib.sh postgresql-@pg_majdotmin@-postgis#SONAME#.dirs postgresql-@pg_majdotmin@-postgis#SONAME#.docs postgresql-@pg_majdotmin@-postgis#SONAME#.install postgresql-@pg_majdotmin@-postgis-utils.dirs postgresql-@pg_majdotmin@-postgis-utils.docs postgresql-@pg_majdotmin@-postgis-utils.install postgresql-postgis-common.conffiles postgresql-postgis-common.dirs postgresql-postgis-common.docs postgresql-postgis-common.install postgresql-postgis-doc.doc-base postgresql-postgis-doc.docs postgresql-postgis-java-debug.install postgresql-postgis-java.dirs postgresql-postgis-java.docs postgresql-postgis-java.examples postgresql-postgis-java.install postgresql-postgis-utils.dirs postgresql-postgis-utils.docs postgresql-postgis-utils.install postgresql-postgis-utils.manpages postgresql-postgis@major@-examples.dirs postgresql-postgis@major@-examples.install profile rmtemplate_gis rmtemplate_gis.sh scriptslink.sh

pabs-guest at haydn.debian.org pabs-guest at haydn.debian.org
Wed Mar 22 15:41:21 UTC 2006


  User: pabs-guest
  Date: 06/03/22 15:41:21

  Modified:    debian/sofiles.in copyright
  Added:       debian/sofiles.in mktemplate_gis mktemplate_gis.sh
                        postgis_env.sh postgres_lib.sh
                        postgresql- at pg_majdotmin@-postgis#SONAME#.dirs
                        postgresql- at pg_majdotmin@-postgis#SONAME#.docs
                        postgresql- at pg_majdotmin@-postgis#SONAME#.install
                        postgresql- at pg_majdotmin@-postgis-utils.dirs
                        postgresql- at pg_majdotmin@-postgis-utils.docs
                        postgresql- at pg_majdotmin@-postgis-utils.install
                        postgresql-postgis-common.conffiles
                        postgresql-postgis-common.dirs
                        postgresql-postgis-common.docs
                        postgresql-postgis-common.install
                        postgresql-postgis-doc.doc-base
                        postgresql-postgis-doc.docs
                        postgresql-postgis-java-debug.install
                        postgresql-postgis-java.dirs
                        postgresql-postgis-java.docs
                        postgresql-postgis-java.examples
                        postgresql-postgis-java.install
                        postgresql-postgis-utils.dirs
                        postgresql-postgis-utils.docs
                        postgresql-postgis-utils.install
                        postgresql-postgis-utils.manpages
                        postgresql-postgis at major@-examples.dirs
                        postgresql-postgis at major@-examples.install profile
                        rmtemplate_gis rmtemplate_gis.sh scriptslink.sh
  Log:
  Add Alex's postgis 1.1 packaging. TODO: patches for stuff outside debian/
  
  Revision  Changes    Path
  1.2       +3 -18     postgis/debian/sofiles.in/copyright
  
  CVSWEB Options: -------------------
  
  CVSWeb: Annotate this file:            http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/copyright?annotate=1.2&cvsroot=
  
  CVSWeb: View this file:             http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/copyright?rev=1.2&content-type=text/x-cvsweb-markup&cvsroot=
  
  CVSWeb: Diff to previous version:   http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/copyright.diff?r1=1.2&r2=1.1&cvsroot=
  
  -----------------------------------
  
  Index: copyright
  ===================================================================
  RCS file: /cvsroot/pkg-grass/postgis/debian/sofiles.in/copyright,v
  retrieving revision 1.1
  retrieving revision 1.2
  diff -u -r1.1 -r1.2
  --- copyright	26 Mar 2005 22:29:30 -0000	1.1
  +++ copyright	22 Mar 2006 15:41:19 -0000	1.2
  @@ -3,23 +3,8 @@
   
   It was downloaded from http://postgis.refractions.net
   
  -Upstream Authors: See /usr/share/doc/libpostgis#SOVER#/CREDITS
  -
  -License: 
  -
  -   This package is free software; you can redistribute it and/or modify
  -   it under the terms of the GNU General Public License as published by
  -   the Free Software Foundation; version 2 dated June, 1991.
  -
  -   This package is distributed in the hope that it will be useful,
  -   but WITHOUT ANY WARRANTY; without even the implied warranty of
  -   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  -   GNU General Public License for more details.
  -
  -   You should have received a copy of the GNU General Public License
  -   along with this package; if not, write to the Free Software
  -   Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA
  -   02111-1307, USA.
  +Upstream Authors: See CREDITS
   
  +This code is released under the terms of the GNU GENERAL PUBLIC LICENSE.
   On Debian GNU/Linux systems, the complete text of the GNU General
  -Public License can be found in `/usr/share/common-licenses/GPL'.
  +Public License can be found in `/@main_prefix@/share/common-licenses/GPL'.
  
  
  
  1.1                  postgis/debian/sofiles.in/mktemplate_gis
  
  CVSWEB Options: -------------------
  
  CVSWeb: Annotate this file:            http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/mktemplate_gis?annotate=1.1&cvsroot=
  
  CVSWeb: View this file:             http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/mktemplate_gis?rev=1.1&content-type=text/x-cvsweb-markup&cvsroot=
  
  -----------------------------------
  
  Index: mktemplate_gis
  ===================================================================
  #!/bin/sh
  
  #create a template database, named template_gis by default,
  #and grant ownership or full privileges to the postgis tables to a user, postgres by default
  
  source /usr/share/postgresql-postgis-common/postgis_env.sh
  
  for ARGVN in $1 $2 $3 $4 $5 $6 ; do
      if [ `expr substr $ARGVN 1 7` = "--user=" ]; then
  		GRUSER=`echo $ARGVN | sed -e s/^--user=//`
      elif [ `expr substr $ARGVN 1 11` = "--template=" ]; then
  	 	TDB=`echo $ARGVN | sed -e s/^--template=//`
  	elif [ `expr substr $ARGVN 1 6` = "--dba=" ]; then
  		DBAUSER=`echo $ARGVN | sed -e s/^--dba=//`
  	elif [ `expr substr $ARGVN 1 9` = "--script=" ]; then
  		PGISSCRIPT=`echo $ARGVN | sed -e s/^--script=//`
  	elif [ "$ARGVN" = "--no-srs" ]; then
  		NO_SRS="true"
      elif [ -n $ARGVN ]; then
          echo "Usage of `basename $0`"
          echo "Supply arguments as follows"
          echo "--user=username to own or be grant privileges on databases"
  		echo "      created from template"
          echo "--template=templatename of the template to create"
  		echo "--dba=dbaname of the dba to run administrational programs as"
  		echo "--script=script to load postgis functions in the database"
  		echo "      if no directory given, default is @pg_datadir@/contrib/"
  		echo "--no-srs: use this option to not load the huge spatial_ref_sys.sql"
  		echo "You must usually be either root, or a postgresql dba or the"
  		echo "cluster owner in order to use `basename $0`"
          exit 1
      fi
  done
  
  if [ -z "`echo $PGISSCRIPT | grep /`" ]; then
  	PGISSCRIPT="/@pg_datadir@/contrib/${PGISSCRIPT}"
  fi
  if [ ! "$NO_SRS" = "true" ]; then
  	SPATIAL_REF_SYS="/@pg_datadir@/contrib/spatial_ref_sys.sql"
  fi
  
  SCRIPTS="$PGISSCRIPT $SPATIAL_REF_SYS"
  GRTABLES="spatial_ref_sys geometry_columns"
  
  source /@pg_bindir@/postgres_lib.sh
  
  sudo_dba DBAUSER
  
  export SCRIPTS GRTABLES GRUSER DBAUSER TDB
  $SUDO -c "/@pg_bindir@/mktemplate_gis.sh"
  
  
  
  1.1                  postgis/debian/sofiles.in/mktemplate_gis.sh
  
  CVSWEB Options: -------------------
  
  CVSWeb: Annotate this file:            http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/mktemplate_gis.sh?annotate=1.1&cvsroot=
  
  CVSWeb: View this file:             http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/mktemplate_gis.sh?rev=1.1&content-type=text/x-cvsweb-markup&cvsroot=
  
  -----------------------------------
  
  Index: mktemplate_gis.sh
  ===================================================================
  #!/bin/sh
  
  #this script should be run as $DBAUSER
  
  PWD1=`pwd`
  
  cd /tmp
  
  source /@pg_bindir@/postgres_lib.sh
  
  check_dba $DBAUSER
  template_rm $TDB
  template_mk $TDB $GRUSER
  
  cd $PWD1
  
  
  
  1.1                  postgis/debian/sofiles.in/postgis_env.sh
  
  CVSWEB Options: -------------------
  
  CVSWeb: Annotate this file:            http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgis_env.sh?annotate=1.1&cvsroot=
  
  CVSWeb: View this file:             http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgis_env.sh?rev=1.1&content-type=text/x-cvsweb-markup&cvsroot=
  
  -----------------------------------
  
  Index: postgis_env.sh
  ===================================================================
  #!/bin/sh
  
  # environment variables for postgis
  
  #read optional configuration files. last prevails
  for file in "/etc/default/postgis" "$HOME/.postgis/profile" ; do
  	if [ -f "$file" ]; then
  		tmpval=`grep "^TEMPLATEDB=" $file | cut -d= -f2`
  		if [ -n "$tmpval" ]; then
  			TEMPLATEDB1=$tmpval
  		fi
  		tmpval=`grep "^GRUSER=" $file | cut -d= -f2`
  		if [ -n "$tmpval" ]; then
  			GRUSER1=$tmpval
  		fi
  		tmpval=`grep "^DBAUSER=" $file | cut -d= -f2`
  		if [ -n "$tmpval" ]; then
  			DBAUSER1=$tmpval
  		fi
  		tmpval=`grep "^PGISSCRIPT=" $file | cut -d= -f2`
  		if [ -n "$tmpval" ]; then
  			PGISSCRIPT1=$tmpval
  		fi
  	fi
  done
  
  #cluster information should be set separately
  if [ -x /@main_bin@/pg_lsclusters ]; then
  	PGCLUSTER=`pg_lsclusters | awk '{if ($3 == ENVIRON["PGPORT"]) {print $1"/"$2;}}'`
  	export PGCLUSTER
  
  	if [ -z $DBAUSER ]; then
  		DBAUSER=`pg_lsclusters | awk '{if ($3 == ENVIRON["PGPORT"]) {print $5;}}'`
  	fi
  fi
  
  if [ -z "$TEMPLATEDB" ]; then
  	if [ -n "$TEMPLATEDB1" ]; then
  		TEMPLATEDB="$TEMPLATEDB1"
  	else
  	    TEMPLATEDB="template_gis"
  	fi
  fi
  if [ -z "$GRUSER" ]; then
  	if [ -n "$GRUSER1" ]; then
  		GRUSER="$GRUSER1"
  	else
  	    GRUSER="postgres"
  	fi
  fi
  if [ -z "$DBAUSER" ]; then
  	if [ -n "$DBAUSER1" ]; then
  		DBAUSER="$DBAUSER1"
  	else
  	    DBAUSER="postgres"
  	fi
  fi
  if [ -z "$PGISSCRIPT" ]; then
  	if [ -n "$PGISSCRIPT1" ]; then
  		PGISSCRIPT="$PGISSCRIPT1"
  	else
  		PGISSCRIPT="postgis.sql"
  	fi
  fi
  
  TDB=$TEMPLATEDB
  
  
  
  1.1                  postgis/debian/sofiles.in/postgres_lib.sh
  
  CVSWEB Options: -------------------
  
  CVSWeb: Annotate this file:            http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgres_lib.sh?annotate=1.1&cvsroot=
  
  CVSWeb: View this file:             http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgres_lib.sh?rev=1.1&content-type=text/x-cvsweb-markup&cvsroot=
  
  -----------------------------------
  
  Index: postgres_lib.sh
  ===================================================================
  #!/bin/sh
  
  SUDO_OTHERUSER="su $DBAUSER"
  SUDO_SAMEUSER="$SHELL"
  
  function sudo_dba()
  {
  	if [ "$USER" != "$DBAUSER" ]; then
  		ISDBASYSUSER=`cat /etc/passwd | awk -F : '{print $1}' | grep ^$DBAUSER$`
  		if [ ! "$ISDBASYSUSER" = "$DBAUSER" ]; then
  			echo "$DBAUSER is not a system user on `hostname`."
  			echo "support for remote servers not implemented yet."
  			exit 1
  		fi
  		SUDO=$SUDO_OTHERUSER
  		if [ ! "$USER" = "root" ]; then
  			echo "you will be prompted for the system password for $DBAUSER,"
  			echo "even more than once."
  		fi
  	else
  		SUDO=$SUDO_SAMEUSER
  	fi
  }
  
  function wrong_cluster()
  {
  	if [ -n "`dpkg-query -W postgresql-common`" ]; then
  		echo "in case you meant another cluster, please specify it explicitly."
  		echo "see pwrapper(1)."
  	fi
  }
  
  #for the following functions, $USER is expected to be $DBAUSER, as set before
  function check_dba()
  {
  	DBAUSER=$1
  	if [ ! "$DBAUSER" = "$USER" ]; then
  		echo "you are not working as $DBAUSER".
  		echo "you may be not allowed to do so (maybe wrong password)."
  		exit 1
  	fi
  	ISDBAPGUSER=`psql -At -d template1 -c "select usename from pg_user where usesuper = true and usename = '$DBAUSER';" 2>&1`
  	if [ ! "$ISDBAPGUSER" = "$DBAUSER" ]; then
  		MAYPOSTGRES=`psql -l`
  		if [ -z "$MAYPOSTGRES" ]; then
  			echo "either postgresql $PGCLUSTER is not running,"
  			echo "or $DBAUSER doesn't have privileges on cluster $PGCLUSTER."
  			wrong_cluster
  			exit 1
  		fi
  		echo "dba or cluster $PGCLUSTER owner privileges are needed for this operation."
  		echo "$DBAUSER doesn't have dba or cluster $PGCLUSTER owner privileges."
  		echo "you may specify a dba that you are allowed to use his/her name (try --help)."
  		wrong_cluster
  		exit 1
  	fi
  }
  
  function template_rm()
  {
  	TDB=$1
  	db_update=`psql -d template1 -c "UPDATE pg_database SET datistemplate = FALSE WHERE datname = '$TDB';" 2>&1`
  	if [ "$db_update" = "UPDATE 1" ]; then
  		dropdb $TDB 2>&1 | cat > /dev/null
  	else
  		echo "$TDB could not be accessed. it may not exist"
  	fi
  }
  
  #environment variables used:
  #$SCRIPTS=spaces separated list of sql scripts to load into new template db
  #$GRTABLES=spaces separated list of tables to be granted access to $GRUSER
  function template_mk()
  {
  	TDB=$1
  	GRUSER=$2
  	#of course it could be better to create as the $GRUSER where system user
  	db_create=`createdb $TDB 2>&1`
  	if [ "$db_create" = "CREATE DATABASE" ]; then
  		GRID=`psql -d template1 -At -c "select usesysid from pg_user where usename='$GRUSER';"`
  	    if [ -n "$GRID" ]; then
  			psql -d $TDB -c "UPDATE pg_database SET datdba = $GRID WHERE datname = '$TDB';" 2>&1 | cat > /dev/null
  	    fi
  		if [ -x /@pg_bindir@/createlang ]; then
  			/@pg_bindir@/createlang plpgsql $TDB 2>&1 | cat > /dev/null
  		fi
  		for script in $SCRIPTS ; do
  			psql -d $TDB -f $script 2>&1 | cat > /dev/null
  		done
  		#pseudo tables for postgresql 7.2 and 7.4. feel free to add more, for other postgresql versions
  		PSEUDO_TABLES="'pg_xactlock', 'sql_features', 'sql_implementation_info', 'sql_languages', 
  					   'sql_packages', 'sql_sizing', 'sql_sizing_profiles'"
  		TABLES=`psql -d $TDB -At -c "select tablename from pg_tables where tablename not in ($PSEUDO_TABLES);"`
  	    if [ -n "$GRID" ]; then
  			for table in $TABLES ; do
  		        psql -d $TDB -c "alter table $table owner to $GRUSER;" 2>&1 | cat > /dev/null
  			done
  	    else #maybe public, or group
  			for grtable in $GRTABLES ; do
  		        psql -d $TDB -c "grant all privileges on table $grtable to $GRUSER;" 2>&1 | cat > /dev/null
  			done
  	    fi
  		psql -d $TDB -c "VACUUM FULL;" 2>&1 | cat > /dev/null
  		psql -d $TDB -c "VACUUM FREEZE;" 2>&1 | cat > /dev/null
  		psql -d $TDB -c "UPDATE pg_database SET datistemplate = TRUE WHERE datname = '$TDB';" 2>&1 | cat > /dev/null
  		psql -d $TDB -c "UPDATE pg_database SET datallowconn = FALSE WHERE datname = '$TDB';" 2>&1 | cat > /dev/null
  	else
  		echo "$db_create"
  	fi
  }
  
  
  
  1.1                  postgis/debian/sofiles.in/postgresql- at pg_majdotmin@-postgis#SONAME#.dirs
  
  CVSWEB Options: -------------------
  
  CVSWeb: Annotate this file:            http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-@pg_majdotmin@-postgis#SONAME#.dirs?annotate=1.1&cvsroot=
  
  CVSWeb: View this file:             http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-@pg_majdotmin@-postgis#SONAME#.dirs?rev=1.1&content-type=text/x-cvsweb-markup&cvsroot=
  
  -----------------------------------
  
  Index: postgresql- at pg_majdotmin@-postgis#SONAME#.dirs
  ===================================================================
  @pg_bindir@
  @pg_libdir@
  @pg_datadir@/contrib
  
  
  
  1.1                  postgis/debian/sofiles.in/postgresql- at pg_majdotmin@-postgis#SONAME#.docs
  
  CVSWEB Options: -------------------
  
  CVSWeb: Annotate this file:            http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-@pg_majdotmin@-postgis#SONAME#.docs?annotate=1.1&cvsroot=
  
  CVSWeb: View this file:             http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-@pg_majdotmin@-postgis#SONAME#.docs?rev=1.1&content-type=text/x-cvsweb-markup&cvsroot=
  
  -----------------------------------
  
  Index: postgresql- at pg_majdotmin@-postgis#SONAME#.docs
  ===================================================================
  README.postgis
  TODO
  CREDITS
  
  
  
  1.1                  postgis/debian/sofiles.in/postgresql- at pg_majdotmin@-postgis#SONAME#.install
  
  CVSWEB Options: -------------------
  
  CVSWeb: Annotate this file:            http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-@pg_majdotmin@-postgis#SONAME#.install?annotate=1.1&cvsroot=
  
  CVSWeb: View this file:             http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-@pg_majdotmin@-postgis#SONAME#.install?rev=1.1&content-type=text/x-cvsweb-markup&cvsroot=
  
  -----------------------------------
  
  Index: postgresql- at pg_majdotmin@-postgis#SONAME#.install
  ===================================================================
  @pg_bindir@/*
  @pg_libdir@/lib*.so.*
  @pg_datadir@/contrib/postgis#SONAME#.sql
  @pg_datadir@/contrib/lwpostgis_upgrade.sql
  @pg_datadir@/contrib/spatial_ref_sys.sql
  
  
  
  1.1                  postgis/debian/sofiles.in/postgresql- at pg_majdotmin@-postgis-utils.dirs
  
  CVSWEB Options: -------------------
  
  CVSWeb: Annotate this file:            http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-@pg_majdotmin@-postgis-utils.dirs?annotate=1.1&cvsroot=
  
  CVSWeb: View this file:             http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-@pg_majdotmin@-postgis-utils.dirs?rev=1.1&content-type=text/x-cvsweb-markup&cvsroot=
  
  -----------------------------------
  
  Index: postgresql- at pg_majdotmin@-postgis-utils.dirs
  ===================================================================
  @pg_bindir@
  
  
  
  1.1                  postgis/debian/sofiles.in/postgresql- at pg_majdotmin@-postgis-utils.docs
  
  CVSWEB Options: -------------------
  
  CVSWeb: Annotate this file:            http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-@pg_majdotmin@-postgis-utils.docs?annotate=1.1&cvsroot=
  
  CVSWeb: View this file:             http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-@pg_majdotmin@-postgis-utils.docs?rev=1.1&content-type=text/x-cvsweb-markup&cvsroot=
  
  -----------------------------------
  
  Index: postgresql- at pg_majdotmin@-postgis-utils.docs
  ===================================================================
  CREDITS
  loader/README.*
  
  
  
  1.1                  postgis/debian/sofiles.in/postgresql- at pg_majdotmin@-postgis-utils.install
  
  CVSWEB Options: -------------------
  
  CVSWeb: Annotate this file:            http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-@pg_majdotmin@-postgis-utils.install?annotate=1.1&cvsroot=
  
  CVSWeb: View this file:             http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-@pg_majdotmin@-postgis-utils.install?rev=1.1&content-type=text/x-cvsweb-markup&cvsroot=
  
  -----------------------------------
  
  Index: postgresql- at pg_majdotmin@-postgis-utils.install
  ===================================================================
  @pg_bindir@/*
  @pg_datadir@/man/man1/*
  
  
  
  1.1                  postgis/debian/sofiles.in/postgresql-postgis-common.conffiles
  
  CVSWEB Options: -------------------
  
  CVSWeb: Annotate this file:            http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-postgis-common.conffiles?annotate=1.1&cvsroot=
  
  CVSWeb: View this file:             http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-postgis-common.conffiles?rev=1.1&content-type=text/x-cvsweb-markup&cvsroot=
  
  -----------------------------------
  
  Index: postgresql-postgis-common.conffiles
  ===================================================================
  /etc/default/postgis
  
  
  
  1.1                  postgis/debian/sofiles.in/postgresql-postgis-common.dirs
  
  CVSWEB Options: -------------------
  
  CVSWeb: Annotate this file:            http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-postgis-common.dirs?annotate=1.1&cvsroot=
  
  CVSWeb: View this file:             http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-postgis-common.dirs?rev=1.1&content-type=text/x-cvsweb-markup&cvsroot=
  
  -----------------------------------
  
  Index: postgresql-postgis-common.dirs
  ===================================================================
  @main_prefix@/share/postgresql-postgis-common
  etc/default
  
  
  
  1.1                  postgis/debian/sofiles.in/postgresql-postgis-common.docs
  
  CVSWEB Options: -------------------
  
  CVSWeb: Annotate this file:            http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-postgis-common.docs?annotate=1.1&cvsroot=
  
  CVSWeb: View this file:             http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-postgis-common.docs?rev=1.1&content-type=text/x-cvsweb-markup&cvsroot=
  
  -----------------------------------
  
  Index: postgresql-postgis-common.docs
  ===================================================================
  CREDITS
  
  
  
  1.1                  postgis/debian/sofiles.in/postgresql-postgis-common.install
  
  CVSWEB Options: -------------------
  
  CVSWeb: Annotate this file:            http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-postgis-common.install?annotate=1.1&cvsroot=
  
  CVSWeb: View this file:             http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-postgis-common.install?rev=1.1&content-type=text/x-cvsweb-markup&cvsroot=
  
  -----------------------------------
  
  Index: postgresql-postgis-common.install
  ===================================================================
  @main_prefix@/share/postgresql-postgis-common/*
  etc/default/postgis
  
  
  
  1.1                  postgis/debian/sofiles.in/postgresql-postgis-doc.doc-base
  
  CVSWEB Options: -------------------
  
  CVSWeb: Annotate this file:            http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-postgis-doc.doc-base?annotate=1.1&cvsroot=
  
  CVSWeb: View this file:             http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-postgis-doc.doc-base?rev=1.1&content-type=text/x-cvsweb-markup&cvsroot=
  
  -----------------------------------
  
  Index: postgresql-postgis-doc.doc-base
  ===================================================================
  Document: postgis-manual
  Title: PostGIS Manual
  Author: See /@main_prefix@/share/doc/postgresql-postgis-doc/CREDITS
  Abstract: This manual teaches postgresql-postgis handling.
  Section: Apps/Database
  
  Format: HTML
  Index: /@main_prefix@/share/doc/postgresql-postgis-doc/postgis.html
  Files: /@main_prefix@/share/doc/postgresql-postgis-doc/*.html
  
  Format: XML
  Index: /@main_prefix@/share/doc/postgresql-postgis-doc/postgis.xml
  Files: /@main_prefix@/share/doc/postgresql-postgis-doc/*.xml
  
  
  
  1.1                  postgis/debian/sofiles.in/postgresql-postgis-doc.docs
  
  CVSWEB Options: -------------------
  
  CVSWeb: Annotate this file:            http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-postgis-doc.docs?annotate=1.1&cvsroot=
  
  CVSWeb: View this file:             http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-postgis-doc.docs?rev=1.1&content-type=text/x-cvsweb-markup&cvsroot=
  
  -----------------------------------
  
  Index: postgresql-postgis-doc.docs
  ===================================================================
  doc/html/*.html
  doc/html/*.css
  doc/postgis.xml
  README.postgis
  CREDITS
  
  
  
  1.1                  postgis/debian/sofiles.in/postgresql-postgis-java-debug.install
  
  CVSWEB Options: -------------------
  
  CVSWeb: Annotate this file:            http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-postgis-java-debug.install?annotate=1.1&cvsroot=
  
  CVSWeb: View this file:             http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-postgis-java-debug.install?rev=1.1&content-type=text/x-cvsweb-markup&cvsroot=
  
  -----------------------------------
  
  Index: postgresql-postgis-java-debug.install
  ===================================================================
  @main_prefix@/share/java/postgis_debug.jar
  
  
  
  1.1                  postgis/debian/sofiles.in/postgresql-postgis-java.dirs
  
  CVSWEB Options: -------------------
  
  CVSWeb: Annotate this file:            http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-postgis-java.dirs?annotate=1.1&cvsroot=
  
  CVSWeb: View this file:             http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-postgis-java.dirs?rev=1.1&content-type=text/x-cvsweb-markup&cvsroot=
  
  -----------------------------------
  
  Index: postgresql-postgis-java.dirs
  ===================================================================
  @main_prefix@/share/java
  
  
  
  1.1                  postgis/debian/sofiles.in/postgresql-postgis-java.docs
  
  CVSWEB Options: -------------------
  
  CVSWeb: Annotate this file:            http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-postgis-java.docs?annotate=1.1&cvsroot=
  
  CVSWeb: View this file:             http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-postgis-java.docs?rev=1.1&content-type=text/x-cvsweb-markup&cvsroot=
  
  -----------------------------------
  
  Index: postgresql-postgis-java.docs
  ===================================================================
  CREDITS
  @dir_java@/README
  
  
  
  1.1                  postgis/debian/sofiles.in/postgresql-postgis-java.examples
  
  CVSWEB Options: -------------------
  
  CVSWeb: Annotate this file:            http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-postgis-java.examples?annotate=1.1&cvsroot=
  
  CVSWeb: View this file:             http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-postgis-java.examples?rev=1.1&content-type=text/x-cvsweb-markup&cvsroot=
  
  -----------------------------------
  
  Index: postgresql-postgis-java.examples
  ===================================================================
  @dir_java@/src/examples/*
  
  
  
  1.1                  postgis/debian/sofiles.in/postgresql-postgis-java.install
  
  CVSWEB Options: -------------------
  
  CVSWeb: Annotate this file:            http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-postgis-java.install?annotate=1.1&cvsroot=
  
  CVSWeb: View this file:             http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-postgis-java.install?rev=1.1&content-type=text/x-cvsweb-markup&cvsroot=
  
  -----------------------------------
  
  Index: postgresql-postgis-java.install
  ===================================================================
  @main_prefix@/share/java/postgis.jar
  
  
  
  1.1                  postgis/debian/sofiles.in/postgresql-postgis-utils.dirs
  
  CVSWEB Options: -------------------
  
  CVSWeb: Annotate this file:            http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-postgis-utils.dirs?annotate=1.1&cvsroot=
  
  CVSWeb: View this file:             http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-postgis-utils.dirs?rev=1.1&content-type=text/x-cvsweb-markup&cvsroot=
  
  -----------------------------------
  
  Index: postgresql-postgis-utils.dirs
  ===================================================================
  @main_bin@
  @pg_main_bin@
  
  
  
  1.1                  postgis/debian/sofiles.in/postgresql-postgis-utils.docs
  
  CVSWEB Options: -------------------
  
  CVSWeb: Annotate this file:            http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-postgis-utils.docs?annotate=1.1&cvsroot=
  
  CVSWeb: View this file:             http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-postgis-utils.docs?rev=1.1&content-type=text/x-cvsweb-markup&cvsroot=
  
  -----------------------------------
  
  Index: postgresql-postgis-utils.docs
  ===================================================================
  CREDITS
  loader/README.*
  
  
  
  1.1                  postgis/debian/sofiles.in/postgresql-postgis-utils.install
  
  CVSWEB Options: -------------------
  
  CVSWeb: Annotate this file:            http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-postgis-utils.install?annotate=1.1&cvsroot=
  
  CVSWeb: View this file:             http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-postgis-utils.install?rev=1.1&content-type=text/x-cvsweb-markup&cvsroot=
  
  -----------------------------------
  
  Index: postgresql-postgis-utils.install
  ===================================================================
  @main_bin@/*
  @pg_main_bin@/*
  
  
  
  1.1                  postgis/debian/sofiles.in/postgresql-postgis-utils.manpages
  
  CVSWEB Options: -------------------
  
  CVSWeb: Annotate this file:            http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-postgis-utils.manpages?annotate=1.1&cvsroot=
  
  CVSWeb: View this file:             http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-postgis-utils.manpages?rev=1.1&content-type=text/x-cvsweb-markup&cvsroot=
  
  -----------------------------------
  
  Index: postgresql-postgis-utils.manpages
  ===================================================================
  doc/man/pgsql2shp.1
  doc/man/shp2pgsql.1
  debian/createdb.postgis.1
  debian/mktemplate_gis.1
  debian/rmtemplate_gis.1
  
  
  
  1.1                  postgis/debian/sofiles.in/postgresql-postgis at major@-examples.dirs
  
  CVSWEB Options: -------------------
  
  CVSWeb: Annotate this file:            http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-postgis@major@-examples.dirs?annotate=1.1&cvsroot=
  
  CVSWeb: View this file:             http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-postgis@major@-examples.dirs?rev=1.1&content-type=text/x-cvsweb-markup&cvsroot=
  
  -----------------------------------
  
  Index: postgresql-postgis at major@-examples.dirs
  ===================================================================
  @main_prefix@/share/postgresql-postgis at major@-examples
  
  
  
  1.1                  postgis/debian/sofiles.in/postgresql-postgis at major@-examples.install
  
  CVSWEB Options: -------------------
  
  CVSWeb: Annotate this file:            http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-postgis@major@-examples.install?annotate=1.1&cvsroot=
  
  CVSWeb: View this file:             http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/postgresql-postgis@major@-examples.install?rev=1.1&content-type=text/x-cvsweb-markup&cvsroot=
  
  -----------------------------------
  
  Index: postgresql-postgis at major@-examples.install
  ===================================================================
  @main_prefix@/share/postgresql-postgis at major@-examples/*
  
  
  
  1.1                  postgis/debian/sofiles.in/profile
  
  CVSWEB Options: -------------------
  
  CVSWeb: Annotate this file:            http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/profile?annotate=1.1&cvsroot=
  
  CVSWeb: View this file:             http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/profile?rev=1.1&content-type=text/x-cvsweb-markup&cvsroot=
  
  -----------------------------------
  
  Index: profile
  ===================================================================
  
  #those are the default variables for postgresql-postgis.
  #this file will be scanned from /etc/default/postgis,
  #and then from $HOME/postgis/profile
  
  #values should NOT be in quotes
  
  #the name of the template database to create
  TEMPLATEDB=template_gis
  
  #the user/group to be granted maximum rights to the template.
  #public/groups are ok, but cannot be owners, so cannot grant 
  #privileges on databases created from this template.
  GRUSER=postgres
  
  #name of the user the template script will be created/removed as.
  #should be either dba, or the database cluster owner.
  #defaults to the cluster owner, and if none, to postgres.
  DBAUSER=postgres
  
  #this is the postgis functionality loader script.
  #as it contains the name of the postgresql-postgis library, this 
  #file will designate which postgis version to use.
  PGISSCRIPT=postgis#SONAME#.sql
  
  #set this to true not to load huge spatial_ref_sys table in the template.
  #NO_SRS=true
  
  
  
  1.1                  postgis/debian/sofiles.in/rmtemplate_gis
  
  CVSWEB Options: -------------------
  
  CVSWeb: Annotate this file:            http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/rmtemplate_gis?annotate=1.1&cvsroot=
  
  CVSWeb: View this file:             http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/rmtemplate_gis?rev=1.1&content-type=text/x-cvsweb-markup&cvsroot=
  
  -----------------------------------
  
  Index: rmtemplate_gis
  ===================================================================
  #!/bin/sh
  
  #drop template_gis
  #it may be used to drop any postgresql template, by supplying argument
  
  source /usr/share/postgresql-postgis-common/postgis_env.sh
  
  for ARGVN in $1 $2 $3 $4 ; do
      if [ `expr substr $ARGVN 1 11` = "--template=" ]; then
  	 	TDB=`echo $ARGVN | sed -e s/^--template=//`
  	elif [ `expr substr $ARGVN 1 6` = "--dba=" ]; then
  		DBAUSER=`echo $ARGVN | sed -e s/^--dba=//`
      elif [ -n $ARGVN ]; then
          echo "Usage of `basename $0`"
          echo "Supply arguments as follows"
          echo "--template=templatename of the template to remove"
  		echo "--dba=dbaname of the dba to run administrational programs as"
  		echo "You must usually be either root, or a postgresql dba in order"
  		echo "to use `basename $0`"
          exit 1
      fi
  done
  
  source /@pg_bindir@/postgres_lib.sh
  
  sudo_dba $DBAUSER
  
  export DBAUSER TDB
  $SUDO -c "/@pg_bindir@/rmtemplate_gis.sh"
  
  
  
  1.1                  postgis/debian/sofiles.in/rmtemplate_gis.sh
  
  CVSWEB Options: -------------------
  
  CVSWeb: Annotate this file:            http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/rmtemplate_gis.sh?annotate=1.1&cvsroot=
  
  CVSWeb: View this file:             http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/rmtemplate_gis.sh?rev=1.1&content-type=text/x-cvsweb-markup&cvsroot=
  
  -----------------------------------
  
  Index: rmtemplate_gis.sh
  ===================================================================
  #!/bin/sh
  
  #this script should be run as $DBAUSER
  
  PWD1=`pwd`
  
  cd /tmp
  
  source /@pg_bindir@/postgres_lib.sh
  
  check_dba $DBAUSER
  template_rm $TDB
  
  cd $PWD1
  
  
  
  1.1                  postgis/debian/sofiles.in/scriptslink.sh
  
  CVSWEB Options: -------------------
  
  CVSWeb: Annotate this file:            http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/scriptslink.sh?annotate=1.1&cvsroot=
  
  CVSWeb: View this file:             http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/postgis/debian/sofiles.in/scriptslink.sh?rev=1.1&content-type=text/x-cvsweb-markup&cvsroot=
  
  -----------------------------------
  
  Index: scriptslink.sh
  ===================================================================
  #!/bin/sh
  
  # pass the file name of the (lw)?postgis.sql as $1 parameter here
  # it will be renamed to postgis#SONAME#.sql, to allow postgis versions
  # coexistance
  
  PWD1=`pwd`
  
  #postgresql version independent scripts
  SCRIPTS="$DEBDIR/createdb.postgis"
  SCRIPTS="${SCRIPTS} `ls $CURDIR/utils/*.pl`"
  BINARIES="shp2pgsql pgsql2shp"
  #postgresql version dependent scripts
  PGSCRIPTS="mktemplate_gis.sh rmtemplate_gis.sh postgres_lib.sh mktemplate_gis rmtemplate_gis"
  MULTIPG="`dpkg-query -W postgresql-common | awk '{print $2;}'`"
  
  BASE_SCRIPTS=""
  for file in $SCRIPTS ; do
  	BASE_SCRIPTS="${BASE_SCRIPTS} `basename $file`"
  done
  
  ALL_PROGS="mktemplate_gis rmtemplate_gis ${BINARIES}${BASE_SCRIPTS}"
  
  for file in $PGSCRIPTS ; do
  	install --mode=755 $DEBDIR/$file $DESTDIR/@pg_bindir@
  done
  
  cp $DEBDIR/postgis_env.sh $DEBDIR/profile $DESTDIR/$sharedir
  for file in $SCRIPTS ; do
  	install --mode=755 $file $DESTDIR/$sharedir;
  done
  cd $DESTDIR/@pg_bindir@
  for file in $BASE_SCRIPTS ; do
  	ln -sf /$sharedir/$file;
  done
  cd $DESTDIR/@main_bin@
  for file in $ALL_PROGS ; do
  	if [ -n $MULTIPG ]; then
  		#ln -s /$sharedir/postgis_wrapper $file;
  		ln -s /usr/share/postgresql-common/pg_wrapper $file;
  	else
  		ln -sf /@pg_bindir@/$file $file; #wrongly formatted if not functional
  	fi
  done
  
  if [ -n $MULTIPG ] && [ -f $ONEUTILS ]; then
  	cd $DESTDIR/@pg_bindir@
  	for binary in $BINARIES; do
  		if [ "/@pg_bindir@" == "`pg_config --bindir`" ]; then
  			mv $binary $DESTDIR/@pg_main_bin@
  		elif [ ! -f $DESTDIR/@pg_main_bin@/$binary ]; then
  			mv $binary $DESTDIR/@pg_main_bin@
  		else
  			rm $binary
  		fi
  		ln -s /@pg_main_bin@/$binary $binary
  	done
  fi
  
  cd $DESTDIR/@pg_datadir@/contrib/
  mv $1 postgis#SONAME#.sql
  mv spatial_ref_sys.sql $DESTDIR/$sharedir
  ln -sf /$sharedir/spatial_ref_sys.sql
  
  cd $PWD1
  
  
  



More information about the Pkg-grass-devel mailing list