From: Alvaro Herrera <alvherre@commandprompt.com>
To: Bernt Drange <badrange@gmail.com>
Cc: pgsql-admin@postgresql.org, Pg Hackers <pgsql-hackers@postgresql.org>
Subject: Re: Regaining superuser access
Date: Thu, 18 Sep 2008 13:03:26 -0400
Message-ID: <20080918170326.GH3868@alvh.no-ip.org> (raw)
In-Reply-To: <aaad999b-500f-4c13-a738-0a35bd443b23@m73g2000hsh.googlegroups.com>
References: <355ba921-203b-4380-bee4-67209316be62@x35g2000hsb.googlegroups.com>
<497334.45125.qm@web25803.mail.ukl.yahoo.com>
<aaad999b-500f-4c13-a738-0a35bd443b23@m73g2000hsh.googlegroups.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: alvherre@commandprompt.com, badrange@gmail.com, pgsql-hackers@postgresql.org
Subject: Re: Regaining superuser access
In-Reply-To: <20080918170326.GH3868@alvh.no-ip.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox