create_OWDDB.bat / create_postgresSQL_Database.sql not found

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

pranitbirje

Hi
I downloaded community edition of Alfresco Workdesk. Installation doc talks about running Create_OWDDB.bat or Create_XXXX_Database.sql (XXXX stands for db type - MySQL, PostgreSQL) to create Workdesk database. Unfortunately I couldn't find these bundled with community edition. Can someone let me know from where to download these?

Thanks and regards,
Pranit

P.S. I am first time user/developer for Workdesk/alfresco.

deko

Hi pranitbirje,

I just had a look into the last Workdesk community build and it seems that those files are missing somehow. Unfortunately I am not able to attach the files here, as only the extensions txt, log, jpg, jpeg, png are allowed.

Anyways, here is the content of the batch file for PostgreSQL:

set PGPASSWORD=admin
psql -d postgres -U postgres -w -f Create_PostgreSQL_Database.sql
set PGPASSWORD=owdemo
psql -d owd -U owdemo -w  -f OwPostgreSQL_CreateAttributeBagTable.sql
‍‍‍‍‍‍

And here the content of Create_PostgreSQL_Database.sql

DROP DATABASE  IF EXISTS  owd;

DROP ROLE  IF EXISTS owdemo;

CREATE ROLE owdemo LOGIN ENCRYPTED PASSWORD 'owdemo'
  SUPERUSER CREATEDB CREATEROLE
   VALID UNTIL 'infinity';

CREATE DATABASE owd
  WITH OWNER = "owdemo"
       ENCODING = 'UTF8'
       TABLESPACE = pg_default
       CONNECTION LIMIT = -1;
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I will check the general build on Monday. Hope you are able to install the DB now as described in the documents.

Best regards,
deko