host pgadmin mail 127.0.0.1/32 md5 This will allow local socket connections on port 5432. (The default port for postgres) Add the database user: # sudo -u postgres psql postgres=# CREATE USER pgadmin WITH PASSWORD 'new password'; postgres=# \q Give the user the privi...
create_schema_pg localhost 5432 postgres geoportal For geoportal10 user, enter the same password you designated for the geoportal user when you ran the grants_pg script—in most cases, this will be geoportal. Upon the completion of the script, it will generate a text file, geoportal_schema.tx...