$PGDATADIR/base 디렉토리를 살펴보면 아래와 같은 숫자들이 보입니다. 이게 뭘 의미하는 것일까요?
[postgres@pg-00:/var/lib/pgsql/9.2/data/base]$ ls -l
total 44
drwx------ 2 postgres postgres 12288 Dec 28 13:30 1/
drwx------ 2 postgres postgres 4096 Dec 28 13:29 12865/
drwx------ 2 postgres postgres 4096 Jun 22 15:22 12870/
drwx------ 2 postgres postgres 12288 Jun 22 15:12 16547/
drwx------ 2 postgres postgres 12288 Jan 4 14:10 16548/
[postgres@pg-00:/var/lib/pgsql/9.2/data/base]$
이제 뭔지 까봅시다.
postgres@[local]:5432:postgres]
SQL> select datname, oid from pg_database order by oid;
datname | oid
-----------+-------
template1 | 1
template0 | 12865
postgres | 12870
scottdb | 16547
ds2 | 16548
(5 rows)
감이 오시나요?
