Project

General

Profile

Initial database content for new instances

Schema creation with the initial load is now performed by create_schema.sh. The script is in sam-misc under the ddl directory.

create_schema.sh -d <databaseName> -h <host> -p <port>
Creates a SAM schema loaded with the required initial values and adds developers to the persons table.
Note:
1) You must have a Kerberos Postgresql account to the database as it will be used for logging in.
2) Your Postgresql account must be able to set role to the table owning role.

example: create_schema.sh -d sam_nova_prd -h cspgsprd1.fnal.gov -p 5432

Log files will be created under /tmp/$USER/databaseName