pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDB Creations/ Drop DB :: Not working...
10+ messages / 5 participants
[nested] [flat]
* DB Creations/ Drop DB :: Not working...
@ 2018-12-05 17:10 soumik.bhattacharjee@kpn.com
2018-12-05 17:29 ` Re: DB Creations/ Drop DB :: Not working... Tom Lane <tgl@sss.pgh.pa.us>
2018-12-06 10:41 ` Re: DB Creations/ Drop DB :: Not working... Shreeyansh Dba <shreeyansh2014@gmail.com>
0 siblings, 2 replies; 10+ messages in thread
From: soumik.bhattacharjee@kpn.com @ 2018-12-05 17:10 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: DB Creations/ Drop DB :: Not working...
2018-12-05 17:10 DB Creations/ Drop DB :: Not working... soumik.bhattacharjee@kpn.com
@ 2018-12-05 17:29 ` Tom Lane <tgl@sss.pgh.pa.us>
2018-12-05 17:48 ` Re: DB Creations/ Drop DB :: Not working... Ron <ronljohnsonjr@gmail.com>
1 sibling, 1 reply; 10+ messages in thread
From: Tom Lane @ 2018-12-05 17:29 UTC (permalink / raw)
To: soumik.bhattacharjee@kpn.com; +Cc: pgsql-admin
<soumik.bhattacharjee@kpn.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.
regards, tom lane
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: DB Creations/ Drop DB :: Not working...
2018-12-05 17:10 DB Creations/ Drop DB :: Not working... soumik.bhattacharjee@kpn.com
2018-12-05 17:29 ` Re: DB Creations/ Drop DB :: Not working... Tom Lane <tgl@sss.pgh.pa.us>
@ 2018-12-05 17:48 ` Ron <ronljohnsonjr@gmail.com>
2018-12-06 10:32 ` RE: DB Creations/ Drop DB :: Not working... soumik.bhattacharjee@kpn.com
0 siblings, 1 reply; 10+ messages in thread
From: Ron @ 2018-12-05 17:48 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
On 12/05/2018 11:29 AM, Tom Lane wrote:
> <soumik.bhattacharjee@kpn.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.
^ permalink raw reply [nested|flat] 10+ messages in thread
* RE: DB Creations/ Drop DB :: Not working...
2018-12-05 17:10 DB Creations/ Drop DB :: Not working... soumik.bhattacharjee@kpn.com
2018-12-05 17:29 ` Re: DB Creations/ Drop DB :: Not working... Tom Lane <tgl@sss.pgh.pa.us>
2018-12-05 17:48 ` Re: DB Creations/ Drop DB :: Not working... Ron <ronljohnsonjr@gmail.com>
@ 2018-12-06 10:32 ` soumik.bhattacharjee@kpn.com
0 siblings, 0 replies; 10+ messages in thread
From: soumik.bhattacharjee@kpn.com @ 2018-12-06 10:32 UTC (permalink / raw)
To: ronljohnsonjr@gmail.com; pgsql-admin@lists.postgresql.org
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@gmail.com>
Sent: Wednesday, December 05, 2018 6:49 PM
To: pgsql-admin@lists.postgresql.org
Subject: Re: DB Creations/ Drop DB :: Not working...
On 12/05/2018 11:29 AM, Tom Lane wrote:
> <soumik.bhattacharjee@kpn.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.
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: DB Creations/ Drop DB :: Not working...
2018-12-05 17:10 DB Creations/ Drop DB :: Not working... soumik.bhattacharjee@kpn.com
@ 2018-12-06 10:41 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
2018-12-06 10:47 ` RE: DB Creations/ Drop DB :: Not working... soumik.bhattacharjee@kpn.com
2018-12-06 10:49 ` RE: DB Creations/ Drop DB :: Not working... soumik.bhattacharjee@kpn.com
1 sibling, 2 replies; 10+ messages in thread
From: Shreeyansh Dba @ 2018-12-06 10:41 UTC (permalink / raw)
To: soumik.bhattacharjee@kpn.com; +Cc: pgsql-admin
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.bhattacharjee@kpn.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
>
^ permalink raw reply [nested|flat] 10+ messages in thread
* RE: DB Creations/ Drop DB :: Not working...
2018-12-05 17:10 DB Creations/ Drop DB :: Not working... soumik.bhattacharjee@kpn.com
2018-12-06 10:41 ` Re: DB Creations/ Drop DB :: Not working... Shreeyansh Dba <shreeyansh2014@gmail.com>
@ 2018-12-06 10:47 ` soumik.bhattacharjee@kpn.com
1 sibling, 0 replies; 10+ messages in thread
From: soumik.bhattacharjee@kpn.com @ 2018-12-06 10:47 UTC (permalink / raw)
To: shreeyansh2014@gmail.com; +Cc: pgsql-admin
Thanks,
But i can see the below in server.
postgres@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@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@gmail.com>
Sent: Thursday, December 06, 2018 11:42 AM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
Cc: pgsql-admin <pgsql-admin@postgresql.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=0B0kMU...]<http://www.shreeyansh.com;
On Wed, Dec 5, 2018 at 10:40 PM <soumik.bhattacharjee@kpn.com<mailto:soumik.bhattacharjee@kpn.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
^ permalink raw reply [nested|flat] 10+ messages in thread
* RE: DB Creations/ Drop DB :: Not working...
2018-12-05 17:10 DB Creations/ Drop DB :: Not working... soumik.bhattacharjee@kpn.com
2018-12-06 10:41 ` Re: DB Creations/ Drop DB :: Not working... Shreeyansh Dba <shreeyansh2014@gmail.com>
@ 2018-12-06 10:49 ` soumik.bhattacharjee@kpn.com
2018-12-06 11:14 ` Re: DB Creations/ Drop DB :: Not working... Avinash Kumar <avinash.vallarapu@gmail.com>
2018-12-06 11:35 ` Re: DB Creations/ Drop DB :: Not working... Shreeyansh Dba <shreeyansh2014@gmail.com>
1 sibling, 2 replies; 10+ messages in thread
From: soumik.bhattacharjee@kpn.com @ 2018-12-06 10:49 UTC (permalink / raw)
To: shreeyansh2014@gmail.com; +Cc: 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@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: RE: DB Creations/ Drop DB :: Not working...
Thanks,
But i can see the below in server.
postgres@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@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@gmail.com<mailto:shreeyansh2014@gmail.com>>
Sent: Thursday, December 06, 2018 11:42 AM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com<mailto:soumik.bhattacharjee@kpn.com>>
Cc: pgsql-admin <pgsql-admin@postgresql.org<mailto:pgsql-admin@postgresql.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=0B0kMU...]<http://www.shreeyansh.com;
On Wed, Dec 5, 2018 at 10:40 PM <soumik.bhattacharjee@kpn.com<mailto:soumik.bhattacharjee@kpn.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
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: DB Creations/ Drop DB :: Not working...
2018-12-05 17:10 DB Creations/ Drop DB :: Not working... soumik.bhattacharjee@kpn.com
2018-12-06 10:41 ` Re: DB Creations/ Drop DB :: Not working... Shreeyansh Dba <shreeyansh2014@gmail.com>
2018-12-06 10:49 ` RE: DB Creations/ Drop DB :: Not working... soumik.bhattacharjee@kpn.com
@ 2018-12-06 11:14 ` Avinash Kumar <avinash.vallarapu@gmail.com>
1 sibling, 0 replies; 10+ messages in thread
From: Avinash Kumar @ 2018-12-06 11:14 UTC (permalink / raw)
To: soumik.bhattacharjee@kpn.com; +Cc: shreeyansh2014@gmail.com; pgsql-admin
Hi Sounim,
Lets make it simple.
Do the following steps.
$ psql
\db
You should see the list of tablespaces and their locations.
Check if the location specified for the tablespace => *sym_m_data1 *exists.
If not, create it or fix the permission issues, if any.
Regards,
Avinash Vallarapu.
On Thu, Dec 6, 2018 at 4:19 PM <soumik.bhattacharjee@kpn.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@gmail.com>
> *Cc:* pgsql-admin <pgsql-admin@postgresql.org>
> *Subject:* RE: DB Creations/ Drop DB :: Not working...
>
>
>
> Thanks,
>
>
>
> But i can see the below in server.
>
>
>
> postgres@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@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@gmail.com>
> *Sent:* Thursday, December 06, 2018 11:42 AM
> *To:* Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
> *Cc:* pgsql-admin <pgsql-admin@postgresql.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.bhattacharjee@kpn.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
>
>
--
9000799060
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: DB Creations/ Drop DB :: Not working...
2018-12-05 17:10 DB Creations/ Drop DB :: Not working... soumik.bhattacharjee@kpn.com
2018-12-06 10:41 ` Re: DB Creations/ Drop DB :: Not working... Shreeyansh Dba <shreeyansh2014@gmail.com>
2018-12-06 10:49 ` RE: DB Creations/ Drop DB :: Not working... soumik.bhattacharjee@kpn.com
@ 2018-12-06 11:35 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
2018-12-06 12:12 ` RE: DB Creations/ Drop DB :: Not working... soumik.bhattacharjee@kpn.com
1 sibling, 1 reply; 10+ messages in thread
From: Shreeyansh Dba @ 2018-12-06 11:35 UTC (permalink / raw)
To: soumik.bhattacharjee@kpn.com; +Cc: pgsql-admin
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.bhattacharjee@kpn.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@gmail.com>
> *Cc:* pgsql-admin <pgsql-admin@postgresql.org>
> *Subject:* RE: DB Creations/ Drop DB :: Not working...
>
>
>
> Thanks,
>
>
>
> But i can see the below in server.
>
>
>
> postgres@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@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@gmail.com>
> *Sent:* Thursday, December 06, 2018 11:42 AM
> *To:* Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
> *Cc:* pgsql-admin <pgsql-admin@postgresql.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.bhattacharjee@kpn.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
>
>
^ permalink raw reply [nested|flat] 10+ messages in thread
* RE: DB Creations/ Drop DB :: Not working...
2018-12-05 17:10 DB Creations/ Drop DB :: Not working... soumik.bhattacharjee@kpn.com
2018-12-06 10:41 ` Re: DB Creations/ Drop DB :: Not working... Shreeyansh Dba <shreeyansh2014@gmail.com>
2018-12-06 10:49 ` RE: DB Creations/ Drop DB :: Not working... soumik.bhattacharjee@kpn.com
2018-12-06 11:35 ` Re: DB Creations/ Drop DB :: Not working... Shreeyansh Dba <shreeyansh2014@gmail.com>
@ 2018-12-06 12:12 ` soumik.bhattacharjee@kpn.com
0 siblings, 0 replies; 10+ messages in thread
From: soumik.bhattacharjee@kpn.com @ 2018-12-06 12:12 UTC (permalink / raw)
To: shreeyansh2014@gmail.com; +Cc: pgsql-admin
Thanks to you and All here.
I will follow the steps and update you all.
From: Shreeyansh Dba <shreeyansh2014@gmail.com>
Sent: Thursday, December 06, 2018 12:35 PM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: 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.
[https://docs.google.com/uc?export=download&id=1gGhoMTYjvHWLCZkro06CHfeV5B0i67aE&revid=0B0kMU...]<http://www.shreeyansh.com;
On Thu, Dec 6, 2018 at 4:19 PM <soumik.bhattacharjee@kpn.com<mailto:soumik.bhattacharjee@kpn.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@gmail.com<mailto:shreeyansh2014@gmail.com>>
Cc: pgsql-admin <pgsql-admin@postgresql.org<mailto:pgsql-admin@postgresql.org>>
Subject: RE: DB Creations/ Drop DB :: Not working...
Thanks,
But i can see the below in server.
postgres@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@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@gmail.com<mailto:shreeyansh2014@gmail.com>>
Sent: Thursday, December 06, 2018 11:42 AM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com<mailto:soumik.bhattacharjee@kpn.com>>
Cc: pgsql-admin <pgsql-admin@postgresql.org<mailto:pgsql-admin@postgresql.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=0B0kMU...]<http://www.shreeyansh.com;
On Wed, Dec 5, 2018 at 10:40 PM <soumik.bhattacharjee@kpn.com<mailto:soumik.bhattacharjee@kpn.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
^ permalink raw reply [nested|flat] 10+ messages in thread
end of thread, other threads:[~2018-12-06 12:12 UTC | newest]
Thread overview: 10+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-12-05 17:10 DB Creations/ Drop DB :: Not working... soumik.bhattacharjee@kpn.com
2018-12-05 17:29 ` Tom Lane <tgl@sss.pgh.pa.us>
2018-12-05 17:48 ` Ron <ronljohnsonjr@gmail.com>
2018-12-06 10:32 ` soumik.bhattacharjee@kpn.com
2018-12-06 10:41 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
2018-12-06 10:47 ` soumik.bhattacharjee@kpn.com
2018-12-06 10:49 ` soumik.bhattacharjee@kpn.com
2018-12-06 11:14 ` Avinash Kumar <avinash.vallarapu@gmail.com>
2018-12-06 11:35 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
2018-12-06 12:12 ` soumik.bhattacharjee@kpn.com
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox