Pg_dump does what you want but you could also set up replication. Thanks, Ben
On Thu, Jan 21, 2021, 8:42 AM Ray O'Donnell <r...@rodonnell.ie> wrote: > On 21/01/2021 13:13, sivapostg...@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 > r...@rodonnell.ie > > >
