Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group