Re: DB Creations/ Drop DB :: Not working... - Mailing list pgsql-admin

<soumik.bhattacharjee@kpn.com> writes:
> postgres=# CREATE DATABASE symuatdb
> postgres-#     WITH
> postgres-#     OWNER = postgres
> postgres-#     ENCODING = 'UTF8'
> postgres-#     LC_COLLATE = 'en_US.utf8'
> postgres-#     LC_CTYPE = 'en_US.utf8'
> postgres-#     TABLESPACE = sym_m_data1
> postgres-#     CONNECTION LIMIT = 10;
> ERROR:  could not create directory "pg_tblspc/16386/PG_10_201707211/24576": No such file or directory

It looks like somebody's deleted the directory your tablespace sym_m_data1
is pointing at.

            regards, tom lane