Re: Copy & Re-copy of DB - Mailing list pgsql-general

From sivapostgres@yahoo.com
Subject Re: Copy & Re-copy of DB
Date
Msg-id 1776022013.3890342.1611234824367@mail.yahoo.com
Whole thread Raw
Responses Re: Copy & Re-copy of DB  (Ravi Krishna <srkrishna@yahoo.com>)
Re: Copy & Re-copy of DB  (Ray O'Donnell <ray@rodonnell.ie>)
List pgsql-general
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 ?  

Limitation of Backup utility. Transfer to another server was done successfully. When we want to re-copy to original server, we have to delete the original db in the original server, create a new db, restore it.  Is that the only way ?  or any other elegant way available ? 

Happiness Always
BKR Sivaprakash

pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: pljava": ERROR
Next
From: Ravi Krishna
Date:
Subject: Re: Copy & Re-copy of DB