Thread: Postgresql installation on P2020 board
Hi, im trying to install postgresql8.4 in P2020 board . when i try to start postgresql im facing the follwing error. [postgres@p2020ds /]$ initdb -D /usr/local/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. The default database encoding has accordingly been set to SQL_ASCII. The default text search configuration will be set to "english". fixing permissions on existing directory /usr/local/data ... ok creating subdirectories ... ok selecting default max_connections ... 100 selecting default shared_buffers ... 28MB creating configuration files ... ok creating template1 database in /usr/local/data/base/1 ... FATAL: only sys = attr supported in caches is OID PANIC: cannot abort transaction 1, it was already committed child process was terminated by signal 6: Aborted initdb: removing contents of data directory "/usr/local/data" Please help me to solve this problem. Thanks&Regards Tamilselvam.M Software Engineer Product Engineering Services L&T Infotech ,Chennai - 600 089 ------------------------------------------------------------------- Tel:044-22535789 ;Extn:5789 ;Mob:9884671873 Mail - Tamilselvam.M@lntinfotech.com ________________________________ This Email may contain confidential or privileged information for the inten= ded recipient (s) If you are not the intended recipient, please do not use = or disseminate the information, notify the sender and delete it from your s= ystem. ______________________________________________________________________=
TamilSelvam M <Tamilselvam.M@lntinfotech.com> writes: > im trying to install postgresql8.4 in P2020 board . > when i try to start postgresql im facing the follwing error. > creating template1 database in /usr/local/data/base/1 ... FATAL: only sys attr supported in caches is OID Offhand I'd guess you have a compiler bug to deal with. As a short-term workaround, you might be able to avoid it by reducing the optimization level you compile Postgres with. regards, tom lane
Excerpts from TamilSelvam M's message of jue sep 23 02:08:05 -0400 2010: > creating template1 database in /usr/local/data/base/1 ... FATAL: only sys attr supported in caches is OID > PANIC: cannot abort transaction 1, it was already committed > child process was terminated by signal 6: Aborted > initdb: removing contents of data directory "/usr/local/data" What kind of operating system is it running? One would think that if it's like a regular *nix, it shouldn't emit this kind of error. Maybe it's a compiler bug of some sort. I think you need to trace the boostrapping process to see what's it trying to do. -- Ãlvaro Herrera <alvherre@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support