TOP / PostgreSQL
<<.. 4 5 6 7 8.. >>

2021年04月29日

プロパティの保存中にエラーが発生しました

pgAdmin4 4.29
(sqlite3.IntegrityError) UNIQUE constraint failed: database.id, database.server
[SQL: INSERT INTO "database" (id, schema_res, server) VALUES (?, ?, ?)]
[parameters: (16384, '', 19)]
(Background on this error at: http://sqlalche.me/e/13/gkpj)
無題.png



22.png
posted by a23 at 14:56| Comment(0) | PostgreSQL

2021年04月14日

pg_restore.exe' file not found. please correct the binary path in the preferences dialog

restore で　エラー

'c:\program files\postgresql\13\pgadmin 4\runtime\pg_restore.exe' file not found. please correct the binary path in the preferences dialog
pga01.png


File→Preferences→Path→Binary Path


pga02.png


C:\Program Files\PostgreSQL\13\bin


pga03.png



pga04.png
posted by a23 at 13:58| Comment(9) | PostgreSQL

2020年11月13日

backup

pgBackrest
pgBarman
EDB BART
posted by a23 at 10:20| Comment(0) | PostgreSQL
<<.. 4 5 6 7 8.. >>