#4 Postgres scripts should not include geoportal10 references
1. In the grants_pg.cmd and the create_schema_pg.cmd, there are references to geoportal10. These should be removed. Also, GeoportalServer_InstallationGuide will need to be updated to reference any updates made to these scripts as a result of work on this defect.
For example:
In grants_pg.cmd:
Usage : grants_pg.cmd [host] [port] [database] [geoportal schema] [Databaseuser] [geoportalUser]
Where [host] is the machine name hosting PostgreSQL
[port] is the port number of postgreSQL
[database] is the database name for the geoportal tables
[geoportal schema] is the geoportal schema name
[Databaseuser] User to connect to the database as
[geoportalUser] is the geoportal user name (my note: shouldn’t this be “geoportal schema owner name”?
e.g. grants_pg localhost 5432 postgres geoportal10 postgres geoportal10
In create_schema_pg.cmd:
Usage : create_schema_pg.cmd [host] [port] [Geoportal database] [geoportal10 user]
Where [host] is the machine name hosting PostgreSQL
[port] is the port number of postgreSQL
[Geoportal database] is the database that contains the Geoportal Schema
[geoportal10 user] is the geoportal10 user.
e.g. create_schema_pg localhost 5432 postgres geoportal10
Since I wasn't able to attached a file, I put an updated grants_pg.cmd in a zip file in my public dropbox folder.
http://dl.dropbox.com/u/19013732/Geoprotal/grants_pg.zip