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

[Gerald Waugh <gwaugh@xxxxxxxxxxxxxxxxxxxxxxx>]

On Sat, 13 Sep 2003, Bruce Timberlake wrote:

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


On a RaQ3, IIRC its /home/pgsql


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

sometime ago a user posted a procedure where he deleted the data files and
the system rebuilt postgres, not sure this works, but regardles, save the
pgsql directory.

Gerald
--
http://frontstreetnetworks.com | http://store.raqware.com
  Front Street Networks LLC, 229 Front Street, Ste.#C
  New Haven, CT 06513-3203 | phone: +1-203-785-0699