Received: from fslc.ser.usu.edu (fslc.ser.usu.edu [129.123.28.122]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3HGX1u71072 for ; Tue, 17 Apr 2001 12:33:01 -0400 (EDT) (envelope-from rmello@fslc.usu.edu) Received: (from rmello@localhost) by fslc.ser.usu.edu (8.12.0.Beta5/8.12.0.Beta5/Debian 8.12.0-1) id f3HGWuSk031867; Tue, 17 Apr 2001 10:32:56 -0600 Date: Tue, 17 Apr 2001 10:32:56 -0600 From: Roberto Mello To: Big Bad Data Daddy Cc: pgsql-docs@postgresql.org Subject: Re: Where's the Database? Message-ID: <20010417103256.A31792@cc.usu.edu> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.3.17i In-Reply-To: ; from B2D2@MaroisApps.com on Mon, Apr 16, 2001 at 08:51:28PM -0500 X-Archive-Number: 200104/60 X-Sequence-Number: 632 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??