Thread: problems to install PostgreSQL

problems to install PostgreSQL

From
"Paolo De Simone"
Date:
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


Re: problems to install PostgreSQL

From
"sandhya"
Date:
Instead of executing the command from root ...login as postgres user and try
like
su - postgres

----- Original Message -----
From: "Paolo De Simone" <pdesimone@infocall.it>
To: <pgsql-admin@postgresql.org>
Sent: Tuesday, February 21, 2006 5:34 PM
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
>


Re: problems to install PostgreSQL

From
"Anjan Dave"
Date:
Can also use a startup script from the contrib directory of the source.


-----Original Message-----
From: sandhya [mailto:sandhyar@amiindia.co.in]
Sent: Tuesday, February 21, 2006 7:14 AM
To: Paolo De Simone; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] problems to install PostgreSQL

Instead of executing the command from root ...login as postgres user and
try
like
su - postgres

----- Original Message -----
From: "Paolo De Simone" <pdesimone@infocall.it>
To: <pgsql-admin@postgresql.org>
Sent: Tuesday, February 21, 2006 5:34 PM
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
>


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@postgresql.org so that your
       message can get through to the mailing list cleanly


Re: problems to install PostgreSQL

From
"Tomeh, Husam"
Date:
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@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Paolo De Simone
Sent: Tuesday, February 21, 2006 4:05 AM
To: pgsql-admin@postgresql.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
containinformation that is legally privileged.  If you are not the addressee, or the person responsible for delivering
itto the addressee, you are hereby notified that reading, disseminating, distributing or copying this message is
strictlyprohibited.  If you have received this message by mistake, please immediately notify us by replying to the
messageand delete the original message immediately thereafter. 

Thank you.

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