Projects
New Ticket     Wiki     Browse Source     Timeline     Roadmap     Bug Reports     Search

Ticket #4927 (closed defect: worksforme)

Opened 3 years ago

Last modified 3 years ago

BUG: initdb fails with PostgreSQL 7.4.8

Reported by: james@… Owned by: mww@…
Priority: Normal Milestone:
Component: ports Version: 1.0
Keywords: Cc:
Port:

Description

I get "ERROR: cache lookup failed for type 1033" when trying to initdb with a fresh install of PostgreSQL 7.4.8. I searched google and can't find anyone else having this problem.

Here is a an example shell session:

# mkdir pgsql # mkdir pgsql/data # chown postgres pgsql/data # su - postgres $ /opt/local/bin/initdb -D /opt/local/var/pgsql/data The files belonging to this database system will be owned by user "postgres". This user must also own the server process.

The database cluster will be initialized with locale C.

fixing permissions on existing directory /opt/local/var/pgsql/data... ok creating directory /opt/local/var/pgsql/data/base... ok creating directory /opt/local/var/pgsql/data/global... ok creating directory /opt/local/var/pgsql/data/pg_xlog... ok creating directory /opt/local/var/pgsql/data/pg_clog... ok selecting default max_connections... 50 selecting default shared_buffers... 300 creating configuration files... ok creating template1 database in /opt/local/var/pgsql/data/base/1... ERROR: cache lookup failed for type 1033

initdb: failed

If I turn on debugging, there is over one thousand lines of output, but there are the last few:

DEBUG: inserting column 13 value "2275" DEBUG: Typ == NULL, typeindex = 1 DEBUG: -> 2275 DEBUG: inserted DEBUG: inserting column 14 value "2279" DEBUG: Typ == NULL, typeindex = 18 ERROR: cache lookup failed for type 1033 DEBUG: proc_exit(1) DEBUG: shmem_exit(1) DEBUG: exit(1)

initdb: failed

Change History

Changed 3 years ago by mww@…

  • owner changed from darwinports-bugs@… to mww@…
  • summary changed from initdb fails with PostgreSQL 7.4.8 to BUG: initdb fails with PostgreSQL 7.4.8

Changed 3 years ago by mww@…

  • status changed from new to closed
  • resolution set to worksforme

works just fine with 7.4.9 on OS X 10.4; please re-open if problem still exists!

Note: See TracTickets for help on using tickets.