Re: by mistake dropped physical file dropped for one table.

Ok, thanks. On Mar 6, 2018 6:51 PM, "Stephen Frost" wrote: > Greetings, > > * Rambabu V (ram.wis...@gmail.com) wrote: > > by mistake one physical file dropped for one of our table, as we do-not > > have backup for this table we are getting below error. > > > > ERROR: could not open file "base/1

Re: need meta data table/command to find query log

Greetings, These questions are not appropriate for the 'performance' mailing list but should be either on 'admin' or 'general'. Please use the appropriate list for asking questions in the future. * Rambabu V (ram.wis...@gmail.com) wrote: > Please help us to get the query log details from meta da

Re: by mistake dropped physical file dropped for one table.

Greetings, * Rambabu V (ram.wis...@gmail.com) wrote: > by mistake one physical file dropped for one of our table, as we do-not > have backup for this table we are getting below error. > > ERROR: could not open file "base/12669/16394": No such file or directory > > please help us to recover the

Re: Please help

Can you please use separate threads for your questions? That is, don't start new thread by responding to an existing message (because the new message then points using "References" header, which is what e-mail clients use to group messages into threads). And use a proper subject describing the issu

need meta data table/command to find query log

Hi Team, Please help us to get the query log details from meta data table/command in postgresql. aw we are not maintaining log files more than 2 days due to lack of space. And also please provide document or sop for database upgrade from 9.3 to 9.6, as our database size was 4.5 tb and having tab

by mistake dropped physical file dropped for one table.

Hi Team, by mistake one physical file dropped for one of our table, as we do-not have backup for this table we are getting below error. ERROR: could not open file "base/12669/16394": No such file or directory please help us to recover the table. Regards, Rambabu Vakada, PostgreSQL DBA.

Re: GIST index (polygon, point)

ghiureai wrote: > I have a short description bellow from Dev team regarding the behaviour of > gist index on the polygon column, looking to get some feedback from you: > > " I was expecting the <@(point,polygon) and @>(polygon,point) to be > indexable but they are not. see bellow query outp

Please help

Dear Experts, Kndly help to resolve the issue reported during startup pgadmin4 server mode on ubuntu 16.04 dram@vipgadmin:~$ cd .pgadmin4 dram@vipgadmin:~/.pgadmin4$ chmod +x lib/python2.7/site-packages/pgadmin4/pgAdmin4.py dram@vipgadmin:~/.pgadmin4$ chmod lib/python2.7/site-packages/pg