From: | <soumik(dot)bhattacharjee(at)kpn(dot)com> |
---|---|
To: | <shreeyansh2014(at)gmail(dot)com> |
Cc: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | RE: DB Creations/ Drop DB :: Not working... |
Date: | 2018-12-06 10:49:32 |
Message-ID: | 2A91BEF8171A5349931391E0C721CC53093B7E5D@CPEMS-KPN501.KPNCNL.LOCAL |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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<mailto:shreeyansh2014(at)gmail(dot)com>>
Sent: Thursday, December 06, 2018 11:42 AM
To: Bhattacharjee, Soumik <soumik(dot)bhattacharjee(at)kpn(dot)com<mailto:soumik(dot)bhattacharjee(at)kpn(dot)com>>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org<mailto: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.
[https://docs.google.com/uc?export=download&id=1gGhoMTYjvHWLCZkro06CHfeV5B0i67aE&revid=0B0kMUYo6rsLZRXpXakFESmpyK2NqbG5BOW9zakpWU2U3S3NjPQ]<http://www.shreeyansh.com>
On Wed, Dec 5, 2018 at 10:40 PM <soumik(dot)bhattacharjee(at)kpn(dot)com<mailto: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
From | Date | Subject | |
---|---|---|---|
Next Message | Avinash Kumar | 2018-12-06 11:14:45 | Re: DB Creations/ Drop DB :: Not working... |
Previous Message | soumik.bhattacharjee | 2018-12-06 10:47:34 | RE: DB Creations/ Drop DB :: Not working... |