| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-06-23 13:29:51 | Re: [HACKERS] PK not being restored |
| Previous Message | Dimitri Fontaine | 2009-06-22 13:18:57 | Re: Is IDLE session really idle? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rajdeep Das | 2009-06-23 06:11:22 | PK not being restored |
| Previous Message | KaiGai Kohei | 2009-06-23 04:24:19 | Re: security checks for largeobjects? |