Creating initial data bases

#1

Quote:

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?

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.

A hell of a way to spend New Years, I suppose, but in time I will enjoy
this project, I am sure.
--

G. Walsh,
DSC Directional Services Corp.,
#507 890 Academy Close,
Victoria, B.C. V8V 2Y1

(250) 386-4498

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

#2

G. Walsh wrote:

Quote:

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.

Quote:

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.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Creating initial data bases

comp.databases.postgresql.novice comp.databases.postgresql.novice

Creating initial data bases - 01-03-2004 , 06:14 AM

Re: Creating initial data bases - 01-03-2004 , 10:44 PM