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 intended 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 system.
______________________________________________________________________
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