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

Hi Soumik,

It looks like your tablespace is as pointing correctly on 16386 to
$PGDATA/pg_tblspc location. However, files in this goes missing(16386).

May consider recreating the tablespace.

<http://www.shreeyansh.com>

On Thu, Dec 6, 2018 at 4:19 PM <soumik(dot)bhattacharjee(at)kpn(dot)com> wrote:

> postgres=# SELECT spcname FROM pg_tablespace;
>
> spcname
>
> --------------
>
> pg_default
>
> pg_global
>
> *sym_m_data1*
>
> *sym_m_index1*
>
> (4 rows)
>
>
>
> postgres=#
>
>
>
> *From:* Bhattacharjee, Soumik
> *Sent:* Thursday, December 06, 2018 11:48 AM
> *To:* 'Shreeyansh Dba' <shreeyansh2014(at)gmail(dot)com>
> *Cc:* pgsql-admin <pgsql-admin(at)postgresql(dot)org>
> *Subject:* RE: DB Creations/ Drop DB :: Not working...
>
>
>
> Thanks,
>
>
>
> But i can see the below in server.
>
>
>
> postgres(at)postgresdb-uat-postgresql-5b9fb67fcd-dbpb4:~/data/pgdata/postgresql-db/pg_tblspc$
> ls -ltr
>
> total 0
>
> *lrwxrwxrwx. 1 postgres postgres 24 Dec 5 15:21 16386 ->
> /var/lib/postgresql/data*
>
> *lrwxrwxrwx. 1 postgres postgres 28 Dec 5 15:27 16389 ->
> /var/lib/postgresql/data/idx*
>
> postgres(at)postgresdb-uat-postgresql-5b9fb67fcd-dbpb4:~/data/pgdata/postgresql-db/pg_tblspc$
> pwd
>
> */var/lib/postgresql/data/pgdata/postgresql-db/pg_tblspc*
>
>
>
>
>
> Do I need to re-create the pg_tblspc or user defined tablespaces?
>
>
>
> Thanks
>
> Soumik
>
>
>
>
>
> *From:* Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com>
> *Sent:* Thursday, December 06, 2018 11:42 AM
> *To:* Bhattacharjee, Soumik <soumik(dot)bhattacharjee(at)kpn(dot)com>
> *Cc:* pgsql-admin <pgsql-admin(at)postgresql(dot)org>
> *Subject:* Re: DB Creations/ Drop DB :: Not working...
>
>
>
> Hi Soumik,
>
> It seems your tablespace directory deleted by someone and you need to
> recreate tablespace for your database.
>
> Go through the below link for more details.
>
> https://www.postgresql.org/docs/10/manage-ag-tablespaces.html
>
> Hope this will helps.
>
> <http://www.shreeyansh.com>
>
>
>
> On Wed, Dec 5, 2018 at 10:40 PM <soumik(dot)bhattacharjee(at)kpn(dot)com> wrote:
>
> 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
>
>