Re: Copy & Re-copy of DB

From: "sivapostgres(at)yahoo(dot)com" <sivapostgres(at)yahoo(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Copy & Re-copy of DB
Date: 2021-01-21 13:13:44
Message-ID: 1776022013.3890342.1611234824367@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 AlwaysBKR Sivaprakash

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ravi Krishna 2021-01-21 13:21:45 Re: Copy & Re-copy of DB
Previous Message Laurenz Albe 2021-01-21 12:43:34 Re: See what options a Postgresql binary was compiled with