Help

BBDD

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
gomezma
Active Member
‎8 Mar 2018 4:23 PM

BBDD

Buenas tardes,

Respecto a la reducción de la BBDD de Alfresco:

 

He estado mirando las posibles soluciones e implementé la linea "attributes.propcleaner.cronExpression=0 0 3 ? * SAT" en alfresco-global.properties. Después de hacer VACUUM en la BBDD conseguí reducir unos 40 GB pero la tabla "alf_prop_link" sigue igual. 

 

Perdonad mi inexperiencia pero como debería hacer exactamente para implementar el script sql de Axel Faust ?

 

Gracias,

0 Kudos
3 Replies
angelborroy
Alfresco Employee
‎8 Mar 2018 5:34 PM

Re: BBDD

Un script SQL no se implementa. Se ejecuta. Sobre la base de datos.

En PostgreSQL, por ejemplo, con el programa psql.

Hyland Developer Evangelist
0 Kudos
gomezma
Active Member
‎8 Mar 2018 5:44 PM

Re: BBDD

Ok gracias. Se podría hacer con el pgAdmin III?

0 Kudos
angelborroy
Alfresco Employee
‎8 Mar 2018 5:45 PM

Re: BBDD

Claro

Hyland Developer Evangelist
0 Kudos
Spanish User Group

Discussions about Alfresco Content Services and Alfresco Process Services in Spanish

Related:

We use cookies on this site to enhance your user experience

By using this site, you are agreeing to allow us to collect and use cookies as outlined in Alfresco’s Cookie Statement and Terms of Use (and you have a legitimate interest in Alfresco and our products, authorizing us to contact you in such methods).   If you are not ok with these terms, please do not use this website.