public inbox for [email protected]
help / color / mirror / Atom feedPGLOG to be based on PGDATA please
3+ messages / 3 participants
[nested] [flat]
* PGLOG to be based on PGDATA please
@ 2015-09-15 23:21 H Visage <[email protected]>
2015-09-16 08:36 ` Re: PGLOG to be based on PGDATA please Devrim GÜNDÜZ <[email protected]>
0 siblings, 1 reply; 3+ messages in thread
From: H Visage @ 2015-09-15 23:21 UTC (permalink / raw)
To: pgsql-pkg-yum
Goodday,
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) as I
expected the files to be logged related to the Bulk postgresql cluster to
/Data/9.4/Bulk.
However, the postgresql-9.4-setup have fixed values for the PGLOG and
PGUPLOG files :(
<snip>
# Log file for pg_upgrade
PGUPLOG=/var/lib/pgsql/$PGMAJORVERSION/pgupgrade.log
# Log file for initdb
PGLOG=/var/lib/pgsql/9.4/initdb.log
# Get data directory from the service file
PGDATA=`sed -n 's/Environment=PGDATA=//p' "${SERVICE_FILE}"`
</snip>
--
---
Hendrik Visage
Envisage Systems / Envisage Cloud Solutions
084-612-5345 or 083-675-5506
[email protected]
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: PGLOG to be based on PGDATA please
2015-09-15 23:21 PGLOG to be based on PGDATA please H Visage <[email protected]>
@ 2015-09-16 08:36 ` Devrim GÜNDÜZ <[email protected]>
2015-09-16 08:44 ` Re: PGLOG to be based on PGDATA please Hendrik Visage <[email protected]>
0 siblings, 1 reply; 3+ messages in thread
From: Devrim GÜNDÜZ @ 2015-09-16 08:36 UTC (permalink / raw)
To: H Visage <[email protected]>; pgsql-pkg-yum
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)
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR
--
Sent via pgsql-pkg-yum mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-pkg-yum
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: PGLOG to be based on PGDATA please
2015-09-15 23:21 PGLOG to be based on PGDATA please H Visage <[email protected]>
2015-09-16 08:36 ` Re: PGLOG to be based on PGDATA please Devrim GÜNDÜZ <[email protected]>
@ 2015-09-16 08:44 ` Hendrik Visage <[email protected]>
0 siblings, 0 replies; 3+ messages in thread
From: Hendrik Visage @ 2015-09-16 08:44 UTC (permalink / raw)
To: Devrim GÜNDÜZ <[email protected]>; +Cc: pgsql-pkg-yum
Hi Devrim,
> On 16 Sep 2015, at 10:36 AM, Devrim GÜNDÜZ <[email protected]> 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’m 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’t want multiple initdbs’s output in the same file (it might actually be executed
concurrently with something like ansible, and then I do want the different initdb’s logs split at least per custer
as I recreate the databases for new data loadings.
>
> Regards,
> --
> Devrim GÜNDÜZ
> Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
> PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
> Twitter: @DevrimGunduz , @DevrimGunduzTR
>
>
>
---
Hendrik Visage
Envisage Systems / Envisage Cloud Solutions
084-612-5345 or 083-675-5506
[email protected] <mailto:[email protected]>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2015-09-16 08:44 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-09-15 23:21 PGLOG to be based on PGDATA please H Visage <[email protected]>
2015-09-16 08:36 ` Devrim GÜNDÜZ <[email protected]>
2015-09-16 08:44 ` Hendrik Visage <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox