...
...
5. Create the role alexandria and load the SQL via psql
into the instance.
Code Block |
---|
|
echo "create role alexandria with superuser login;" \
| psql -U postgres postgres |
Install the schema and tools.
...
Code Block |
---|
|
# Amazon
sudo yum -y install alexandria-data-warehouse-pg11 |
...
...
sudo yum -y install alexandria-schema-tools |
Create the database.
...
Code Block |
---|
|
# Amazon
cat /usr/share/alexandria-data-warehouse-pg11/alexandria-dwh.sql | psql -U alexandria postgres |
...
...
gunzip -c /usr/share/alexandria-schema-tools/alexandria-dbs-10.x.gz | psql -U alexandria postgres |
6. To ensure that the database has been created, run:
Code Block |
---|
|
psql -U alexandria --list |
...