Re: [HACKERS] 9.4 pg_control corruption

2014-07-27 Thread 李海龙
Hi,dear steven pgsql-hackers I've encountered the similar phenonmenon with 9.4 . 1. environment 1.1 OS version postgres@lhl-Latitude-E5420:~$ cat /etc/issue Ubuntu 13.10 \n \l postgres@lhl-Latitude-E5420:~$ uname -av Linux lhl-Latitude-E5420 3.11.0-12-generic #19-Ubuntu SMP Wed Oct 9

Re: [HACKERS] 9.4 pg_control corruption

2014-07-27 Thread Tom Lane
=?utf-8?B?5p2O5rW36b6Z?= hailong...@qunar.com writes: I have a PostgreSQL datadir named /export/pg94beta1_data/ which was initialized with PostgreSQL 9.4beta1, [ and 9.4beta2 won't start with it ] This is expected; you need to initdb. Or use pg_upgrade to upgrade the cluster. We had to

Re: [HACKERS] 9.4 pg_control corruption

2014-07-27 Thread 李海龙
Understand! Before I wrote last email, I had initialized a new db with PostgreSQL 9.4beta2 and restored the pg_dumpall data of /export/pg94beta1_data/ Thanks Best Regards! at 2014-07-28 00:35 +08, Tom Lane wrote: =?utf-8?B?5p2O5rW36b6Z?= hailong...@qunar.com writes: I have a PostgreSQL

Re: [HACKERS] 9.4 pg_control corruption

2014-07-27 Thread Josh Berkus
On 07/27/2014 09:35 AM, Tom Lane wrote: =?utf-8?B?5p2O5rW36b6Z?= hailong...@qunar.com writes: I have a PostgreSQL datadir named /export/pg94beta1_data/ which was initialized with PostgreSQL 9.4beta1, [ and 9.4beta2 won't start with it ] This is expected; you need to initdb. Or use

[HACKERS] 9.4 pg_control corruption

2014-07-08 Thread Steve Singer
I've encountered a corrupt pg_control file on my 9.4 development cluster. I've mostly been using the cluster for changeset extraction / slony testing. This is a 9.4 (currently commit 6ad903d70a440e + a walsender change discussed in another thread) but would have had the initdb done with an

Re: [HACKERS] 9.4 pg_control corruption

2014-07-08 Thread Tom Lane
Steve Singer st...@ssinger.info writes: I've encountered a corrupt pg_control file on my 9.4 development cluster. I've mostly been using the cluster for changeset extraction / slony testing. This is a 9.4 (currently commit 6ad903d70a440e + a walsender change discussed in another

Re: [HACKERS] 9.4 pg_control corruption

2014-07-08 Thread Steve Singer
On 07/08/2014 10:14 PM, Tom Lane wrote: Steve Singer st...@ssinger.info writes: I've encountered a corrupt pg_control file on my 9.4 development cluster. I've mostly been using the cluster for changeset extraction / slony testing. This is a 9.4 (currently commit 6ad903d70a440e + a walsender

Re: [HACKERS] 9.4 pg_control corruption

2014-07-08 Thread Tom Lane
Steve Singer st...@ssinger.info writes: On 07/08/2014 10:14 PM, Tom Lane wrote: There's no obvious reason to think that this pg_control file is corrupt on its own terms, but the pg_controldata version you're using expects the 942 layout. The fact that the server wasn't complaining about this