Thanks, So I need to re-create - pg_tblspc : no such file or directory ? Or I need to re-install the complete postgres? -----Original Message----- From: Ron <ronljohnsonjr@xxxxxxxxx> Sent: Wednesday, December 05, 2018 6:49 PM To: pgsql-admin@xxxxxxxxxxxxxxxxxxxx Subject: Re: DB Creations/ Drop DB :: Not working... On 12/05/2018 11:29 AM, Tom Lane wrote: > <soumik.bhattacharjee@xxxxxxx> 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.
