Обсуждение: data_directory: remove from process view like ps

Поиск
Список
Период
Сортировка

data_directory: remove from process view like ps

От
Poul Kristensen
Дата:
Hi!

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.

Thanks.
Poul 


Re: data_directory: remove from process view like ps

От
Tom Lane
Дата:
Poul Kristensen <bcc5226@gmail.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


Re: data_directory: remove from process view like ps

От
Poul Kristensen
Дата:
Thanks.
Symbolic links are "poison" for Postgres backup/restore is my experience.

/Poul





2017-04-03 15:52 GMT+02:00 Tom Lane <tgl@sss.pgh.pa.us>:
Poul Kristensen <bcc5226@gmail.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