# PostgreSQL option is not showing in Database Configration **URL:** \ **Category:** Development\ **Created:** [January 11, 2016, 2:59pm UTC](https://forum.mautic.org/t/postgresql-option-is-not-showing-in-database-configration/3200 "2016-01-11T14:59:38Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![abhimanyu1](https://avatars.discourse-cdn.com/v4/letter/a/e274bd/32.png) [@abhimanyu1](https://forum.mautic.org/u/abhimanyu1)\ **Post date:** [January 11, 2016, 2:59pm UTC](https://forum.mautic.org/t/postgresql-option-is-not-showing-in-database-configration/3200/1 "2016-01-11T14:59:38Z")
I am installing mautic but in database connection option only MySQL, SQLite is giving. But i want to use PostgreSQL. I have already install postgre sql and I have un commented this “extension=php\_pgsql.dll”. But still not getting postgre sql option. What will i Do? ---
**Author:** ![abhimanyu1](https://avatars.discourse-cdn.com/v4/letter/a/e274bd/32.png) [@abhimanyu1](https://forum.mautic.org/u/abhimanyu1)\ **Post date:** [January 11, 2016, 2:59pm UTC](https://forum.mautic.org/t/postgresql-option-is-not-showing-in-database-configration/3200/2 "2016-01-11T14:59:38Z")
I am installing mautic but in database connection option only MySQL, SQLite is giving. But i want to use PostgreSQL. I have already install postgre sql and I have un commented this “extension=php\_pgsql.dll”. But still not getting postgre sql option. What will i Do? ---
**Author:** ![escopecz](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/escopecz/32/370_2.png) [@escopecz](https://forum.mautic.org/u/escopecz)\ **Post date:** [January 11, 2016, 3:14pm UTC](https://forum.mautic.org/t/postgresql-option-is-not-showing-in-database-configration/3200/3 "2016-01-11T15:14:26Z")
Make sure you have the Postgres PHP extension installed and enabled. [http://php.net/manual/en/pgsql.installation.php](http://php.net/manual/en/pgsql.installation.php) ---
**Author:** ![abhimanyu1](https://avatars.discourse-cdn.com/v4/letter/a/e274bd/32.png) [@abhimanyu1](https://forum.mautic.org/u/abhimanyu1)\ **Post date:** [January 11, 2016, 3:39pm UTC](https://forum.mautic.org/t/postgresql-option-is-not-showing-in-database-configration/3200/4 "2016-01-11T15:39:55Z")
I have enabled it. But when database configuration screen is come during installation process in step -1 its not show the postgres sql option… ---
**Author:** ![escopecz](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/escopecz/32/370_2.png) [@escopecz](https://forum.mautic.org/u/escopecz)\ **Post date:** [January 11, 2016, 3:43pm UTC](https://forum.mautic.org/t/postgresql-option-is-not-showing-in-database-configration/3200/5 "2016-01-11T15:43:36Z")
Have you restarted the server? ---
**Author:** ![abhimanyu1](https://avatars.discourse-cdn.com/v4/letter/a/e274bd/32.png) [@abhimanyu1](https://forum.mautic.org/u/abhimanyu1)\ **Post date:** [January 11, 2016, 3:46pm UTC](https://forum.mautic.org/t/postgresql-option-is-not-showing-in-database-configration/3200/6 "2016-01-11T15:46:12Z")
I have to write any connection string for that??? ---
**Author:** ![escopecz](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/escopecz/32/370_2.png) [@escopecz](https://forum.mautic.org/u/escopecz)\ **Post date:** [January 11, 2016, 3:48pm UTC](https://forum.mautic.org/t/postgresql-option-is-not-showing-in-database-configration/3200/7 "2016-01-11T15:48:33Z")
Not sure what you mean by that. But every time you change the server configuration, you have to restart it so the change applies. ---
**Author:** ![abhimanyu1](https://avatars.discourse-cdn.com/v4/letter/a/e274bd/32.png) [@abhimanyu1](https://forum.mautic.org/u/abhimanyu1)\ **Post date:** [January 11, 2016, 3:59pm UTC](https://forum.mautic.org/t/postgresql-option-is-not-showing-in-database-configration/3200/8 "2016-01-11T15:59:16Z")
yes i am starting every time. but its not showing PostgreSQL sql option… It is possible if now i install the mautic with mysql then change the database to PostgreSQL.??? ---
**Author:** ![escopecz](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/escopecz/32/370_2.png) [@escopecz](https://forum.mautic.org/u/escopecz)\ **Post date:** [January 11, 2016, 4:06pm UTC](https://forum.mautic.org/t/postgresql-option-is-not-showing-in-database-configration/3200/9 "2016-01-11T16:06:52Z")
If Mautic installation doesn’t show the postgres option, it means that the PHP postgres extension is not visible for PHP. Installing with MySql won’t change that. Top secret information from the dev team: Postgres is used in less than 1% of Mautic installation. The dev team is considering to drop the postgres support so they could save some time implementing some necessary SQL queries 2 times which Doctrine cannot handle and optimize for MySql only. So I’d suggest to install Mautic with MySql anyway. ---
**Author:** ![honzakuchar](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/honzakuchar/32/57_2.png) [@honzakuchar](https://forum.mautic.org/u/honzakuchar)\ **Post date:** [February 13, 2016, 3:17pm UTC](https://forum.mautic.org/t/postgresql-option-is-not-showing-in-database-configration/3200/10 "2016-02-13T15:17:47Z")
Hi @escopecz! If this is true, please why not give this into manual or installer? (if you have only postgresql driver installed you do not see that MySQL is the recommended option) Is there any way how to migrate from one database to another? I do not want to be screwed up later when postgresql driver will be removed. Btw using PostgreSQL has one big advantage - it scales better and has much better execution plans for complex queries. However if it is true that only 1% of users uses postgresql then supporting only postgresql is not an option. (btw. GitLab for example supports only PostgreSQL) ---
**Author:** ![escopecz](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/escopecz/32/370_2.png) [@escopecz](https://forum.mautic.org/u/escopecz)\ **Post date:** [February 15, 2016, 8:56am UTC](https://forum.mautic.org/t/postgresql-option-is-not-showing-in-database-configration/3200/11 "2016-02-15T08:56:28Z")
Good questions and good points. The installer maybe should be changed to show all DB driver options and show a warning if the driver is not installed. Please, create a GH issue for it. I googled around and found this tool to convert PostgreSQL dump into MySql: [http://www.lightbox.ca/pg2mysql.php](http://www.lightbox.ca/pg2mysql.php) Do you have some statistics supporting your statement? Maybe if we’d show them to the Mautic users, they’d use Postgres more often. Right now it is 0.7% which is quite small number to support it. ---
**Author:** ![iniyazov](https://avatars.discourse-cdn.com/v4/letter/i/f0a364/32.png) [@iniyazov](https://forum.mautic.org/u/iniyazov)\ **Post date:** [November 16, 2016, 2:57am UTC](https://forum.mautic.org/t/postgresql-option-is-not-showing-in-database-configration/3200/12 "2016-11-16T02:57:40Z")
Kindly provide manual instructions to allow installation on postgresql. Environment that i am in has only postgres a a db option at this time