Questions tagged [postgresql]

The tag has no usage guidance.

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

Why do Postgres schemas different from "public" sometimes not work with Craft

Due to limits in the production environment of our website, we can not use Postgres' standard schema public. Therefore we configured something different (craftcms) in .env: DB_DRIVER=pgsql DB_SERVER=&...
0
votes
0answers
18 views

Error uploading to asset field from front end form

I'm getting an error when uploading to an asset field from a front end form during entry creation. SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type integer: "...
1
vote
1answer
134 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....
3
votes
1answer
419 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
187 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
426 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
453 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 ...
2
votes
1answer
645 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
59 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 ...