0
I cannot restore a backup using pg_restore, while trying to restore the process starts, but shortly afterwards it stops and says that it is "without memory"
~$ /usr/bin/pg_restore --host "localhost" --port "5432" --username
"postgres" --no-password --dbname "local_db" --verbose
"/run/media/juliana/ARQUIVOS/banco.backup"
...
pg_restore: processando dados da tabela "public.atividadeartantiga"
pg_restore: processando dados da tabela "public.atividadeartwebantiga"
sem memória
pg_restore: processando dados da tabela "public.atividadeartwebantiga"
sem memória
the backup version of postgres and the current version are the same?
– Lucas Miranda
No, the backup was done on a computer with Postgres 9.4 and want to restore on my computer that has Postgres 11
– Juliana Marques
you can try increasing the memory (work_mem) and try again, but from what I read in some forums may be an error by the version
– Lucas Miranda
How do I increase the work_mem?
– Juliana Marques
just change postgresql.conf, more information https://www.postgresql.org/docs/9.3/config-setting.html
– Lucas Miranda
I changed here from 4MB to 50MB, but did not solve
– Juliana Marques
If it is possible to run pg_dump of version 11 on the version 9.4 database that will probably solve the issue of possible version conflicts.
– anonimo
Das release Notes of versions 10 and 11: "A dump/Restore using pg_dumpall, or use of pg_upgrade, is required for those wishing to migrate data from any Previous release."
– anonimo