Questions tagged [postgresql]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
92 views

Testing database credentials Craft 3 Setup

When i try setup db in craft 3 at windows with composer using php craft setup/db command it give me Which database driver are you using? [mysql,pgsql,?]: pgsql Database server name or IP address: [127....
0
votes
0answers
17 views

Problem with entry relations in using craft + postgres

I have a custom module saving entries into the system and those entries contains several category relationships. I have done the same previously with MySql and never had problems. I am currently ...
3
votes
1answer
320 views

Is there a way to convert a Craft MySQL database to PostgreSQL?

I have an existing Craft installation using MySQL and I've only recently realized the error of my ways and would like to convert the database to PostgreSQL. Is this possible?
3
votes
2answers
157 views

Migrate Craft CMS installation from PgSQL to MySQL - any hints?

We need to migrate a Craft installation with a pgsql dump to MySQL. Any hints on the procedure? Thanks, Matthias
1
vote
2answers
362 views

How do you deploy Craft 3 on Heroku with Postgres?

I'm relatively new to Craft 3, and am able to run Craft locally with a Postgres db and Valet as my server. When I try to deploy to Heroku, I run into issues with (I think) Postgres. Background I ...
1
vote
1answer
403 views

Integrity constraint violation - Not null violation

Looking for some help here - I'm working on a site that is using a PostgreSQL db and am running into an issue. When saving a large Matrix field with multiple block types I was receiving the following ...
1
vote
1answer
600 views

Install Failed - Numerous Errors when running with pgsql

Getting Numerous errors when trying to test a staging environment with Craft 3.1. States Install Failed - Check Logs which I have and I'm seeing the following logs being given. I don't understand what'...
1
vote
1answer
56 views

SQL Error (Feed Me) when matching entries

I'm currently getting the following error when matching on an entry field. Offers Test: SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: integer ~~ unknown LINE 3: WHERE "id" ...
2
votes
1answer
2k views

Craft 3 : What are the advantages to use PostgreSQL and when should I use it instead of MySQL?

Craft 3 now supports PostgreSQL. I know this a very general question, but: I have absolutely no experience with PostgreSQL I don't know when should I use it instead of MySQL To quote Bob Olde ...