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.
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