David,
> thanks for all of the input everyone. I believe you have helped lead
> me to the
> problem. two days ago iI ran out of room on the partition. Postgres
> was
> running at the time, but complaining about the fact that it was out
> of room.
> so in an effort to make more room I foolishly removed what I thought
> was a test
> db. that was where postgres looks for its configuration info. when
> postgres
> died today it wasn't able to find that info for the restart. If it
> wouldn't
> have died for whatever reason today it would never have needed to
> locate those
> files. I guess it's time to reload postgres. Any suggestions aout
> how?
You deleted Template1?
Well, if you have a filesystem backup you can restore it that way. Or,
if you have a database backup, you can re-install postgresql from
scratch, and restore that database from backup.
If you have no backups, then you are DOA.
Just as if you typed "rm -rf /* " with no backups.
-Josh
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh@agliodbs.com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco