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
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 |