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

Ora2PG - Oracle/MySQL to Postgres DB migration Version 20.0

spfile and pfile errors

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

PostgreSQL New version upgrade

How to Return a Result Set from a PostgreSQL Stored Procedure