From: | Chris Ernst <cernst(at)zvelo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_upgrade not detecting version properly |
Date: | 2012-10-10 16:35:06 |
Message-ID: | 5075A3BA.9000502@zvelo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
On 10/10/2012 09:56 AM, Bruce Momjian wrote:
> Can you show me what is in the PG_VERSION file in the old cluster? It
> should be "9.1".
Hi Bruce,
Thank you for the reply. Indeed it is "9.1":
# cat /postgresql/9.1/main/PG_VERSION
9.1
And just for good measure:
cat /postgresql/9.2/main/PG_VERSION
9.2
And there are no other PostgreSQL versions on this machine.
Hmm... I was just about to send this when something else occurred to me.
I had initially tried to run pg_upgrade as root and it said it couldn't
be run as root. So I've been running it as my own user (which is in the
postgres group). However, everything in /postgresql/9.1/main is owned
by postgres with 700 permissions.
I switched to the postgres user and now pg_upgrade is running. Perhaps
just a more informative error message is in order.
Thank you for the shove in the right direction =)
Cheers!
- Chris
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Sabino Mullane | 2012-10-10 17:06:55 | Planner chooses multi-column index in 9.2 when maybe it should not |
Previous Message | Sumit Raja | 2012-10-10 16:25:51 | FTS for a controlled vocab |
From | Date | Subject | |
---|---|---|---|
Next Message | Hannu Krosing | 2012-10-10 16:52:11 | Re: Is there a good reason why PL languages do not support cstring type arguments and return values ? |
Previous Message | Fujii Masao | 2012-10-10 16:23:40 | Re: [PATCH] Make pg_basebackup configure and start standby [Review] |