From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | "G(dot) Walsh" <gwalsh(at)dscdirectionalservices(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Creating initial data bases |
Date: | 2004-01-04 04:44:16 |
Message-ID: | 200401040444.i044iGV05323@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
G. Walsh wrote:
> > I am converting 4 sites from C-ISAM (btree) to PostgreSQL which
> > necessitates pretty well a full re-development.
> >
> > I am using Mandrake 9.2 + cooker so my current release level is 7.4-2.
> >
> > /var/lib/pgsql/data is present and would appear to have the
> > directories/files that my 2 texts on the subject mention should be
> > present.
> >
> > I began by wanting to create a simple data base. psql -l reports it but
> > the Linux <find> cannot locate it. I can remove it with dropdb, too, so
> > the table must be somewhere? Or is this because there is as yet nothing
> > in the table?
All databases exist under a single /data directory, but the files are
named by object id. See the "Managing Disk Space" section of the
manual.
> > What I planned on doing was establishing 4 separate file systems, one
> > for each of the 'divisions' or web sites. I have tried using createdb
> > with the -D but it fails because absolute paths are not permitted??
> >
> > Finally, who should own what? Presently all the development directories
> > are owned by a single development user. May that user own the postgres
> > files or does the postgres user itself have to own them? If the latter
> > is the case, then permissions would seem to be a problem.
> >
> > I'd feel a whole lot better if I could 'see' these tables (files) before
> > I begin to develop strategy for defining and transferring the existing
> > data. Rather anal retentive, but there it is - I like to see what I am
> > working with.
Files are all owned by the super-user postgres or the install user.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2004-01-04 04:45:17 | Re: More on creating data bases for 4 distinct users |
Previous Message | Andreas | 2004-01-03 18:39:28 | Re: Question about Indexes... |