Re: database design ...

It depends how you plan to use it?

Maybe a helpful excercise for you to go through is to come up with some
use cases and see if you are storing all the data you'll need in a way
that makes it easy for you to use.

On Tue, 14 Nov 2006, Desmond Coughlan wrote:

> X-No-Archive: true
>
> Hi,
> Thanks for all the help: we have our postgreSQL server on a 'backend' machine, and the client on a webserver.
>
> The application I want to develop is a school library, and as this is new to me, I come looking for ideas. Here's what I've done: on the backend, two users (in addition to 'pgsql'): dba and 'cdi' (the name of the library, as in the _premises_ where the library is located). I create a database 'library', owned by dba, but with cdi having update privileges (but not 'drop table' etc).
>
> 'library' has four tables...
>
> 1. users (with user_ids, surname, first_name, dob, address etc...)
> 2. stock (stock_id, ISBN, title...)
> 3. loans (loan_id, stock_id [foreign key to stock_id], date_due)...
>
> Is there anything else that such a db would need ?
>
> Thanks.
>
> D.
>
>
> ---------------------------------
> Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses.
>From pgsql-general-owner(at)postgresql(dot)org Tue Nov 14 15:12:50 2006
Received: from localhost (mx1.hub.org [200.46.208.251])
by postgresql.org (Postfix) with ESMTP id 685729FB288
for <pgsql-general-postgresql(dot)org(at)postgresql(dot)org>; Tue, 14 Nov 2006 15:12:50 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
with ESMTP id 66045-05 for <pgsql-general-postgresql(dot)org(at)postgresql(dot)org>;
Tue, 14 Nov 2006 15:12:42 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from servata.com (ip-216-152-249-241.servata.com [216.152.249.241])
by postgresql.org (Postfix) with ESMTP id A2D7C9FA6B5
for <pgsql-general(at)postgresql(dot)org>; Tue, 14 Nov 2006 15:12:42 -0400 (AST)
Received: from [209.162.219.253] (helo=dogma.v10.wvs)
by servata.com with esmtpa (Exim 4.50)
id 1Gk3i2-00008J-B3; Tue, 14 Nov 2006 11:12:38 -0800
Subject: Re: Data corruption
From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Ardian Xharra <axharra(at)boxxo(dot)info>
Cc: postgreSQL postgreSQL <pgsql-general(at)postgresql(dot)org>
In-Reply-To: <054a01c7081b$84f7f3d0$0f01a8c0(at)Boxxo>
References: <054a01c7081b$84f7f3d0$0f01a8c0(at)Boxxo>
Content-Type: text/plain
Date: Tue, 14 Nov 2006 11:12:35 -0800
Message-Id: <1163531555(dot)12372(dot)80(dot)camel(at)dogma(dot)v10(dot)wvs>
Mime-Version: 1.0
X-Mailer: Evolution 2.0.4 (2.0.4-7)
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200611/853
X-Sequence-Number: 103949

On Tue, 2006-11-14 at 13:34 -0500, Ardian Xharra wrote:
> Hi all,
>
> We have a database installed on Intel Xeon (Dell) and running on
> postgreSQL 8.1.
> And the database couldn't start. Here is the logfile of what happend:
>
> 2006-11-14 00:28:38 PANIC: could not write to log file 6, segment 239
> at offset 6430720, length 16384: Permission denied
>

Are you running PostgreSQL as a user other than the one that owns the
data directory? Did the filesystem somehow get mounted in RO mode?

Regards,
Jeff Davis