Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Single command for Postgresql backup and restore

If u want to parallel dump and restore from one cluster to other u can use below statement.

pg_dump -U postgres -h source_host source-db | psql -U postgres -h Target-host Target-db

Comments

Popular posts from this blog

PostgreSQL pgBadger

ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated ORA-01262: Stat failed on a file destination directory Linux-x86_64 Error: 2: No such file or directory

How to configure Replication Manager (repmgr) ?

Migrating From Oracle to PostgreSQL using ora2pg open source tools

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database