Обсуждение: 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
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 >
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
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
**********************************************************************