Restore after a crash

[tou-louse]

how can i restore a backup in unraid with postgres-backup-local, the backups are on an external hard disk which is embedded in the container. The command from the instructions does not work. I always get the message that it is not a container

i using this command

docker exec --tty --interactive $postgresql14 /bin/sh -c "zcat $postgres-latest.sql.gz | psql --username=$postgres --dbname=$postgre
s -W"

[prodrigestivill]

docker exec runs the command in an already running container, do you have the container already running? if so, please use the conainer id instead of $posgresql14.

And follow all the requiered substitutions explained in the README file.

[tou-louse]

Hi,
when i use the container id, i become the same error message

Error: No such container: /bin/sh

The Container is already running and other Container, there using postgres, how plex, are running correct

[prodrigestivill]

did you substitute the ids including the $?

[tou-louse]

Hi, this is my command

docker exec --tty --interactive $b422e0afe654 /bin/sh -c "zcat $postgres-20240229.sql.gz | psql --username=$username --dbname=$dbname -W"

[prodrigestivill]

try removing all $ from your command line.

[tou-louse]

thx for the tipp...

It now accepts the command, but cannot do anything with the file. The file is in the backup folder that is stored in postgres-Backup-local. Where am I making the mistake?

this is the error message

gzip: postgres-20240229.sql.gz: No such file or directory

thx again

[prodrigestivill]

you need to use the full path, to restore the file.

[prodrigestivill]

Example: /backups/daily/DBNAME-20240229.sql.gz