Restore backup of database to new database name

From: sam turnbull <samturnbull73(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Restore backup of database to new database name
Date: 2015-06-26 13:31:08
Message-ID: CAD_MY-xtbPjnTjEngpcRR8Lnirkc=Cj0Ki9-qFT948o6ESAj7w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi All,

Apologies, incase posting my query in inappropriate group, I am newbie in
PostgreSQL admin.

Requirement

backup database - Test
User(owner) - A

Restore to new database - Test1
under new user - B

Is this possible, since looking at some of discussion, there is no direct
way of doing it.

Appreciate your suggestion.

Regards

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Matheus de Oliveira 2015-06-26 19:06:09 Re: Restore backup of database to new database name
Previous Message David G. Johnston 2015-06-26 13:22:15 Re: select query of mysql to postgres