Search Postgresql Archives

Re: Copy & Re-copy of DB

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux