Re: Copy & Re-copy of DB

Поиск

Список

Период

Сортировка

От	Ken Tanzer
Тема	Re: Copy & Re-copy of DB
Дата	22 января 2021 г. 10:34:59
Msg-id	CAD3a31U2c_XGOonZo6e_UKNVZ0p3aFefAHm5RUHeoHMh-SHX2Q@mail.gmail.com обсуждение исходный текст
Ответ на	Re: Copy & Re-copy of DB ("sivapostgres@yahoo.com" <sivapostgres@yahoo.com>)
Ответы	Re: Copy & Re-copy of DB (Benedict Holland <benedict.m.holland@gmail.com>)
Список	pgsql-general

Дерево обсуждения

On Thu, Jan 21, 2021 at 11:12 PM sivapostgres@yahoo.com <sivapostgres@yahoo.com> wrote:

So the solution to the issue will be

1. Backup a DB using PGDUMP from 1st server.
2. Restore the DB in 2nd server.
3. Make required changes in the 2nd server.
4. Backup that DB using PGDUMP from 2nd server.
5. Delete / Rename that DB in the 1st server
6. Restore that DB in the 1st server.
7. Work again in the 1st server.

Is this the best way to carry out this process?

Well I don't know if it's best or not. But you said you wanted:

to copy the database from one server to another, work in another server, and re-copy it in the original server.

(and additionally end up with the database having the same name on the original server.)

So your steps do seem like they would be one way to accomplish that. What counts as the "best" way would depend on what else is important to you about this process, i.e. what criteria would you use for best?

Cheers,
Ken