pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedProblems when initdb on AIX 5.3
7+ messages / 4 participants
[nested] [flat]
* Problems when initdb on AIX 5.3
@ 2018-09-18 11:08 Francesco Vecchio <franco.vecchio@gmail.com>
0 siblings, 2 replies; 7+ messages in thread
From: Francesco Vecchio @ 2018-09-18 11:08 UTC (permalink / raw)
To: pgsql-admin
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
<http://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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Problems when initdb on AIX 5.3
@ 2018-09-18 11:43 Laurenz Albe <laurenz.albe@cybertec.at>
parent: Francesco Vecchio <franco.vecchio@gmail.com>
1 sibling, 0 replies; 7+ messages in thread
From: Laurenz Albe @ 2018-09-18 11:43 UTC (permalink / raw)
To: Francesco Vecchio <franco.vecchio@gmail.com>; pgsql-admin
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Problems when initdb on AIX 5.3
@ 2018-09-20 16:22 Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 1 reply; 7+ messages in thread
From: Laurenz Albe @ 2018-09-20 16:22 UTC (permalink / raw)
To: Francesco Vecchio <franco.vecchio@gmail.com>; pgsql-admin
Francesco Vecchio wrote:
> I did a test with the truss command connecting it via the pid but it does not give any message.
Then it is probably hung somewhere.
Can you arrach with a debugger and see where?
But if you don't have a build environment, you might not have a
debugger either...
> As for the version of Postgresql, I would like to adopt what you indicate
> to me but I do not know a website from which to download the objects.
> I only know www.perzl.org. www.bullfreeware.com and www.oss4aix.com that
> for AIX 5.3 only make available the version I have adopted.
> Unfortunately, I do not have the environment to compile the sources.
Well, AIX 5.3 has been dead for over 6 years.
You really shouldn't be doing any of this, it is just asking for trouble.
Why not use a recent AIX with a recent PostgreSQL?
If there is a running 9.3 installation on AIX 5.3 somewhere that you have
to work with. upgrade ASAP by pg_dumping it with a recent PostgreSQL
and importing into a new environment.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Problems when initdb on AIX 5.3
@ 2018-09-20 20:21 Francesco Vecchio <franco.vecchio@gmail.com>
parent: Francesco Vecchio <franco.vecchio@gmail.com>
1 sibling, 0 replies; 7+ messages in thread
From: Francesco Vecchio @ 2018-09-20 20:21 UTC (permalink / raw)
To: 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
> <http://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
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Problems when initdb on AIX 5.3
@ 2018-09-21 00:56 Ron <ronljohnsonjr@gmail.com>
parent: Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 2 replies; 7+ messages in thread
From: Ron @ 2018-09-21 00:56 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
On 09/20/2018 11:22 AM, Laurenz Albe wrote:
[snip]
> Well, AIX 5.3 has been dead for over 6 years.
>
> You really shouldn't be doing any of this, it is just asking for trouble.
>
> Why not use a recent AIX with a recent PostgreSQL?
Why do people so blithely and arrogantly assume that DBA can choose what
hardware and OS version to run his software on? It's shockingly ignorant of
the reality of life: *you* don't control the hardware, or the OS or the
network or the application.
--
Angular momentum makes the world go 'round.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Problems when initdb on AIX 5.3
@ 2018-09-21 02:45 Laurenz Albe <laurenz.albe@cybertec.at>
parent: Ron <ronljohnsonjr@gmail.com>
1 sibling, 0 replies; 7+ messages in thread
From: Laurenz Albe @ 2018-09-21 02:45 UTC (permalink / raw)
To: Ron <ronljohnsonjr@gmail.com>; pgsql-admin@lists.postgresql.org
Ron wrote:
> On 09/20/2018 11:22 AM, Laurenz Albe wrote:
> [snip]
> > Well, AIX 5.3 has been dead for over 6 years.
> >
> > You really shouldn't be doing any of this, it is just asking for trouble.
> >
> > Why not use a recent AIX with a recent PostgreSQL?
>
> Why do people so blithely and arrogantly assume that DBA can choose what
> hardware and OS version to run his software on? It's shockingly ignorant
> of the reality of life: you don't control the hardware, or the OS or the
> network or the application.
I didn't mean to sound arrogant, and I tried to help Francesco
as good as I can without an AIX at my hands.
I know from personal experience that you often don't have a choice,
but I believe that the DBA is not just a gofer, she also has a certain
responsibility. Part of that responsibility is to stand up and
scream when the system is in a condition that threatens the security,
availability and integrity of the data.
And since no man is a prophet in his own land, you can give this
complaint force by referring to external experts. This is something
the PostgreSQL mailing lists can help with.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Problems when initdb on AIX 5.3
@ 2018-09-21 03:00 Andres Freund <andres@anarazel.de>
parent: Ron <ronljohnsonjr@gmail.com>
1 sibling, 0 replies; 7+ messages in thread
From: Andres Freund @ 2018-09-21 03:00 UTC (permalink / raw)
To: Ron <ronljohnsonjr@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
On 2018-09-20 19:56:58 -0500, Ron wrote:
> On 09/20/2018 11:22 AM, Laurenz Albe wrote:
> [snip]
> > Well, AIX 5.3 has been dead for over 6 years.
> >
> > You really shouldn't be doing any of this, it is just asking for trouble.
> >
> > Why not use a recent AIX with a recent PostgreSQL?
>
> Why do people so blithely and arrogantly assume that DBA can choose what
> hardware and OS version to run his software on? It's shockingly ignorant of
> the reality of life: *you* don't control the hardware, or the OS or the
> network or the application.
Wishes don't make resource to debug arcane issues on outdated platforms
appear out of thin air.
Greetings,
Andres Freund
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2018-09-21 03:00 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-09-18 11:08 Problems when initdb on AIX 5.3 Francesco Vecchio <franco.vecchio@gmail.com>
2018-09-18 11:43 ` Laurenz Albe <laurenz.albe@cybertec.at>
2018-09-20 20:21 ` Francesco Vecchio <franco.vecchio@gmail.com>
2018-09-20 16:22 Re: Problems when initdb on AIX 5.3 Laurenz Albe <laurenz.albe@cybertec.at>
2018-09-21 00:56 ` Ron <ronljohnsonjr@gmail.com>
2018-09-21 02:45 ` Laurenz Albe <laurenz.albe@cybertec.at>
2018-09-21 03:00 ` Andres Freund <andres@anarazel.de>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox