Thursday, 9 May 2024

Errors happen related PostgresSQL

1. Duplicate key value violates unique constraint in PostgreSQL

local.ERROR: An error occurred: SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint "settings_pkey"

=> Reason: wrong id_seq key

=> Resolve:

SELECT MAX(id) FROM products;
SELECT nextval('products_id_seq');
SELECT setval('products_id_seq', (SELECT MAX(id) FROM products));

Thank you.

2. pg_dump: error: server version: 16.1; pg_dump version: 12.17 (Ubuntu 12.17-0ubuntu0.20.04.1)

- When run pg_dump in container workspace of Laradock to dump sql for DB SDL in container postgres version 16.1

=> Reason error: Wrong pg_dump version in workspace

=> Resolve: Install right pg_dump version 16 in workspace

>> install latest version here

 Thank you

No comments:

Post a Comment

Golang Advanced Interview Q&A