Re: Regaining superuser access - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: Regaining superuser access
Date
Msg-id 20080918170326.GH3868@alvh.no-ip.org
Whole thread Raw
In response to Re: Regaining superuser access  (Bernt Drange <badrange@gmail.com>)
List pgsql-admin
Bernt Drange escribió:

> After a lot of fiddling with being able to enter single user mode on a
> windows machine (I had to figure out how to run the command line as
> the correct user, then for some reason -D didn't work, but SET
> PGDATA=xxx worked), I finally managed to fix my problem.

Hmm, the -D thing not working should probably be studied -- perhaps
we're missing escaping something somewhere.  Does the PGDATA path
contain spaces or weird chars?

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-admin by date:

Previous
From: Bernt Drange
Date:
Subject: Re: Regaining superuser access
Next
From: Randall Wilson
Date:
Subject: Idle Error invalid byte sequence