diff --git a/servers/php/postgresql/README.md b/servers/php/postgresql/README.md new file mode 100644 index 0000000..e06eb38 --- /dev/null +++ b/servers/php/postgresql/README.md @@ -0,0 +1,55 @@ + +#### PHP and PostgreSQL + +Just like the MySQL version, using PostgreSQL with GpsTracker requires a web server, such as Apache, and PHP. Once you have your server software installed, you need to create a website on your Apache web server and create a directory called gpstracker. Put all of the files from the php download directory into there. + +Now install the PostgreSQL database server. You may want to install the GUI admin tool, pgAdmin III, but it is not required if you are comfortable using the command line. + + +##### Creating the GpsTracker Database Using the PostgreSQL Command Line + +Open a command window, and change directory to Postgresql\bin: +
+	cd "C:\Program Files\PostgreSQL\9.4\bin"
+
+ +Now create a database user for inserting and quering the data: +
+	C:\Program Files\PostgreSQL\9.4\bin>psql -U postgres -c "CREATE USER gpstracker_user WITH PASSWORD 'gpstracker';"
+	Password for user postgres:
+	CREATE ROLE
+
+	C:\Program Files\PostgreSQL\9.4\bin>psql -U postgres -c "CREATE DATABASE gpstracker;"
+	Password for user postgres:
+	CREATE DATABASE
+
+	C:\Program Files\PostgreSQL\9.4\bin>psql -U postgres -c "ALTER DATABASE gpstracker OWNER TO gpstracker_user;"
+	Password for user postgres:
+	ALTER DATABASE
+
+	C:\Program Files\PostgreSQL\9.4\bin>psql -U gpstracker_user -d gpstracker -f C:\Users\brent\Documents\gpstracker-09-14-14.sql
+	Password for user gpstracker_user:
+	psql:C:/Users/brent/Documents/gpstracker-09-14-14.sql:6: NOTICE:  view "v_getallroutesformap" does not exist, skipping DROP VIEW
+	psql:C:/Users/brent/Documents/gpstracker-09-14-14.sql:7: NOTICE:  view "v_getrouteformap" does not exist, skipping DROP VIEW
+	psql:C:/Users/brent/Documents/gpstracker-09-14-14.sql:8: NOTICE:  view "v_getroutes" does not exist, skipping DROP VIEW
+	psql:C:/Users/brent/Documents/gpstracker-09-14-14.sql:9: NOTICE:  index "sessionidindex" does not exist, skipping DROP INDEX
+	psql:C:/Users/brent/Documents/gpstracker-09-14-14.sql:10: NOTICE:  index "phonenumberindex" does not exist, skipping DROP INDEX
+	psql:C:/Users/brent/Documents/gpstracker-09-14-14.sql:11: NOTICE:  index "usernameindex" does not exist, skipping DROP INDEX
+	psql:C:/Users/brent/Documents/gpstracker-09-14-14.sql:13: NOTICE:  table "gpslocations" does not exist, skipping DROP TABLE
+	CREATE TABLE
+	CREATE INDEX
+	CREATE INDEX
+	CREATE INDEX
+	INSERT 0 9
+	CREATE VIEW
+	CREATE VIEW
+	CREATE VIEW
+
+ + +Now edit GpsTracker's PHP file "dbconnect.php: to set the database type to PostgreSQL: +
+$dbType = DB_POSTGRESQL;
+
+ +That's it! \ No newline at end of file