Postgresql 7.1.2 - Mailing list pgsql-general

Howdy- saw your e-mail in the postgresql install file, hope you don't
mind me writing.

Postgresql compiles and runs fine- but the database directories are
named by numbers, not by names- which ain't how it is on my linux boxes
(nor how its described in the pgsql doc)

my posgres user has its home directory set at
/private/var/database/postgres
data dir is ~/data

osx% ls -al data/base/
total 6
drwx------   4 postgres postgres     1024 Jun  8 23:09 .
drwx------   5 postgres postgres     1024 Jun  8 23:09 ..
drwx------   2 postgres postgres     2048 Jun  8 23:09 1
drwx------   2 postgres postgres     2048 Jun  8 23:09 18719
osx%

That 1 should be a template1

the contents of that directory 1 are also screwed up-

osx% ls -al data/base/1/ |tail -10
-rw-------   1 postgres postgres     8192 Jun  8 23:09 17228
-rw-------   1 postgres postgres        0 Jun  8 23:09 17231
-rw-------   1 postgres postgres     8192 Jun  8 23:09 17243
-rw-------   1 postgres postgres        0 Jun  8 23:09 17246
-rw-------   1 postgres postgres     8192 Jun  8 23:09 17258
-rw-------   1 postgres postgres        0 Jun  8 23:09 17261
-rw-------   1 postgres postgres     8192 Jun  8 23:09 17273
-rw-------   1 postgres postgres     8192 Jun  8 23:09 17276
-rw-------   1 postgres postgres    16384 Jun  8 23:09 17288
-rw-------   1 postgres postgres        4 Jun  8 23:09 PG_VERSION
osx%

from my linux box-
[root@athlon /root]# ls -al /var/lib/pgsql/data/base/template1/ |tail -10
-rw-------    1 postgres postgres        0 Jan  5 03:32 pg_tables
-rw-------    1 postgres postgres     8192 Jan  5 03:32 pg_trigger
-rw-------    1 postgres postgres    16384 Jan  5 03:32
pg_trigger_tgconstrname_index
-rw-------    1 postgres postgres    16384 Jan  5 03:32
pg_trigger_tgconstrrelid_index
-rw-------    1 postgres postgres    16384 Jan  5 03:32
pg_trigger_tgrelid_index
-rw-------    1 postgres postgres    16384 Jan  5 03:32 pg_type
-rw-------    1 postgres postgres    16384 Jan  5 03:32 pg_type_oid_index
-rw-------    1 postgres postgres    16384 Jan  5 03:32
pg_type_typname_index
-rw-------    1 postgres postgres        0 Jan  5 03:32 pg_user
-rw-------    1 postgres postgres        0 Jan  5 03:32 pg_views
[root@athlon /root]#

I can create a test databse and connect no problem- everything seems to
work- but something is obviously not quite right... have any clue as to
what is going on?

-=-
./configure --prefix=/usr/local \
--sysconfdir=/private/etc \
--with-openssl=/usr/local \
--with-CXX \
--with-odbc \
--enable-syslog \
--disable-shared

path for building is /usr/bin:/bin:/usr/sbin:/sbin
I don't have any non apple utilities installed in those directories
(except for newer sudo with the buffer overflow fix).

The openssl I'm building against is 0.9.6a built statically from
openssl.org but I really don't think that's the issue.

Have any idea what's going on? I haven't tried building from CVS yet (my
experience has been cvs builds tend to be more problematic on Darwin
than, say, Linux...)

OS X Release Candidate that was sent to ADC members, updated to 10.0.3
Beige G3 (333MHz/256) UFS install.

Thanks for any suggestions...

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Michael A. Peters
http://24.5.29/77/OSX-Darwin/