FAQ
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@db /usr/local/pgsql/data/base]$ ls
1 18719 18723
[postgres@db /usr/local/pgsql/data/base]$ cd 18723
[postgres@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@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.

Search Discussions

  • Thomas Lockhart at May 11, 2001 at 1:45 pm

    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: ...
    But when I did a psql -l, I can find the db created.
    I remember in the older postgres version, I can test dir in .../base. But
    not in this version.
    You are correct. The file naming scheme was changed; check the archives
    in -hackers for discussions on how to associate numbers with names.

    - Thomas

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-bugs @
categoriespostgresql
postedMay 11, '01 at 12:21p
activeMay 11, '01 at 1:45p
posts2
users2
websitepostgresql.org
irc#postgresql

2 users in discussion

McCoy Mun: 1 post Thomas Lockhart: 1 post

People

Translate

site design / logo © 2021 Grokbase