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.
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.
Ontrack Systems Ltd.
pgsql-hackers by date
|Next:||From: Rajdeep Das||Date: 2009-06-23 06:11:22|
|Subject: PK not being restored|
|Previous:||From: KaiGai Kohei||Date: 2009-06-23 04:24:19|
|Subject: Re: security checks for largeobjects?|
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2009-06-23 13:29:51|
|Subject: Re: [HACKERS] PK not being restored |
|Previous:||From: Dimitri Fontaine||Date: 2009-06-22 13:18:57|
|Subject: Re: Is IDLE session really idle?|