#postgresql-9.2 #pg-dump
#postgresql-9.2 #pg-дамп
Вопрос:
Мы используем postgresql версии 9.2. При создании резервной копии базы данных с использованием pg_dump мы сталкиваемся с приведенной ниже ошибкой.
Пожалуйста, подскажите мне, как исправить эту проблему.
pg_dump: [archiver (db)] query was: COPY public.aclappliedtopep (id, instance_version, direction, aclname, ifname, owningentityid, protocolendpoint_id, deploypending, authentityid, authentityclass, accesscontrollist_id) TO stdout;
pg_dump: FATAL: terminating connection due to administrator command
pg_dump: [archiver (db)] query failed: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
pg_dump: [archiver (db)] query was: COPY public.aclappliedtopep (id, instance_version, direction, aclname, ifname, owningentityid, protocolendpoint_id, deploypending, authentityid, authentityclass, accesscontrollist_id) TO stdout;
pg_dump: [archiver (db)] connection to database "qovr" failed: could not connect to server: Connection refused
Is the server running on host "localhost" (127.0.0.1) and accepting
TCP/IP connections on port 5433?
pg_dump: error reading large object 69417845: FATAL: terminating connection due to administrator command
FATAL: terminating connection due to administrator command
pg_dump: could not open large object 59087743: FATAL: terminating connection due to administrator command
FATAL: terminating connection due to administrator command
Комментарии:
1. Вы уверены, что ваш сервер прослушивает localhost 127.0.0.1 и принимает соединения через порт 5433, а не через стандартный порт 5432?
2. да, он прослушивает порт.