Обсуждение: Problems when initdb on AIX 5.3

Поиск
Список
Период
Сортировка

Problems when initdb on AIX 5.3

От
Francesco Vecchio
Дата:

Hi,

I have a problem with the command:

# initdb -D /geasql/data

which after displaying:

selecting default max_connections …

it stops and does not proceed.

I tried on another server and the problem is the same.

The ps command list initdb followed by the following process:

/opt/freeware/bin/postgres --boot -x0 -F -c max_connections=100 -c shared_buffers=1000

The following lines are the output of the initdb command:

$ initdb –-debug -D /geasql/data. . . .

The files belonging to this database system will be owned by user "postgres".

This user must also own the server process.

VERSION=9.3.5

PGDATA=/geasql/data

share_path=/opt/freeware/share/postgresql

PGPATH=/opt/freeware/bin

POSTGRES_SUPERUSERNAME=postgres

POSTGRES_BKI=/opt/freeware/share/postgresql/postgres.bki

POSTGRES_DESCR=/opt/freeware/share/postgresql/postgres.description

POSTGRES_SHDESCR=/opt/freeware/share/postgresql/postgres.shdescription

POSTGRESQL_CONF_SAMPLE=/opt/freeware/share/postgresql/postgresql.conf.sample

PG_HBA_SAMPLE=/opt/freeware/share/postgresql/pg_hba.conf.sample

PG_IDENT_SAMPLE=/opt/freeware/share/postgresql/pg_ident.conf.sample

The database cluster will be initialized with locale "en_US".

The default database encoding has accordingly been set to "LATIN1".

The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory /geasql/data ... ok

creating subdirectories ... ok

selecting default max_connections ...


******

Il server è IBM

System Model: 7029-6E3

Processor Type: PowerPC_POWER4

CPU Type: 64-bit

Kernel Type: 32-bit

Memory Size: 2048 MB

S.O. AIX 5.2

Postgresql and dependences I downloaded from the site www.oss4aix.org strictly respecting the deps of the site.

# ls

bash-4.3-5.aix5.1.ppc.rpm

db4-4.7.25-2.aix5.1.ppc.rpm

gdbm-1.10-1.aix5.1.ppc.rpm

gettext-0.10.40-8.aix5.2.ppc.rpm

info-5.1-2.aix5.1.ppc.rpm

krb5-libs-1.9.4-1.aix5.1.ppc.rpm

libgcc-4.6.3-2.aix5.2.ppc.rpm

libgcrypt-1.5.3-1.aix5.1.ppc.rpm

libgpg-error-1.12-1.aix5.1.ppc.rpm

libiconv-1.14-2.aix5.1.ppc.rpm

libxml2-2.9.1-1.aix5.1.ppc.rpm

libxslt-1.1.28-2.aix5.1.ppc.rpm

openldap-2.4.23-0.3.aix5.1.ppc.rpm

openssl-1.0.1i-1.aix5.1.ppc.rpm

perl-5.8.8-2.aix5.1.ppc.rpm

postgresql-9.3.5-1.aix5.2.ppc.rpm

postgresql-contrib-9.3.5-1.aix5.2.ppc.rpm

postgresql-docs-9.3.5-1.aix5.2.ppc.rpm

postgresql-libs-9.3.5-1.aix5.2.ppc.rpm

postgresql-server-9.3.5-1.aix5.2.ppc.rpm

readline-6.3-5.aix5.1.ppc.rpm

xz-libs-5.0.5-1.aix5.1.ppc.rpm

zlib-1.2.3-4.aix5.2.ppc.rpm

The installation did not report any anomaly!

# rpm -Uhv *.rpm

bash ##################################################

db4 ##################################################

gdbm ##################################################

gettext ##################################################

warning: /opt/freeware/info/dir created as /opt/freeware/info/dir.rpmnew

info ##################################################

Please check that /etc/info-dir does exist.

