Date: Sat, 2 Jul 2011 18:56:14 GMT From: Rainer Hurling <rhurlin@gwdg.de> To: freebsd-gnats-submit@FreeBSD.org Subject: ports/158599: [PATCH] databases/pgadmin3 Message-ID: <201107021856.p62IuEYU020684@red.freebsd.org> Resent-Message-ID: <201107021900.p62J0Lnh052674@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>Number: 158599
>Category: ports
>Synopsis: [PATCH] databases/pgadmin3
>Confidential: no
>Severity: non-critical
>Priority: low
>Responsible: freebsd-ports-bugs
>State: open
>Quarter:
>Keywords:
>Date-Required:
>Class: update
>Submitter-Id: current-users
>Arrival-Date: Sat Jul 02 19:00:21 UTC 2011
>Closed-Date:
>Last-Modified:
>Originator: Rainer Hurling
>Release: FreeBSD 9.0-CURRENT (amd64)
>Organization:
>Environment:
FreeBSD xxx.xxx.xxx 9.0-CURRENT FreeBSD 9.0-CURRENT #0: Sat Jun 25 16:04:44 CEST 2011 xxx@xxx.xxx.xx:/usr/obj/usr/src/sys/XXX amd64
>Description:
Since PR 157605 is committed (thanks to wen@), there is a gui version of 'shp2pgsql' (from databases/postgis). 'shp2pgsql-gui' can be used as standalone or within PgAdmin3 (databases/pgadmin3) to directly convert ESRI shapefiles and load them into a PostGIS enabled PostgreSQL database.
To be able to recognize 'shp2pgsql-gui', PgAdmin3 on FreeBSD also needs an entry in its plugins.ini file.
>How-To-Repeat:
After patching 'plugins.ini' you will find a new entry 'PostGIS Shapefile and DBF loader' in the Plugins menu of PgAdmin3.
>Fix:
Patch attached with submission follows:
diff -Naur pgadmin3.orig/Makefile pgadmin3/Makefile
--- pgadmin3.orig/Makefile 2010-10-05 18:19:04.000000000 +0200
+++ pgadmin3/Makefile 2011-07-02 20:05:26.000000000 +0200
@@ -7,6 +7,7 @@
PORTNAME= pgadmin3
PORTVERSION= 1.12.0
+PORTREVISION= 1
CATEGORIES= databases
MASTER_SITES= ${MASTER_SITE_PGSQL}
MASTER_SITE_SUBDIR= pgadmin3/release/v${PORTVERSION}/src
diff -Naur pgadmin3.orig/files/patch-pgadmin_plugins.ini pgadmin3/files/patch-pgadmin_plugins.ini
--- pgadmin3.orig/files/patch-pgadmin_plugins.ini 1970-01-01 01:00:00.000000000 +0100
+++ pgadmin3/files/patch-pgadmin_plugins.ini 2011-07-02 20:16:31.000000000 +0200
@@ -0,0 +1,17 @@
+--- pgadmin/plugins.ini.orig 2010-07-28 19:43:18.000000000 +0200
++++ pgadmin/plugins.ini 2011-07-02 20:15:34.000000000 +0200
+@@ -167,3 +167,14 @@
+ ; AppliesTo=database
+ ; SetPassword=Yes
+
++;
++; PostGIS shp2pgsql-gui (Unix):
++;
++Title=PostGIS Shapefile and DBF loader
++Command="$$PGBINDIR/shp2pgsql-gui" -h $$HOSTNAME -p $$PORT -U $$USERNAME -d $$DATABASE
++Description=Open a PostGIS ESRI Shapefile or Plain dbf loader to the current database.
++KeyFile=$$PGBINDIR/shp2pgsql-gui
++Platform=unix
++ServerType=postgresql
++Database=Yes
++SetPassword=Yes
>Release-Note:
>Audit-Trail:
>Unformatted:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?201107021856.p62IuEYU020684>