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

From
Subject DB Creations/ Drop DB :: Not working...
Date
Msg-id 2A91BEF8171A5349931391E0C721CC53093B7C45@CPEMS-KPN501.KPNCNL.LOCAL
Whole thread Raw
Responses Re: DB Creations/ Drop DB :: Not working...  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: DB Creations/ Drop DB :: Not working...  (Shreeyansh Dba <shreeyansh2014@gmail.com>)
List pgsql-admin

Hi All,

 

Any idea how to solve this error, tried with pgadmin4 and also using psql CLI

 

And why this comes in?

 

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

postgres=#

 

Thanks

Soumik

pgsql-admin by date:

Previous
From: AYahorau@ibagroup.eu
Date:
Subject: Re: pg_basebackup fails: could not receive data from WAL stream: serverclosed the connection unexpectedly
Next
From: Tom Lane
Date:
Subject: Re: DB Creations/ Drop DB :: Not working...