From: Alvaro Herrera <alvherre@commandprompt.com>
To: Chris Browne <cbbrowne@acm.org>
Cc: pgsql-admin@postgresql.org
Subject: Re: best practices for separating data and logs
Date: Thu, 3 Jan 2008 19:54:23 -0300
Message-ID: <20080103225423.GA15107@alvh.no-ip.org> (raw)
In-Reply-To: <601w90c8kq.fsf@dba2.int.libertyrms.com>
References: <4544e0330801020946i314c0c8n5830dcc4512849ee@mail.gmail.com>
<17603.1199297401@sss.pgh.pa.us>
<601w90c8kq.fsf@dba2.int.libertyrms.com>
Chris Browne wrote:
> - Alternatively, to help establish common policies, for the "less
> frequent" cases.
>
> env: Sets up PATH, MAN_PATH, PGPORT with the values used by
> the backend in "this" init file
How does this work? I have my own script to do things, and one of the
painful bits is setting up the environment. What my script does is emit
the var definitions to stdout, so I have to run the script on `` to let
the current shell get the definitions.
> logtail: runs "tail -f" on the last log file for the cluster
Hmm, interesting. Perhaps I oughta implement this. Currently my script
starts the server by launching the postmaster in foreground, so there is
no need for this -- but I have frequently wished for an option to start
it in background, and be able to get at the log separately.
I use this script so frequently that I have also implemented bash
completion for it. It is truly helpful. (Of course, it deals with
multiple installations by getting the one to use as an argument, and
autocompletes that as well).
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
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, cbbrowne@acm.org
Subject: Re: best practices for separating data and logs
In-Reply-To: <20080103225423.GA15107@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