Обсуждение: PK not being restored
Dear Sir/Madam,
I am using postgresql db server for our production environment. I have created a schema by the name “application”. The public schema is not being used at all. I have noticed that suddenly, the public schema is having some table definition and a whole lot of functions. I have no idea where it came from. For you reference I will list the four tables and a couple of functions that has crept in my database’s public schema.
Tables:
pg_ts_cfg
pg_ts_cfgmap
pg_ts_dict
pg_ts_parser
Functions:
_get_parser_from_curcfg
_int_contained
The above extraneous db objects is interfering with the backup and restore of my application’s database. As a result, when I restore my db, the primary keys are not being restored.
Kindly advise.
Rajdeep
Ontrack Systems Ltd.
Kolkata, India
On Tue, Jun 23, 2009 at 2:11 AM, Rajdeep Das<rajdeep.das@ontrackindia.com> wrote: > Dear Sir/Madam, > > > > I am using postgresql db server for our production environment. I have > created a schema by the name “application”. The public schema is not being > used at all. I have noticed that suddenly, the public schema is having some > table definition and a whole lot of functions. I have no idea where it came > from. For you reference I will list the four tables and a couple of > functions that has crept in my database’s public schema. > > > > Tables: > > pg_ts_cfg > > pg_ts_cfgmap > > pg_ts_dict > > pg_ts_parser > what version postgresql? the 'ts' stands for 'text search'. how are the above tables blocking you from restoring your data? merlin