| From: | SAMMY CRISWELL <Sammy_R_Criswell(at)raytheon(dot)com> |
|---|---|
| To: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Upgrade from psql version 9.3 to 9.6. |
| Date: | 2019-05-07 15:13:53 |
| Message-ID: | b5224973d771473f88f593248d991441@BN1F00802MB0033.008f.mgd2.msft.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
I am upgrading PostgreSQL from version 9.3.5 to 9.6.12. The 9.6.12 is on a new server. I am going to use pg_dump to make a backup of the DB on 9.3 and pg_restore on the new 9.6 server.
Should I already have the onwers of the different DBs created as well as empty databases on the new server when I do the restore?
Any other advice would be appreciated.
Sam Criswell | Senior Systems Engineer I
Infrastructure Engineering
Intelligence, Information and Services (IIS)
CityLine Phone: +1 972.664.8870
Raytheon Company
1737 East Cityline Drive | Richardson, TX 75082 USA
Upcoming PTO: 8/5/19 - 8/13/19
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rui DeSousa | 2019-05-07 15:36:05 | Re: postgres wal log configuration question |
| Previous Message | Pavan Kumar | 2019-05-07 14:58:44 | Re: postgres wal log configuration question |