create_OWDDB.bat / create_postgresSQL_Database.sql not found

pranitbirje — Fri, 27 Jun 2014 15:43:29 GMT

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

Re: create_OWDDB.bat / create_postgresSQL_Database.sql not found

deko — Sat, 28 Jun 2014 14:32:22 GMT

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

Re: create_OWDDB.bat / create_postgresSQL_Database.sql not found

pranitbirje — Thu, 03 Jul 2014 14:16:12 GMT

yup. it worked. thanks a lot deko.

topic Re: create_OWDDB.bat / create_postgresSQL_Database.sql not found in Alfresco Archive

create_OWDDB.bat / create_postgresSQL_Database.sql not found

Re: create_OWDDB.bat / create_postgresSQL_Database.sql not found

Re: create_OWDDB.bat / create_postgresSQL_Database.sql not found