Restore a dump database in POSTGRES

Question

Hi,
I have a dump&acute;s database in SERVER 1 , so i want to restore it in my database from linux with the sentence: "psql -U username -W -h host basename
Thank u,  i hope was clear on this one.
Grettings

Rajanikant Hawaldar · Accepted Answer

Don't restore on secondary. It's read only.If you want to restore on secondary, you'll need to break replication. If you want to restore on both. Just restore on primary

Ramón Miguel Quintana Rosa · Answer

the replicarion process it´s running by the "postgres bgworker logical replication launcher", but how can disable it during dump and restore? and then enable it again.   Thanks

Sagar Lad · Answer

Hi Ramon,   Check here for more info :  https://stackoverflow.com/questions/2732474/restore-a-postgres-backup-file-using-the-command-line

Ramón Miguel Quintana Rosa · Answer

Hi, how can  break replication.??   Thnks