Обсуждение: [BUGS] PostgreSQL 10 - data directory location

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

[BUGS] PostgreSQL 10 - data directory location

От
reader 1001
Дата:
I am using PostgreSQL 10 rc1 in Docker.

Show commands return incorrect data directory location:

SHOW data_directory; returns /var/lib/postrgesql/data

SHOW config_file; returns /var/lib/postgresql/data/postgresql.conf

However, the data directory is completely empty.

Also when I run oid2name, it returns the following error:
"Could not connect to server: No such file or directory. Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"". It may be related to the first part of the question.

Re: [BUGS] PostgreSQL 10 - data directory location

От
"David G. Johnston"
Дата:
On Mon, Oct 2, 2017 at 2:46 PM, reader 1001 <007reader@gmail.com> wrote:
I am using PostgreSQL 10 rc1 in Docker.


This is more likely to be user-error than a bug.​

If you are able to connect and issues "SHOW data_directory" you have a running server and its data files are present at that location - from the perspective of the server.  I suspect you are performing your verification by looking at the client's file system.

It would behoove you to copy/paste an entire shell script session, and probably the Dockerfile + "docker run" invocation, to a new thread on pgsql-general@postgresql.org if you wish others to assist you in understanding exactly what is going on.

David J.