Скачать или смотреть Problem Restoring PostgreSQL Database in Docker Container with Symfony

Hello everyone! I hope this video has helped solve your questions and issues. This video is shared because a solution has been found for the question/problem. I create videos for questions that have solutions. If you have any other issues, feel free to reach out to me on Instagram:   / ky.emrah  

Below, you can find the text related to the question/problem. In the video, the question will be presented first, followed by the answers. If the video moves too fast, feel free to pause and review the answers. If you need more detailed information, you can find the necessary sources and links at the bottom of this description. I hope this video has been helpful, and even if it doesn't directly solve your problem, it will guide you to the source of the solution. I'd appreciate it if you like the video and subscribe to my channel!Problem Restoring PostgreSQL Database in Docker Container with Symfony

I'm developing a Symfony application to backup and restore databases. My application works fine on the Symfony server, but I'm facing issues when trying to use it with my dockerized setup.
Context:
Context:
I have two PostgreSQL databases: the main one named "potter" and a backup one named "backup." I can successfully create a dump of these databases and store the SQL file in my Apache-PHP container at /var/www/var/dump/.
/var/www/var/dump/
/var/www/var/dump/
When I try to restore the main database to the backup, it works perfectly only when I execute the following command in my project terminal:

docker exec -it safebase-backup-1 psql -U user -d backup -f /var/www/var/dump/potter_dump_02-10-2024_14-05-08.sql

docker exec -it safebase-backup-1 psql -U user -d backup -f /var/www/var/dump/potter_dump_02-10-2024_14-05-08.sql
However, when I run the same command in another context (e.g., from my application), I get the following error:

The command "'docker' 'exec' '-i' 'safebase-backup-1' 'psql' '-U' 'user' '-d' 'backup' '-f' '/var/www/var/dump/potter_dump_02-10-2024_14-05-08.sql'" failed. Working directory: /var/www/public Error: proc_open(): posix_spawn() failed: No such file or directory.

The command "'docker' 'exec' '-i' 'safebase-backup-1' 'psql' '-U' 'user' '-d' 'backup' '-f' '/var/www/var/dump/potter_dump_02-10-2024_14-05-08.sql'" failed. Working directory: /var/www/public Error: proc_open(): posix_spawn() failed: No such file or directory.
Questions:
Questions:

Why does the command work in the terminal but fail when executed from my application?
docker exec -it safebase-backup-1 psql -U user -d backup -f /var/www/var/dump/potter_dump_02-10-2024_14-05-08.sql


How can I resolve the "proc_open(): posix_spawn() failed" error?


Why does the command work in the terminal but fail when executed from my application?
docker exec -it safebase-backup-1 psql -U user -d backup -f /var/www/var/dump/potter_dump_02-10-2024_14-05-08.sql


Why does the command work in the terminal but fail when executed from my application?
docker exec -it safebase-backup-1 psql -U user -d backup -f /var/www/var/dump/potter_dump_02-10-2024_14-05-08.sql

docker exec -it safebase-backup-1 psql -U user -d backup -f /var/www/var/dump/potter_dump_02-10-2024_14-05-08.sql

How can I resolve the "proc_open(): posix_spawn() failed" error?

How can I resolve the "proc_open(): posix_spawn() failed" error?
Any help or suggestions would be greatly appreciated!
Thank you!
My code:
My code:
RestoreService:
?php
namespace App\Service;

use Symfony\Component\Process\Exception\ProcessFailedException;
use Symfony\Component\Process\Process;

class RestoreService
{
public function restoreDatabase(string $fileName, string $databaseName): bool
{
$targetContainer = $this- getTargetContainer($databaseName);

$restoreCommand = [
'docker', 'exec', '-i', $targetContainer, 'psql', '-U', 'user', '-d', $databaseName, '-f', "/var/www/var/dump/$fileName"
];
$this- executeProcess($restoreCommand);

return true;
}

private function getTargetContainer(string $databaseName): string
{
switch ($databaseName) {
case 'potter':
return "safebase-database-1";
case 'backup':
return "safebase-backup-1";
default:
throw new \InvalidArgumentException("Database unknown : $datSource of the question:
https://stackoverflow.com/questions/7...

Question and source license information:
https://meta.stackexchange.com/help/l...
https://stackoverflow.com/