| From: | Alan Hodgson <ahodgson(at)simkin(dot)ca> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Trouble upgrading from v9.0 to 9.1 |
| Date: | 2012-03-29 00:29:59 |
| Message-ID: | 17321092.fbRHtgcGvi@skynet.simkin.ca |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Wednesday, March 28, 2012 05:15:03 PM JORGE MALDONADO wrote:
> I want to upgrade from v9.0 to 9.1 (I use PostgreSQL for Windows) using a
> backup of my actual DB and then restoring it to the new version. Reading
> the documentation, see that it is recommended to perform a pg_dump with
> version 9.1. I have both versions installed using ports 5432 and 5433, so
> the 2 services are running. So, I change to folder "bin" of v9.1 and type
> the pg_dump command but I get a message telling me that the database I am
> trying to backup does not exist and this is obvious because such a DB was
> created with v9.0. I will very much appreciate any advice.
>
The -p option to pg_dump specifies the port to connect to.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2012-03-29 02:18:20 | Re: Show stored function code |
| Previous Message | JORGE MALDONADO | 2012-03-28 23:15:03 | Trouble upgrading from v9.0 to 9.1 |