From: | <soumik(dot)bhattacharjee(at)kpn(dot)com> |
---|---|
To: | <ronljohnsonjr(at)gmail(dot)com>, <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | RE: DB Creations/ Drop DB :: Not working... |
Date: | 2018-12-06 10:32:27 |
Message-ID: | 2A91BEF8171A5349931391E0C721CC53093B7E25@CPEMS-KPN501.KPNCNL.LOCAL |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)gmail(dot)com>
Sent: Wednesday, December 05, 2018 6:49 PM
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: DB Creations/ Drop DB :: Not working...
On 12/05/2018 11:29 AM, Tom Lane wrote:
> <soumik(dot)bhattacharjee(at)kpn(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Shreeyansh Dba | 2018-12-06 10:41:55 | Re: DB Creations/ Drop DB :: Not working... |
Previous Message | Ron | 2018-12-05 17:48:47 | Re: DB Creations/ Drop DB :: Not working... |