Re: problems to install PostgreSQL

From: "Tomeh, Husam" <htomeh(at)firstam(dot)com>
To: "Paolo De Simone" <pdesimone(at)infocall(dot)it>, pgsql-admin(at)postgresql(dot)org
Subject: Re: problems to install PostgreSQL
Date: 2006-02-23 20:30:25
Message-ID: CB0FB369FF86E248A884BCC002562BCB010C0B5C@pisgsna01sxch01.ana.firstamdata.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Make sure that you initdb the postgresql cluster as the user "postgres"
not as "root".
So, after configuring, compiling, and installing the source, switch user
to "postgres" and run your initdb command.

----

Husam

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Paolo De Simone
Sent: Tuesday, February 21, 2006 4:05 AM
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] problems to install PostgreSQL

Hello all,

i'm trying to install postgresql 8.1.3
on AIX 5.2 RISC 6000

the steps
- ./configure
- gmake
- gmake install

are OK

so i created /usr/local/pgsql/data
but when ran
- initdb -D /usr/local/pgsql/data

had the following result :

"
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 en_US.
The default database encoding has accordingly been set to LATIN1.

fixing permissions on existing directory /usr/local/pgsql/data ... ok
creating directory /usr/local/pgsql/data/global ... ok
creating directory /usr/local/pgsql/data/pg_xlog ... ok
creating directory /usr/local/pgsql/data/pg_xlog/archive_status ... ok
creating directory /usr/local/pgsql/data/pg_clog ... ok
creating directory /usr/local/pgsql/data/pg_subtrans ... ok
creating directory /usr/local/pgsql/data/pg_twophase ... ok
creating directory /usr/local/pgsql/data/pg_multixact/members ... ok
creating directory /usr/local/pgsql/data/pg_multixact/offsets ... ok
creating directory /usr/local/pgsql/data/base ... ok
creating directory /usr/local/pgsql/data/base/1 ... ok
creating directory /usr/local/pgsql/data/pg_tblspc ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 50
creating configuration files ... ok
creating template1 database in /usr/local/pgsql/data/base/1 ... child
process was terminated by signal 11
initdb: removing contents of data directory "/usr/local/pgsql/data"
"

I have repeated the installation steps for
8.1.0, 8.1.1, 8.1.2 versions
but I obtained the same result

Many thanx to any that can help.

Greetings
paolo

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
**********************************************************************
This message contains confidential information intended only for the use of the addressee(s) named above and may contain information that is legally privileged. If you are not the addressee, or the person responsible for delivering it to the addressee, you are hereby notified that reading, disseminating, distributing or copying this message is strictly prohibited. If you have received this message by mistake, please immediately notify us by replying to the message and delete the original message immediately thereafter.

Thank you.

FADLD Tag
**********************************************************************

Browse pgsql-admin by date

  From Date Subject
Next Message Milen A. Radev 2006-02-23 20:43:08 Re: PGPASSWORD
Previous Message Sunanda Kumaraguru 2006-02-23 19:48:54 ERROR: Cannot determine geometry type (empty table).