Debian 10 GIS Server - Versionsgeschichte

Armin: /* Grant all rights to special dbuser */

2020-07-24T08:28:54Z

Grant all rights to special dbuser

2020-07-24T08:27:44Z

Grant all rights to special dbuser

2020-07-24T08:21:26Z

2020-07-24T08:16:23Z

Allow access from remote

2020-07-24T08:16:04Z

2020-07-24T08:00:42Z

2020-07-24T07:22:00Z

Adopt epsg file to support beta2007 transformation

2020-07-24T07:21:01Z

2020-07-24T06:32:23Z

2020-07-24T06:30:45Z

@@ Zeile 80: / Zeile 80: @@
 psql -p 5433 -d db1 -c 'GRANT  USAGE ON SCHEMA public TO {dbusername};'
 psql -p 5433 -d db1 -c 'GRANT  USAGE ON SCHEMA {schemaname} TO {dbusername};'
-psql -p 5433 -d db1 -c 'GRANT ALL  ON SCHEMA {schemaname} TO {dbusername};
+psql -p 5433 -d db1 -c 'GRANT ALL  ON SCHEMA {schemaname} TO {dbusername};'
 psql -p 5433 -d db1 -c 'GRANT SELECT,INSERT,UPDATE,DELETE ON ALL TABLES IN SCHEMA {schemaname} TO {dbusername};'
 </pre>

@@ Zeile 72: / Zeile 72: @@
 == Grant all rights to special dbuser ==
 <pre>
 psql -p 5433 -d db1 -c 'GRANT SELECT, INSERT, USAGE, UPDATE , DELETE ON ALL TABLES IN SCHEMA {schemaname} TO {dbusername};'
 psql -p 5433 -d db1 -c 'GRANT SELECT, INSERT,  UPDATE , DELETE ON ALL TABLES IN SCHEMA {schemaname} TO {dbusername};'

@@ Zeile 69: / Zeile 69: @@
 echo "local   db1       {dbusername}                              md5" >> /etc/postgresql/11/{clustername}/pg_hba.conf
 pg_ctlcluster 11 {clustername} restart
 </pre>

@@ Zeile 63: / Zeile 63: @@
 </pre>
 == Allow access from remote ==
 su
 echo "#add for postgis user" >> /etc/postgresql/11/{clustername}/pg_hba.conf
@@ Zeile 68: / Zeile 69: @@
 echo "local   db1       {dbusername}                              md5" >> /etc/postgresql/11/{clustername}/pg_hba.conf
 pg_ctlcluster 11 {clustername} restart

← Nächstältere Version		Version vom 24. Juli 2020, 08:16 Uhr
Zeile 62:		Zeile 62:
	psql -p 5433 -d db1 -c "update spatial_ref_sys set proj4text = '+proj=tmerc +lat_0=0 +lon_0=15 +k=1 +x_0=5500000 +y_0=0 +datum=potsdam +units=m +no_defs' where srid = 31469"		psql -p 5433 -d db1 -c "update spatial_ref_sys set proj4text = '+proj=tmerc +lat_0=0 +lon_0=15 +k=1 +x_0=5500000 +y_0=0 +datum=potsdam +units=m +no_defs' where srid = 31469"
	</pre>		</pre>
		+	== Allow access from remote ==
		+	su
		+	echo "#add for postgis user" >> /etc/postgresql/11/{clustername}/pg_hba.conf
		+	echo "local db1 postgres trust" >> /etc/postgresql/11/{clustername}/pg_hba.conf
		+	echo "local db1 {dbusername} md5" >> /etc/postgresql/11/{clustername}/pg_hba.conf
		+	pg_ctlcluster 11 {clustername} restart

@@ Zeile 54: / Zeile 54: @@
 psql -p 5433 -d db1 -c 'CREATE SCHEMA {schemaname}'
 psql -p 5433 -d db1 -c 'ALTER DATABASE db1 SET search_path TO {schemaname},public'
 </pre>

@@ Zeile 24: / Zeile 24: @@
 cd /usr/share/proj
 cp epsg epsg_old
 </pre>
 == Create postgres cluster and start it ==
 <pre>

← Nächstältere Version		Version vom 24. Juli 2020, 07:21 Uhr
Zeile 39:		Zeile 39:
	== Restart cluster ==		== Restart cluster ==
	<pre>pg_ctlcluster 11 {clustername} restart</pre>		<pre>pg_ctlcluster 11 {clustername} restart</pre>
		+	== Install first db on cluster ==
		+	<pre>
		+	su postgres
		+	createuser -S -D -R -P -p 5433 {dbusername}
		+	createdb -p 5433 -O {dbusername} db1 -E utf-8
		+	psql -p 5433 -d db1 -c 'CREATE EXTENSION postgis'
		+	psql -p 5433 -d db1 -c 'CREATE EXTENSION postgis_topology'
		+	psql -p 5433 -d db1 -f /usr/share/postgresql/11/contrib/postgis-2.5/legacy.sql
		+	psql -p 5433 -d db1 -c 'CREATE SCHEMA {schemaname}'
		+	psql -p 5433 -d db1 -c 'ALTER DATABASE db1 SET search_path TO {schemaname},public'
		+	</pre>

@@ Zeile 17: / Zeile 17: @@
 apt-get clean
 </pre>
 == Adopt epsg file to support beta2007 transformation ==
 <pre>

@@ Zeile 31: / Zeile 31: @@
 The port of the first cluster will be 5433, it will increment with the number of clusters.
 == Edit conf files ==
-/etc/postgresql/11/{clustername}/postgresql.conf
+<pre>vi /etc/postgresql/11/{clustername}/postgresql.conf</pre>
 * Uncomment listen_addresses ...
 * exchange localhost with *
-* restart cluster:
+== Restart cluster ==