Docker & Postgres - Rename database & remove old one

Asked Feb 01 '22 at 13:48

Active Feb 01 '22 at 13:58

Viewed 700 times

I have my Gitlab CI running with Symfony, I have fixtures loaded and I want to load them in a buffer dabatase, and then to move them to the real database.

I've seen this thread: Docker - How can run the psql command in the postgres container?, but I would like to have an automatic script which:

delete my real database
rename my buffer database to the real database's name

Is it possible using Docker & Gitlab CI to automate such commands? I am using pg_dump for now, but it's long an not easy to use, I just want to replace a DB with an other DB.

edited Feb 01 '22 at 13:58

asked Feb 01 '22 at 13:48

Vincent Decaux

9,857
6
56
84

The linked answer explains how to run psql in a container, so use that to run drop/alter database commands and it’s done? – Sami Kuhmonen Feb 01 '22 at 14:10
What prevents you from running `DROP DATABASE real;` followed by `ALTER DATABASE buffer RENAME TO real;` against your postgres container ? – Zeitounator Feb 01 '22 at 14:11
@Zeitounator yes I missreaded the thread, because I thought we needed a password and so an interactive console to do a command, seems to be fine without, trying and I will update my question – Vincent Decaux Feb 01 '22 at 14:14
you probably need to use pg_dump one way or another. – The Fool Feb 01 '22 at 14:29
@TheFool can you be more precise? any feedback or documentation? – Vincent Decaux Feb 01 '22 at 14:39

Docker & Postgres - Rename database & remove old one

0 Answers0