PostgreSQL: Copy Database to another Server in Windows (pg_dump – backup & restore)

In our organization, junior database developers are learning PostgreSQL, and they require a sample database from our Validation Database Server. In this scenario, Database Administrator takes PostgreSQL backup using pg_dump utility and restore that dump into the development environment. A pg_dump is a PostgreSQL utility which is used for PostgreSQL database backup and restore. Another […]

November 24, 2016 PostgreSQL, PostgreSQL DBA Script