[cobalt-users] Re: Need fix for raq3 PostgreSQL - "backend closedthe channel unexpectedly"

[Bruce Timberlake <bruce@xxxxxxxxxx>]

> > Regardless of what the database program is doing can you not back up the
> > data files, then get the database application restored to working then
> > put the data files back?
> > If it's the Postgresql that is broken it could be the data is in fact
> > intact and reusable.
>
> That sounds like a good idea. Where are the Postgresql data files stored?

Usually in /var/lib/pgsql/data/base/cobalt/.  You really only need to save the 
files that don't start with pg_. Also save /var/lib/pgsql/data/pg_hba.conf.

> I take it I can just copy the data files to another directory, and then copy
> them back after I've re-installed PostgreSQL?

Yes, I believe so.  There's someplace where you tell PostgreSQL what databases 
it "knows" about; I can't recall what/where that is though.