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