createdb test shown as number in data directory

From: "McCoy Mun" <mccoymun(at)hotmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: createdb test shown as number in data directory
Date: 2001-05-10 09:33:54
Message-ID: F1284Ogddu5qE8DzHx600002184@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi

I'm using postgres 7.1.1 version tar format. I've compiled and installed
with the default option

1) ./configure
2) make
3) make install
4) create a data dir with postgres user permission
in /usr/local/pgsql/data
5) initdb -D /usr/local/pgsql/data
- NO ERROR encounter.
6) start postmaster
7) createdb test

ALL THE ABOVE HAS NO ERROR. However, when I look in
/usr/local/pgsql/data/base, all the directories created is in number format
as shown:

[postgres(at)db /usr/local/pgsql/data/base]$ ls
1 18719 18723
[postgres(at)db /usr/local/pgsql/data/base]$ cd 18723
[postgres(at)db /usr/local/pgsql/data/base/18723]$ ls
1215 16567 16867 17074 17112 17139 17160 17181 17213 17261
1216 16579 16934 17086 17115 17142 17163 17184 17216 17273
1219 16600 16948 17097 17118 17145 17166 17187 17228 17276
1247 16617 16960 17100 17121 17148 17169 17190 17231 17288
1249 16642 17033 17103 17124 17151 17172 17193 17243 PG_VERSION
1255 16653 17045 17106 17133 17154 17175 17196 17246
pg_internal.init
1259 16685 17058 17109 17136 17157 17178 17201 17258

But when I did a psql -l, I can find the db created.
[postgres(at)db /usr/local/pgsql/data/base/18723]$ psql -l
List of databases
Database | Owner
-----------+----------
template0 | postgres
template1 | postgres
test | postgres
(3 rows)

I remember in the older postgres version, I can test dir in .../base. But
not in this version.

Pls advise.
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Fariba Noorbakhsh 2001-05-10 12:31:35 instalation problems!
Previous Message Christian Breimann 2001-05-10 08:25:10 exists <==> not exists ???