Questions tagged [postgresql]
The postgresql tag has no usage guidance.
16
questions
0
votes
0
answers
22
views
Multiple errors attempting to migrate MariaDB Craft CMS 3 database to PostgreSQL via pgloader. Alternatives?
I've been at this for a couple days now and it's not looking good. I'm trying to migrate a Craft CMS 3.9.5 (latest) database running on MariaDB to Postgres using pgloader 3.6.10.
I've attempted this ...
- 111
1
vote
1
answer
50
views
Import database too long
I am trying to optimize sql dump postgres database importation.
My dumps weights about 1.5Go and it takes about 2 hours to import schema and data.
My architecture is dockerized.
Did you faced this ...
- 199
1
vote
1
answer
73
views
Craft installation fails with SQL error (PostgreSQL)
I am trying to install the Craft CMS (Version 4.4.1) on a VM in the Azure Cloud with PostgreSQL 13.9 as managed Azure Service.
The error i'm running into is the following:
*** failed to install Craft: ...
- 41
0
votes
0
answers
58
views
PostgreSQL performance
Looking for someone well versed in the dark arts of PostgreSQL for some potential consultancy (or anyone that can offer hints, tips and advise).
We have always worked with MySQL and made some naïve ...
- 1,741
1
vote
2
answers
55
views
Postgres DB Schema not referenced when accessing web url but craft cmd works fine?
I'm having a strange issue when accessing a craft instance via the web yet the craft cmd works fine. When resolving the URL it's throwing a 503 and the logs are showing an issue with fetching data ...
- 45
2
votes
1
answer
170
views
Migrating a Craft 4 instance from MySQL to PostgreSQL
I've managed to convert a fairly basic Craft 4 MySQL db to PostgreSQL using the pgloader tool, which came with it's own auth related issues when running PSQL v14+ instance - see https://github.com/...
- 45
1
vote
1
answer
260
views
Postgres SSL PDO config for config/db.php
Struggling to configure this correctly and cleanly. When I upgrade to latest 3.x Craft on staging, Craft can no longer connect to the Postgres DB, which uses SSL. Have had success up until CraftCMS ...
- 73
1
vote
1
answer
298
views
Why do Postgres schemas different from "public" sometimes not work with Craft (DDEV / Nitro)
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=&...
- 1,921
1
vote
1
answer
306
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....
- 11
5
votes
1
answer
871
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?
- 67.2k
3
votes
2
answers
259
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,921
1
vote
2
answers
526
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 ...
- 53
1
vote
1
answer
905
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 ...
- 11
2
votes
1
answer
737
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,374
1
vote
1
answer
61
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" ...
- 1,374
2
votes
1
answer
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 ...
- 1,798