https://connect.hyland.com/t5/alfresco-forum/manual-deployment-create-postgresql-database/m-p/85126#M25872 <P>You need to create the database and the user in Postgres.</P> <P>Something like this: <A href="https://github.com/loftuxab/alfresco-ubuntu-install/blob/master/scripts/postgresql.sh#L40" target="_blank" rel="nofollow noopener noreferrer">https://github.com/loftuxab/alfresco-ubuntu-install/blob/master/scripts/postgresql.sh#L40</A></P> <P>After that, when Alfresco starts, all the tables and database objects are created during the application bootstrap.</P> Wed, 30 Sep 2020 07:40:48 GMT angelborroy 2020-09-30T07:40:48Z https://connect.hyland.com/t5/alfresco-forum/manual-deployment-create-postgresql-database/m-p/85125#M25871 <P><SPAN>I'm doing a manual deployment, but I can't find the script for creating the database, where can I find it? The version I'm deploying is 6.2.</SPAN></P> Tue, 29 Sep 2020 18:36:05 GMT https://connect.hyland.com/t5/alfresco-forum/manual-deployment-create-postgresql-database/m-p/85125#M25871 luiztedesco 2020-09-29T18:36:05Z https://connect.hyland.com/t5/alfresco-forum/manual-deployment-create-postgresql-database/m-p/85126#M25872 <P>You need to create the database and the user in Postgres.</P> <P>Something like this: <A href="https://github.com/loftuxab/alfresco-ubuntu-install/blob/master/scripts/postgresql.sh#L40" target="_blank" rel="nofollow noopener noreferrer">https://github.com/loftuxab/alfresco-ubuntu-install/blob/master/scripts/postgresql.sh#L40</A></P> <P>After that, when Alfresco starts, all the tables and database objects are created during the application bootstrap.</P> Wed, 30 Sep 2020 07:40:48 GMT https://connect.hyland.com/t5/alfresco-forum/manual-deployment-create-postgresql-database/m-p/85126#M25872 angelborroy 2020-09-30T07:40:48Z