From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Daniel Grace <dgrace(at)wingsnw(dot)com>, pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #6005: ALTER ROLE ... VALID UNTIL 'infinity' crashes postmaster on a fresh install |
Date: | 2011-05-11 19:59:17 |
Message-ID: | BANLkTinKbQtpB-Jg9a=Z4bFhcQoL5r6tXw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Wed, May 4, 2011 at 4:39 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Daniel Grace" <dgrace(at)wingsnw(dot)com> writes:
>> Bug reference: 6005
>> Logged by: Daniel Grace
>> Email address: dgrace(at)wingsnw(dot)com
>> PostgreSQL version: 9.1-beta1
>> Operating system: Win7 x64 (x86 postgres)
>> Description: ALTER ROLE ... VALID UNTIL 'infinity' crashes postmaster
>> on a fresh install
>> Details:
>
>> While trying to restore a database created under 9.1 alpha (created with
>> pg_dumpall):
>
>> CREATE ROLE postgres;
>> ALTER ROLE postgres WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN
>> REPLICATION PASSWORD 'xxxx';
>> CREATE ROLE foo;
>> ALTER ROLE foo WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB NOLOGIN
>> NOREPLICATION VALID UNTIL 'infinity';
>
>> The final statement causes postmaster to crash.
>
> Hmm, cannot duplicate this here ... can anyone else? Windows-specific
> issue perhaps?
Will commit 2e82d0b396473b595a30f68b37b8dfd41c37dff8 have possibly fixed this?
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-05-11 20:36:41 | Re: BUG #6005: ALTER ROLE ... VALID UNTIL 'infinity' crashes postmaster on a fresh install |
Previous Message | Robert Haas | 2011-05-11 19:55:02 | Re: BUG #5996: CURRENT_TIMESTAMP uses often undesired TRANSACTION_TIMESTAMP, instead of STATEMENT_TIMESTAMP |