Changes
Page history
Update Restore instance with backup
authored
Oct 11, 2019
by
Daniel Palomar
Show whitespace changes
Inline
Side-by-side
Restore-instance-with-backup.md
View page @
13b08e3d
1.
Copy the backup in to the server.
2.
Modify the
`docker-compose.yml`
file to add the backup instead the
`import-postgres.sql`
file
:
2.
Stop the OpenCell container
:
```
bash
...
#- /home/opencell/input-files/import-postgres.sql:/docker-entrypoint-initdb.d/import-postgres.sql
- /home/opencell/opencell_12-09-19.sql:/docker-entrypoint-initdb.d/opencell_test.sql
...
```
$ docker stop opencell
```
3.
Drop the OpenCell database:
```
$ docker exec -ti postgres dropdb -U opencell opencell
```
3
.
Done!
4
.
Create the new OpenCell db:
> Be sure that your `$PG_DATA` folder was removed. Normally in `/home/opencell/postgresql/data/`
\ No newline at end of file
```
$ docker exec -ti postgres createdb -U opencell opencell
```
5.
Restore the dump in the new db:
```
$ cat <DUMP_FILE> | docker exec -i postgres psql -U opencell opencell
```
\ No newline at end of file