When running postgreSQL in docker and running sth like docker

Question

When running postgreSQL in docker and running sth like docker

exec -it postgres pg_dump -h localhost -p 5432 -U postgres -d postgres > backup.sql im able to take a backup of that database and store it directly on my pc

but when trying to restore it with pg_restore, then it looks for that sql file inside the docker container rather than on my pc. how could i restore it from my pc directly?

#english #programming

0

15.06.2023

2 ответов

10 просмотров

kusti420 Автор вопроса

Agent Q | You PM me, You Pay
Like this https://stackoverflow.com/a/29913462

thank you so much im on windows not on linux and type backup.sql | docker exec -i postgres psql -U postgres worked

0

10 месяцев назад

Agent Q | You PM me, You Pay · Accepted Answer

Agent Q | You PM me, You Pay

Like this https://stackoverflow.com/a/29913462

0

10 месяцев назад

169 похожих чатов

When running postgreSQL in docker and running sth like docker

2 ответов

Похожие вопросы