Re: Where's the Database?

On Mon, Apr 16, 2001 at 08:51:28PM -0500, Big Bad Data Daddy wrote:
> Hey List;
>
> I've been really getting into PostgreSQL attempting to rewrite my current
> website ( www.HireLiveMusicians.com ) with a DB backend.  The site is
> working on flat text files currently.  My question is for archiving/backing
> up  and just general knowledge, where are my databases being stored by
> default.  I've been creating the database logged on a specific user not
> root.  I'm just curious, I know that I'm supposed to write scripts to create
> the tables, triggers, indexes, etc and then import my exported data back
> into the tables if something runs amiss.

    Oliver already answered the first question. If you are using RPMs or
DEBs to install Postgres, your databases should be in
/var/lib/postgresql/data
    It's a very good idea to read tho scetion on Backups on the
Administrator's Guide.

    -Roberto
--
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+
  Roberto Mello - Computer Science, USU - http://www.brasileiro.net
       http://www.sdl.usu.edu - Space Dynamics Lab, Developer
Beam me aboard, Scotty! How about A 2x4, sir??