Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZcAXS-0007Pw-7i for pgsql-pkg-yum@arkaria.postgresql.org; Wed, 16 Sep 2015 11:06:10 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZcAXR-000616-JV for pgsql-pkg-yum@arkaria.postgresql.org; Wed, 16 Sep 2015 11:06:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1Zc8KB-0007ew-Lt for pgsql-pkg-yum@postgresql.org; Wed, 16 Sep 2015 08:44:19 +0000 Received: from mail-wi0-f181.google.com ([209.85.212.181]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1Zc8K8-0007x4-H8 for pgsql-pkg-yum@postgresql.org; Wed, 16 Sep 2015 08:44:18 +0000 Received: by wicfx3 with SMTP id fx3so62116273wic.1 for ; Wed, 16 Sep 2015 01:44:15 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:content-type:mime-version:subject:from :in-reply-to:date:cc:message-id:references:to; bh=sVaFbnsH9cUKEsJl6R2+EzPx1N8sJoy/lwKbzHIIwg8=; b=TfDQT90kMKxYgvcD6Dgcn38JHbRdocVhiwGslzegCHHB7XGAYBuohi0THvStKQktql Oxn1BYcluXSKTEQvCRbpXhaBFVju2KUtYiCoqv7gNvo19+hAvYIuIOTwWZMofRiN80Dt /xpbWAfVGE+w/yMdlx4+bBRBJriY5phMHU3xlkSEkSzSBwske+KLuh/32hsSzIDc8Xll 5l541exEjm2sd5EjpxZCbZbWHDDlq2GWKK39kQR9xCxDXQFSLJgzFd3jq1WhO0yVFU4h f5gRj1gXFpRrzMfeag6rO+aBv4wnkrNSKTpMGyioGqZ6DBh+TXpEBCx3vKDVyqE3VhOH 9RNw== X-Gm-Message-State: ALoCoQm8o/ujyfd3Naus0pXk/bXRXNeBvsPKFfJuTz9XeKlcXRier0ipMXK99SgdebCqisgR430+ X-Received: by 10.180.186.10 with SMTP id fg10mr4532849wic.30.1442393055262; Wed, 16 Sep 2015 01:44:15 -0700 (PDT) Received: from blackyos.local (196-210-64-147.dynamic.isadsl.co.za. [196.210.64.147]) by smtp.gmail.com with ESMTPSA id kb5sm25309119wjc.17.2015.09.16.01.44.13 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Wed, 16 Sep 2015 01:44:14 -0700 (PDT) Content-Type: multipart/alternative; boundary="Apple-Mail=_DFCEDD68-06E1-43F3-BCA5-A6A0AFB5BC0A" Mime-Version: 1.0 (Mac OS X Mail 8.2 \(2104\)) Subject: Re: PGLOG to be based on PGDATA please From: Hendrik Visage In-Reply-To: <1442392569.3641.21.camel@gunduz.org> Date: Wed, 16 Sep 2015 10:44:07 +0200 Cc: pgsql-pkg-yum@postgresql.org Message-Id: References: <1442392569.3641.21.camel@gunduz.org> To: =?utf-8?Q?Devrim_G=C3=9CND=C3=9CZ?= X-Mailer: Apple Mail (2.2104) X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-pkg-yum Precedence: bulk Sender: pgsql-pkg-yum-owner@postgresql.org --Apple-Mail=_DFCEDD68-06E1-43F3-BCA5-A6A0AFB5BC0A Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Hi Devrim, > On 16 Sep 2015, at 10:36 AM, Devrim G=C3=9CND=C3=9CZ = wrote: >=20 > Hi, >=20 > On Wed, 2015-09-16 at 01:21 +0200, H Visage wrote: >> based on my previous email, I've set my PGDATA to /Data/9.4/Bulk/ >> but I've also cleaned out /var/lib/pgsql/9.4 (no reason to have that) >=20 > Why do you think that there is no reason to have that? We need to have > a base directory for some stuff, even if you want to customize it. >=20 > Still, I think we can add PGLOG variable to service file and change > setup script to get the value from there. I'll put this in the queue > for new set of releases (likely due next month) I=E2=80=99m a big supporter of the Debian way of handling the Postgresql = clusters where you have the configuration in = /etc/postgresql///postgresql.conf, the data wherever you want (like /Data/ )and then the = postgresql user in /home/postgres For me I then don=E2=80=99t want multiple initdbs=E2=80=99s output in = the same file (it might actually be executed concurrently with something like ansible, and then I do want the = different initdb=E2=80=99s logs split at least per custer as I recreate the databases for new data loadings. >=20 > Regards, > --=20 > Devrim G=C3=9CND=C3=9CZ > Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com > PostgreSQL Dan=C4=B1=C5=9Fman=C4=B1/Consultant, Red Hat Certified = Engineer > Twitter: @DevrimGunduz , @DevrimGunduzTR >=20 >=20 >=20 --- Hendrik Visage Envisage Systems / Envisage Cloud Solutions 084-612-5345 or 083-675-5506 hvisage@envisage.co.za --Apple-Mail=_DFCEDD68-06E1-43F3-BCA5-A6A0AFB5BC0A Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 Hi Devrim,

On 16 Sep 2015, at 10:36 AM, = Devrim G=C3=9CND=C3=9CZ <devrim@gunduz.org> wrote:

Hi,

On Wed, 2015-09-16 at 01:21 +0200, H Visage wrote:
based on my previous = email, I've set my PGDATA to /Data/9.4/Bulk/
but I've also = cleaned out /var/lib/pgsql/9.4 (no reason to have that)

Why do you think that there is no = reason to have that? We need to have
a base directory for = some stuff, even if you want to customize it.

Still, I think we can add PGLOG variable to service file and = change
setup script to get the value from there. I'll put = this in the queue
for new set of releases (likely due next = month)

I=E2=80=99m a big supporter of the Debian way of = handling the Postgresql clusters where
you have the = configuration in = /etc/postgresql/<version>/<clustername>/postgresql.conf,
=
 the data wherever you want (like /Data/<ClusterName> = )and then the postgresql user in /home/postgres
For me I then = don=E2=80=99t want multiple initdbs=E2=80=99s output in the same file = (it might actually be executed
concurrently with something = like ansible, and then I do want the different initdb=E2=80=99s logs = split at least per custer
as I recreate the databases for new = data loadings.


Regards,
--
Devrim G=C3=9CND=C3=9CZ
Principal Systems = Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL = Dan=C4=B1=C5=9Fman=C4=B1/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR




---
Hendrik Visage
Envisage = Systems / Envisage Cloud Solutions
084-612-5345 or = 083-675-5506
hvisage@envisage.co.za



= --Apple-Mail=_DFCEDD68-06E1-43F3-BCA5-A6A0AFB5BC0A--