Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Panel
titleBefore you start

...

5. Create the role alexandria and load the SQL via psql into the instance.

Code Block
languagetext
echo "create role alexandria with superuser login;" \
  | psql -U postgres postgres

Install the schema and tools.

...

Code Block
languagebash
# Amazon
sudo yum -y install alexandria-data-warehouse-pg11

...


# CentOS / RHEL

...


sudo yum -y install alexandria-schema-tools

Create the database.

...

Code Block
languagebash
# Amazon
cat /usr/share/alexandria-data-warehouse-pg11/alexandria-dwh.sql | psql -U alexandria postgres

...


# CentOS / RHEL

...


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
languagetext
psql -U alexandria --list

...