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.
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 <ray@rodonnell.ie> 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 ?