Hello, team!
I need help...
When I try to import the database using the import feature, the process completes, but the database doesn’t load correctly. The file size is around 200 MB, but after backup, it only shows 400 bytes, indicating that the import didn’t actually take place. I’m working with PostgreSQL 16, and it seems that the database import isn’t being executed properly..... how to do....
Can send to me too command ssh acess...
-09 16:54:31.242 CET [240156] LOG: statement: SET statement_timeout = 0;
2025-01-09 16:54:31.245 CET [240156] LOG: statement: SET lock_timeout = 0;
2025-01-09 16:54:31.246 CET [240156] LOG: statement: SET idle_in_transaction_session_timeout = 0;
2025-01-09 16:54:31.246 CET [240156] LOG: statement: SET client_encoding = 'UTF8';
2025-01-09 16:54:31.247 CET [240156] LOG: statement: SET standard_conforming_strings = on;
2025-01-09 16:54:31.248 CET [240156] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false);
2025-01-09 16:54:31.277 CET [240156] LOG: statement: SET check_function_bodies = false;
2025-01-09 16:54:31.278 CET [240156] LOG: statement: SET xmloption = content;
2025-01-09 16:54:31.278 CET [240156] LOG: statement: SET client_min_messages = warning;
2025-01-09 16:54:31.279 CET [240156] LOG: statement: SET row_security = off;
2025-01-09 16:54:31.279 CET [240156] LOG: statement: DROP DATABASE sgl_loja;
2025-01-09 16:54:31.280 CET [240156] ERROR: database "sgl_loja" does not exist
2025-01-09 16:54:31.280 CET [240156] STATEMENT: DROP DATABASE sgl_loja;
2025-01-09 16:54:31.281 CET [240156] LOG: statement: CREATE DATABASE sgl_loja WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'pt_BR.UTF-8' LC_CTYPE = 'pt_BR.UTF-8';
2025-01-09 16:54:31.282 CET [240156] ERROR: invalid LC_COLLATE locale name: "pt_BR.UTF-8"
2025-01-09 16:54:31.282 CET [240156] HINT: If the locale name is specific to ICU, use ICU_LOCALE.
2025-01-09 16:54:31.282 CET [240156] STATEMENT: CREATE DATABASE sgl_loja WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'pt_BR.UTF-8' LC_CTYPE = 'pt_BR.UTF-8';
2025-01-09 16:54:31.283 CET [240156] LOG: statement: ALTER DATABASE sgl_loja OWNER TO sglloja;
2025-01-09 16:54:31.283 CET [240156] ERROR: database "sgl_loja" does not exist
2025-01-09 16:54:31.283 CET [240156] STATEMENT: ALTER DATABASE sgl_loja OWNER TO sglloja;
2025-01-09 16:54:31.286 CET [240157] FATAL: database "sgl_loja" does not exist
Thanks you