You might have to rename it from /etc/info-dir.rpmsave to /etc/info-dir.

krb5-libs ##################################################

libgcc ##################################################

libgcrypt ##################################################

libgpg-error ##################################################

libiconv ##################################################

libxml2 ##################################################

libxslt ##################################################

openldap ##################################################

openssl ##################################################

perl ##################################################

postgresql ##################################################

postgresql-contrib ##################################################

postgresql-docs ##################################################

postgresql-libs ##################################################

postgresql-server ##################################################

readline ##################################################

xz-libs ##################################################

zlib ##################################################

******

Can you help me understand the problem?

Regards

Francesco

Re: Problems when initdb on AIX 5.3

От
Laurenz Albe
Дата:
Francesco Vecchio wrote:
> I have a problem with the command:
>
> # initdb -D /geasql/data
>
> which after displaying:
> selecting default max_connections …
> it stops and does not proceed.
>
> I tried on another server and the problem is the same.
> The ps command list initdb followed by the following process:
>
> /opt/freeware/bin/postgres --boot -x0 -F -c max_connections=100 -c shared_buffers=1000
>
> The following lines are the output of the initdb command:
>
> $ initdb –-debug -D /geasql/data. . . .
> The files belonging to this database system will be owned by user "postgres".
> This user must also own the server process.
> VERSION=9.3.5
> PGDATA=/geasql/data
> share_path=/opt/freeware/share/postgresql
> PGPATH=/opt/freeware/bin
> POSTGRES_SUPERUSERNAME=postgres
> POSTGRES_BKI=/opt/freeware/share/postgresql/postgres.bki
> POSTGRES_DESCR=/opt/freeware/share/postgresql/postgres.description
> POSTGRES_SHDESCR=/opt/freeware/share/postgresql/postgres.shdescription
> POSTGRESQL_CONF_SAMPLE=/opt/freeware/share/postgresql/postgresql.conf.sample
> PG_HBA_SAMPLE=/opt/freeware/share/postgresql/pg_hba.conf.sample
> PG_IDENT_SAMPLE=/opt/freeware/share/postgresql/pg_ident.conf.sample
> The database cluster will be initialized with locale "en_US".
> The default database encoding has accordingly been set to "LATIN1".
> The default text search configuration will be set to "english".
> Data page checksums are disabled.
> fixing permissions on existing directory /geasql/data ... ok
> creating subdirectories ... ok
> selecting default max_connections ...
> 
> ******
> Il server è IBM
> System Model: 7029-6E3
> Processor Type: PowerPC_POWER4
> CPU Type: 64-bit
> Kernel Type: 32-bit
> Memory Size: 2048 MB
> S.O. AIX 5.2
> Postgresql and dependences I downloaded from the site www.oss4aix.org strictly respecting the deps of the site.

You could use "truss" on or attach a debugger to the hanging "postgres"
process to see what it is doing.

You should *not* be using PostgreSQL 9.3.5.
Retry with 9.3.24 so you have all known bugs fixed.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com

Re: Problems when initdb on AIX 5.3

От
Francesco Vecchio
Дата:
The server and AIX are obsolete but it does not depend on me updating the hardware and software.
I find myself working badly, I am aware of it, but I cannot change things.

Thank you for your help. I will try to come up with something.

Cordially

Francesco Vecchio

Il giorno mar 18 set 2018 alle ore 13:08 Francesco Vecchio <franco.vecchio@gmail.com> ha scritto:

Hi,

I have a problem with the command:

# initdb -D /geasql/data

which after displaying:

selecting default max_connections …

it stops and does not proceed.

I tried on another server and the problem is the same.

The ps command list initdb followed by the following process:

/opt/freeware/bin/postgres --boot -x0 -F -c max_connections=100 -c shared_buffers=1000

The following lines are the output of the initdb command:

$ initdb –-debug -D /geasql/data. . . .

