| From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
|---|---|
| To: | "Alexandre Leclerc" <aleclerc(at)ipso(dot)ca>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Vacuum Full (PG 8.1) - Urgent help needed - Cancel & transaction "liberation" |
| Date: | 2010-04-16 18:32:54 |
| Message-ID: | 4BC867060200002500030A07@gw.wicourts.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Alexandre Leclerc <aleclerc(at)ipso(dot)ca> wrote:
> I also want to mention that maybe I'm not doing it properly.
>
> I started "postgres.exe" and it is inside that "session",
> "backend>" prompt, that I did run the VACUUM command. Is it that
> way
Yes, that's the single-user mode. Just don't run more than one with
the same -D value at the same time; more than one single-user
backend would not be good.
> (And by the way, what is the command to quit the backend? I'm
> doing Ctrl+C but the DB does not like that...)
In Linux it would be Ctrl+D but in Windows I think it's Ctrl+Z
-Kevin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexandre Leclerc | 2010-04-16 18:47:42 | Re: Vacuum Full (PG 8.1) - Urgent help needed - Cancel & transaction "liberation" |
| Previous Message | Kevin Grittner | 2010-04-16 18:18:06 | Re: Vacuum Full (PG 8.1) - Urgent help needed - Cancel & transaction "liberation" |