Re: Copy & Re-copy of DB

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 <ray(at)rodonnell(dot)ie> wrote:

> On 21/01/2021 13:13, sivapostgres(at)yahoo(dot)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
> ray(at)rodonnell(dot)ie
>
>
>