I have following script, which initialize two clusters: echo CREATE ROLE new_user WITH LOGIN;>init_cluster.sql echo CREATE DATABASE new_database WITH OWNER = new_user;>>init_cluster.sql initdb -D case1 -U postgres pg_ctl start -D case1 -w psql "host=localhost dbname=postgres user=postgres"<init_cluster.sql pg_ctl stop -D case1 -m smart -w initdb -D case2 -U postgres postgres --single -D case2 postgres<init_cluster.sql
In case1 I have following oid assigned: new_user: 16384 new_database: 16385 In case2: new_user: 15062 new_database: 15063 And pgAdmin does not show new_database in the server tree. Documentation says following: >OIDs assigned during normal database operation are constrained to be 16384 or >higher. This ensures that the range 10000—16383 is free for OIDs assigned >automatically by genbki.pl or during initdb. Is such difference in oid assignment in Single-User Mode expected?
