From: | Chris <chris(at)bitmead(dot)com> |
---|---|
To: | "pgsql-hackers(at)postgreSQL(dot)org" <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | Re: [HACKERS] backend startup |
Date: | 2000-02-09 09:12:56 |
Message-ID: | 38A12F98.1322BE51@bitmead.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Tom Lane wrote:
> If you don't have a postmaster then the backend is running standalone,
> which is not really the same environment as running in a live
> installation. It's OK for some kinds of debugging but I wouldn't
> trust it an inch for locking or resource-related issues.
Yeh, but for some databases, starting a backend/frontend manually IS
possible for a live installation, and improves performance because you
can run in the one process.
> Say what? I've never yet shut down the postmaster to gdb anything;
> I tell gdb to "attach" to a running backend started by the postmaster.
I guess I'm just too lazy to run ps.
> The major
> advantage of that way of working is you can use a reasonable
> client
> (psql or whatever floats your boat) instead of having to type
> queries
> directly at a backend that has no input-editing or command history
> support.
Sure. But if you could run postgres in one-process mode, the backend
would appear to support history because you could build a backend with
psql built in.
There's also no question about whether you're running in
> a realistic environment or not. Finally, you can fire up an additional
> client+backend to examine the database even when you've got the backend
> under test stopped somewhere (so long as it's not stopped holding a
> spinlock or anything like that). If it weren't for the needs of initdb,
> I think standalone-backend mode would've gone the way of the dodo
> some time ago...
>
> regards, tom lane
>
> ************
--
Chris Bitmead
mailto:chris(at)bitmead(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Lo | 2000-02-09 10:01:55 | Re: [HACKERS] WinNT compiling: ongoing |
Previous Message | Tatsuo Ishii | 2000-02-09 08:22:02 | Re: [HACKERS] TODO item |