"Daniel Grace" <dgrace@wingsnw.com> writes:
> Bug reference: 6005
> Logged by: Daniel Grace
> Email address: dgrace@wingsnw.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?
regards, tom lane