Re: DB Creations/ Drop DB :: Not working...

On 12/05/2018 11:29 AM, Tom Lane wrote:
> <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.

$PGDATA/pg_tblspc?


-- 
Angular momentum makes the world go 'round.