Thread: Trouble upgrading from v9.0 to 9.1
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.
Respectfully,
Jorge Maldonado
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.