On 21/01/2021 13:13, sivapostgres@xxxxxxxxx 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@xxxxxxxxxxxx
