drop view seems to have made database unusable . . help!

From: Martin Weinberg <weinberg(at)osprey(dot)astro(dot)umass(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Cc: weinberg(at)osprey(dot)astro(dot)umass(dot)edu
Subject: drop view seems to have made database unusable . . help!
Date: 1999-10-29 21:50:21
Message-ID: 199910292250.SAA24626@osprey.astro.umass.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Help!

I attempted to create a view like

create view pscscan as select * from psc, scandat where . . .;

which failed with a message about duplicate entries. I tried
another with

create view pscscan2 as select j_m, j_pts_noise from psc, scandat where . . .;

which worked.

I then tried to drop them both and the backend crashed
I tried to vacuum and the vacuum crashed. Now I can not
connect to the database at all (I deleted the lock file)
Now, postgres seems to create an empty file
"pg_internal.init" and crash when I try to connect.

What happened? Is there any way to save this? I have nearly
100GB in this database . . . sigh.

--Martin

===========================================================================

Martin Weinberg Phone: (413) 545-3821
Dept. of Physics and Astronomy FAX: (413) 545-2117/0648
530 Graduate Research Tower
University of Massachusetts
Amherst, MA 01003-4525

Browse pgsql-general by date

  From Date Subject
Next Message Bill Meahan 1999-10-29 22:57:33 Re: [GENERAL] Studying
Previous Message Darvin Zuch 1999-10-29 20:26:59 Advice on Transfering functions from MS-MSSQL Server