Re: Copy & Re-copy of DB

Поиск
Список
Период
Сортировка
От sivapostgres@yahoo.com
Тема Re: Copy & Re-copy of DB
Дата
Msg-id 1829358841.3898628.1611237155653@mail.yahoo.com
обсуждение исходный текст
Ответ на Re: Copy & Re-copy of DB  (Ray O'Donnell <ray@rodonnell.ie>)
Ответы Re: Copy & Re-copy of DB  (Benedict Holland <benedict.m.holland@gmail.com>)
Re: Copy & Re-copy of DB  (Ken Tanzer <ken.tanzer@gmail.com>)
Список pgsql-general
create database is to create a new database.  If we switch to new database, we need to change the new databasename in the program(s) that access this database.  

Is there any way to overwrite the data ?


On Thursday, 21 January, 2021, 07:12:19 pm IST, Ray O'Donnell <ray@rodonnell.ie> wrote:


On 21/01/2021 13:13, sivapostgres@yahoo.com wrote:

> Hello,
>
> I'm from SQL Server now developing my current project using PG.
>
> In our earlier project(s), we used to copy the database from one server
> to another, work in another server, and re-copy it in the original
> server.   All happened easily with just transferring the two files (mdf
> & ldf) to our required server.
>
> Want to replicate the same in PG.  Is there any way to accomplish the
> same in PG ?


create database <new-db-name> template <old-db-name>

Would that do the job? You could also use pg_dump.

Ray.


--
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie



В списке pgsql-general по дате отправления:

Предыдущее
От: Benedict Holland
Дата:
Сообщение: Re: Copy & Re-copy of DB
Следующее
От: Benedict Holland
Дата:
Сообщение: Re: Copy & Re-copy of DB