Pg_dump and pg_restore are what you want. They create sql files that you pass around.
But seriously, if you have two servers running, replicate one or have your application point to a server address that you can direct via dns to whatever active one you want. Postgres makes replication simple. There are a lot of solutions for your problem but the 1:1 solution to copy over a single file and load it is pg_dump and pg_restore. Thanks, Ben On Thu, Jan 21, 2021, 8:53 AM sivapostg...@yahoo.com <sivapostg...@yahoo.com> wrote: > create database is to create a new database. If we switch to new > database, we need to change the new databasename in the program(s) that > access this database. > > Is there any way to overwrite the data ? > > > On Thursday, 21 January, 2021, 07:12:19 pm IST, 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 > > > >
