479
edits
Changes
Jump to navigation
Jump to search
no edit summary
---------+------------+------------------+-------
1 | Devonshire | Pl | 02109
Next, a new profile needs to be created by using the following command.
INSERT INTO tiger.loader_platform(os, declare_sect, pgbin, wget, unzip_command, psql, path_sep,
loader, environ_set_command, county_process_command)
SELECT 'newuser', declare_sect, pgbin, wget, unzip_command, psql, path_sep,
loader, environ_set_command, county_process_command
FROM tiger.loader_platform
WHERE os = 'sh';
The paths in declare_sect need to be edited so they match our server locations.
The declare_sect looks like the following:
export PGHOST=localhost +
export PGUSER=postgres +
export PGPASSWORD=yourpasswordhere +
export PGDATABASE=geocoder +
PSQL=${PGBIN}/psql +
SHP2PGSQL=shp2pgsql +
cd ${staging_fold} +
TMPDIR="${staging_fold}/temp/" +
UNZIPTOOL=unzip +
WGETTOOL="/usr/bin/wget" +
export PGBIN=/usr/lib/postgresql/9.6/bin +
export PGPORT=5432 +
export PGHOST=localhost +
export PGUSER=postgres +
export PGPASSWORD=yourpasswordhere +
export PGDATABASE=geocoder +
PSQL=${PGBIN}/psql +
SHP2PGSQL=shp2pgsql +
cd ${staging_fold}
