Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f3H5Fhu65442 for ; Tue, 17 Apr 2001 01:15:43 -0400 (EDT) (envelope-from pgsql-docs-owner@postgresql.org) Received: from grieg.siteprotect.com (grieg.siteprotect.com [64.26.0.22]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3H1l6u29594 for ; Mon, 16 Apr 2001 21:47:06 -0400 (EDT) (envelope-from Mike@HireLiveMusicians.com) Received: from mikesmachine (cdm-96-90-bent.cox-internet.com [208.180.96.90]) by grieg.siteprotect.com (8.9.3/8.9.3) with SMTP id UAA17893 for ; Mon, 16 Apr 2001 20:47:01 -0500 Reply-To: From: "Mike Marois" To: Subject: Where's the Database? Date: Mon, 16 Apr 2001 20:47:02 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Importance: Normal X-Archive-Number: 200104/58 X-Sequence-Number: 630 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. TIA Mike www.HireLiveMusicians.com www.MaroisApps.com www.TheDukesofDixieland.com