The files belonging to this database system will be owned by user "postgres".

This user must also own the server process.

VERSION=9.3.5

PGDATA=/geasql/data

share_path=/opt/freeware/share/postgresql

PGPATH=/opt/freeware/bin

POSTGRES_SUPERUSERNAME=postgres

POSTGRES_BKI=/opt/freeware/share/postgresql/postgres.bki

POSTGRES_DESCR=/opt/freeware/share/postgresql/postgres.description

POSTGRES_SHDESCR=/opt/freeware/share/postgresql/postgres.shdescription

POSTGRESQL_CONF_SAMPLE=/opt/freeware/share/postgresql/postgresql.conf.sample

PG_HBA_SAMPLE=/opt/freeware/share/postgresql/pg_hba.conf.sample

PG_IDENT_SAMPLE=/opt/freeware/share/postgresql/pg_ident.conf.sample

The database cluster will be initialized with locale "en_US".

The default database encoding has accordingly been set to "LATIN1".

The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory /geasql/data ... ok

creating subdirectories ... ok

selecting default max_connections ...


******

Il server è IBM

System Model: 7029-6E3

Processor Type: PowerPC_POWER4

CPU Type: 64-bit

Kernel Type: 32-bit

Memory Size: 2048 MB

S.O. AIX 5.2

Postgresql and dependences I downloaded from the site www.oss4aix.org strictly respecting the deps of the site.

# ls

bash-4.3-5.aix5.1.ppc.rpm

db4-4.7.25-2.aix5.1.ppc.rpm

gdbm-1.10-1.aix5.1.ppc.rpm

gettext-0.10.40-8.aix5.2.ppc.rpm

info-5.1-2.aix5.1.ppc.rpm

krb5-libs-1.9.4-1.aix5.1.ppc.rpm

libgcc-4.6.3-2.aix5.2.ppc.rpm

libgcrypt-1.5.3-1.aix5.1.ppc.rpm

libgpg-error-1.12-1.aix5.1.ppc.rpm

libiconv-1.14-2.aix5.1.ppc.rpm

libxml2-2.9.1-1.aix5.1.ppc.rpm

libxslt-1.1.28-2.aix5.1.ppc.rpm

openldap-2.4.23-0.3.aix5.1.ppc.rpm

openssl-1.0.1i-1.aix5.1.ppc.rpm

perl-5.8.8-2.aix5.1.ppc.rpm

postgresql-9.3.5-1.aix5.2.ppc.rpm

postgresql-contrib-9.3.5-1.aix5.2.ppc.rpm

postgresql-docs-9.3.5-1.aix5.2.ppc.rpm

postgresql-libs-9.3.5-1.aix5.2.ppc.rpm

postgresql-server-9.3.5-1.aix5.2.ppc.rpm

readline-6.3-5.aix5.1.ppc.rpm

xz-libs-5.0.5-1.aix5.1.ppc.rpm

zlib-1.2.3-4.aix5.2.ppc.rpm

The installation did not report any anomaly!

# rpm -Uhv *.rpm

bash ##################################################

db4 ##################################################

gdbm ##################################################

gettext ##################################################

warning: /opt/freeware/info/dir created as /opt/freeware/info/dir.rpmnew

info ##################################################

Please check that /etc/info-dir does exist.

You might have to rename it from /etc/info-dir.rpmsave to /etc/info-dir.

krb5-libs ##################################################

libgcc ##################################################

libgcrypt ##################################################

libgpg-error ##################################################

libiconv ##################################################

libxml2 ##################################################

libxslt ##################################################

openldap ##################################################

openssl ##################################################

perl ##################################################

postgresql ##################################################

postgresql-contrib ##################################################

postgresql-docs ##################################################

postgresql-libs ##################################################

postgresql-server ##################################################

readline ##################################################

xz-libs ##################################################

zlib ##################################################

******

Can you help me understand the problem?

Regards

Francesco