PostgreSQL 10 - data directory location
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.
Import Notes
Reply to msg id not found: CAF0oHxOQMkzOKWVU24nCXoFL0XfZe8qROhWuSorviNOdPniBLw@mail.gmail.comReference msg id not found: CAF0oHxOQMkzOKWVU24nCXoFL0XfZe8qROhWuSorviNOdPniBLw@mail.gmail.com
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.