# Portgresql as database

**URL:** <https://community.spicecrm.io/t/portgresql-as-database/178>\
**Category:** Uncategorized\
**Created:** [September 26, 2017, 3:54am UTC](https://community.spicecrm.io/t/portgresql-as-database/178 "2017-09-26T03:54:14Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![adrian](https://avatars.discourse-cdn.com/v4/letter/a/82dd89/32.png) [@adrian](https://community.spicecrm.io/u/adrian)\
**Post date:** [September 26, 2017, 3:54am UTC](https://community.spicecrm.io/t/portgresql-as-database/178/1 "2017-09-26T03:54:14Z")

</div>

can we use portgresql as database in spicecrm? if can, how to setting it?

---

<div class="post-metadata">

**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\
**Post date:** [September 26, 2017, 11:43am UTC](https://community.spicecrm.io/t/portgresql-as-database/178/2 "2017-09-26T11:43:16Z")

</div>

Adrian,

PostGreSQL is supported in SpiceCRM 20170900 which we are releasing today.  
Deeper functionality tests were not run, I count on your feedback.  
In case postgre is not recognize on installation, install with mysql.  
Then go to **config.php** and edit **db\_config** settings.  
db\_type for postgre is ‘pgsql’

Val

---

<div class="post-metadata">

**Author:** ![adrian](https://avatars.discourse-cdn.com/v4/letter/a/82dd89/32.png) [@adrian](https://community.spicecrm.io/u/adrian)\
**Post date:** [September 27, 2017, 2:58am UTC](https://community.spicecrm.io/t/portgresql-as-database/178/3 "2017-09-27T02:58:42Z")

</div>

Maretval,

I have install it with mysql, and edit in config, but when i access it, it says , i cannot access to the postgres.

 ![dbconfig](https://canada1.discourse-cdn.com/flex030/uploads/spicecrm/original/1X/c3c0e817ef94302e8fe74f0866599b42c95fc52c.png)

i got this message  
 ![saveit](https://canada1.discourse-cdn.com/flex030/uploads/spicecrm/original/1X/10a407ac0d24a665f47934334d812a57497d4f75.png)

and this is the log

 ![sugar](https://canada1.discourse-cdn.com/flex030/uploads/spicecrm/original/1X/b3c4aeae49ad33bb960c68a64fafdc835aadd03c.png)

---

<div class="post-metadata">

**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\
**Post date:** [September 27, 2017, 6:09am UTC](https://community.spicecrm.io/t/portgresql-as-database/178/4 "2017-09-27T06:09:33Z")

</div>

Adrian,  
I forgot to mention that parameter db\_manager has to be set to PostGreSQLManager  
Val

---

<div class="post-metadata">

**Author:** ![adrian](https://avatars.discourse-cdn.com/v4/letter/a/82dd89/32.png) [@adrian](https://community.spicecrm.io/u/adrian)\
**Post date:** [September 27, 2017, 6:45am UTC](https://community.spicecrm.io/t/portgresql-as-database/178/5 "2017-09-27T06:45:33Z")

</div>

> [@maretval](#):
>
> PostGreSQLManager

Ok, I have change it but the error is same.

---

<div class="post-metadata">

**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\
**Post date:** [September 27, 2017, 7:16am UTC](https://community.spicecrm.io/t/portgresql-as-database/178/6 "2017-09-27T07:16:37Z")

</div>

Thanks for your feedback Adrian, it looks like our postgre plugin is not fully ready. I will add the feature to the road map for Winter release.  
Just to make sure: you can connect to postgre using php outside of spicecrm can’t you?  
Val

---

<div class="post-metadata">

**Author:** ![adrian](https://avatars.discourse-cdn.com/v4/letter/a/82dd89/32.png) [@adrian](https://community.spicecrm.io/u/adrian)\
**Post date:** [September 27, 2017, 7:33am UTC](https://community.spicecrm.io/t/portgresql-as-database/178/7 "2017-09-27T07:33:47Z")

</div>

Ok thanks maretval, I will wait it.  
yes i can.