From: Roberto Mello <rmello@cc.usu.edu>
To: Big Bad Data Daddy <B2D2@MaroisApps.com>
Cc: pgsql-docs@postgresql.org
Subject: Re: Where's the Database?
Date: Tue, 17 Apr 2001 10:32:56 -0600
Message-ID: <20010417103256.A31792@cc.usu.edu> (raw)
In-Reply-To: <NFBBJHOJALKEPLAFGLCHIECLCCAA.B2D2@MaroisApps.com>
References: <NFBBJHOJALKEPLAFGLCHIECLCCAA.B2D2@MaroisApps.com>
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.nethttp://www.sdl.usu.edu - Space Dynamics Lab, Developer
Beam me aboard, Scotty! How about A 2x4, sir??
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: rmello@cc.usu.edu, B2D2@MaroisApps.com
Subject: Re: Where's the Database?
In-Reply-To: <20010417103256.A31792@cc.usu.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox