Skip site navigation (1) Skip section navigation (2)

PK not being restored

From: Rajdeep Das <sendrajster(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: PK not being restored
Date: 2009-06-23 06:05:02
Message-ID: 66ab29920906222305g5f6791ffg2a5d2cec601de4f7@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-hackers
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

Responses

pgsql-hackers by date

Next:From: Rajdeep DasDate: 2009-06-23 06:11:22
Subject: PK not being restored
Previous:From: KaiGai KoheiDate: 2009-06-23 04:24:19
Subject: Re: security checks for largeobjects?

pgsql-admin by date

Next:From: Tom LaneDate: 2009-06-23 13:29:51
Subject: Re: [HACKERS] PK not being restored
Previous:From: Dimitri FontaineDate: 2009-06-22 13:18:57
Subject: Re: Is IDLE session really idle?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group