Re: data_directory: remove from process view like ps

From: Poul Kristensen <bcc5226(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>, aislanluiz(at)hotmail(dot)com
Subject: Re: data_directory: remove from process view like ps
Date: 2017-04-03 14:12:04
Message-ID: CAAOuvVrDafC8B_huyxq=b+unxUtZ+7AmFh91TOjY9pna33EJSg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Thanks.
Symbolic links are "poison" for Postgres backup/restore is my experience.

/Poul

2017-04-03 15:52 GMT+02:00 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:

> Poul Kristensen <bcc5226(at)gmail(dot)com> writes:
> > One off my Postgres installations shows no data directory in the ps.
> > I think it is a good thing, but can't see any difference in the
> > postgresql.conf in the name data_directory in pg_settings when comparing
> to
> > other Postgres installations.
>
> Postgres itself wouldn't ever take any action to show (or hide) that
> information in "ps" output. I suppose that some of your postmasters
> were started with an explicit -D switch on their command line and
> some were not, and that that is the cause of the difference you're
> seeing.
>
> regards, tom lane
>

--
Med venlig hilsen / Best regards
Poul Kristensen
Linux-OS/Virtualizationexpert and Oracle DBA

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Lazaro Garcia 2017-04-03 16:54:11 Re: Help with bad performance with synchronous commit
Previous Message Tom Lane 2017-04-03 13:52:52 Re: data_directory: remove from process view like ps