Schema is Missing

From: "Ron St-Pierre" <ronstp(at)mail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Schema is Missing
Date: 2006-03-10 17:57:17
Message-ID: 20060310175717.46678101DA@ws1-3.us4.outblaze.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We received the following error on our development server this morning (postgresql 7.4.1, debian woody):
org.postgresql.util.PSQLException: ERROR: schema "customer" does not exist
When I login to postgres it looks as if the other schemas are okay, but the customer schema is gone. I have a backup from midnight last night which I can restore, but I want to find out the cause of the problem first.

.psql_history doesn't display anything useful, just some queries that I ran today and yesterday. I looked at /var/log/messages and /var/log/syslog, and there aren't any zipped backups in the directory, which makes me suspicious. The files contents are:
root(at)imperial:/var/log# head messages
Feb 16 10:21:43 ** Starting Arno's IPTABLES firewall v1.8.2 **
Feb 16 10:21:45 ** All firewall rules applied **
Feb 17 10:23:20 ** Starting Arno's IPTABLES firewall v1.8.2 **
Feb 17 10:23:21 ** All firewall rules applied **
Feb 19 9:59:15 ** Starting Arno's IPTABLES firewall v1.8.2 **
Feb 19 9:59:17 ** All firewall rules applied **
Feb 22 9:58:10 ** Starting Arno's IPTABLES firewall v1.8.2 **
Feb 22 9:58:13 ** All firewall rules applied **
Mar 10 06:25:52 imperial syslogd 1.4.1#10: restart.
Mar 10 06:30:13 imperial postgres[6330]: [9-1] ERROR: schema "customer" does not exist
and
root(at)imperial:/var/log# head syslog
Mar 10 06:25:52 imperial syslogd 1.4.1#10: restart.
Mar 10 06:30:13 imperial postgres[6330]: [9-1] ERROR: schema "customer" does not exist
Mar 10 06:36:03 imperial postgres[9058]: [9-1] ERROR: schema "customer" does not exist

Where should I look to see if data corruption was the problem? I am holding off restoring the customer schema for now.

Thanks
Ron St.Pierre

--
___________________________________________________
Play 100s of games for FREE! http://games.mail.com/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2006-03-10 18:27:54 Re: Schema is Missing
Previous Message Emi Lu 2006-03-10 17:55:28 Re: in Pl/PgSQL, do commit every 5000 records