nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

PostgreSQL (New to this please help)

dan18fan

Hello everyone, well... Alfresco is working fine for me, in my enterprise's local server (windows server 2012 r2) and I can open it in any PC that is connected to the server's domain.

Now... I've installed Odoo for future working purposes along with Alfresco, but I can't get Odoo to work.

Alfresco installed PostgreSQL and so Odoo did.

Are their "PostgreSQL's" independent? can they run for each service?

I also want to point out that I installed Alfresco first then Odoo.

And if PostgreSQL can run for both, how can I set them up to avoid any conflict?

I'm really sorry, I'm new to all this things and it's my job to understand this environment 100%.

Find more posts tagged with

Alfresco Content Services

Comments

afaust

If you install complex software like Alfresco or Odoo using the default provided installers, the components they rely on will usually be installed as separate / independent components. Such installers are usually meant for "quick start" type of scenarios - I don't see them fit for best practices / production use cases.

You can avoid conflicts between two PostgreSQL services by configuring their network ports to different values in their respective postgresql.conf files. This means you will also have to adapt the configuration of at least one of Alfresco or Odoo to use the changed port(s) for connecting to PostgreSQL.

What I'd do is a bit different. I would not install PostgreSQL service that is shipped with either installer. Instead I would install PostgreSQL (using an installer comming directly from PostgreSQL) as a single, shared service that provides databases for both business applications.

dan18fan

I took your last suggestion, installed odoo and alfresco by themselves without postgreSQL, installed postgreSQL separately from their official page but I don't know what to do next, I been trying move around pgAdmin 4 and connect to alfresco without success.

afaust

Well - after installing the PostgreSQL service you need to create a user + database for Alfresco, and then connect Alfresco to PostgreSQL.

dan18fan

I'm using pgAdmin 3, all good until.....

Open the <classpathRoot>/alfresco-global.properties.sample file.
Locate the following line:
dir.root=./alf_data
Edit the line with an absolute path to point to the directory in which you want to store Alfresco Content Services data. For example: dir.root=C:/Alfresco/alf_data

Uncomment the following properties:

# PostgreSQL connection (requires postgresql-8.2-504.jdbc3.jar or equivalent)#db.driver=org.postgresql.Driverdb.url=jdbc:postgresql://${db.host}:${db.port}/${db.name}

Set the other database connection properties.
```
db.name=alfresco db.username=alfresco db.password=alfresco db.host=localhost db.port=5432db.pool.max=100
```
Note:Ensure that these database connection properties are not commented out.
Save the file without the .sample extension.
To allow password-authenticated connections through TCP/IP, ensure that the PostgreSQL configuration file, pg_hba.conf, contains the following line:
```
host all all 127.0.0.1/32 password
```
Restart the Alfresco Content Services server.

Don't really understand these steps.