Re: Problems when initdb on AIX 5.3

Поиск
Список
Период
Сортировка
От Francesco Vecchio
Тема Re: Problems when initdb on AIX 5.3
Дата
Msg-id CAKGSuS_QMTPtu47hGE+mYM4UU0D4ZjNYBvsHc2-AiPKpgTa9iA@mail.gmail.com
обсуждение исходный текст
Ответ на Problems when initdb on AIX 5.3  (Francesco Vecchio <franco.vecchio@gmail.com>)
Список pgsql-admin
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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Mike Broers
Дата:
Сообщение: Re: root cause of corruption in hot standby
Следующее
От: Ron
Дата:
Сообщение: Re: Problems when initdb on AIX 5.3