OS2 World Community Forum

OS/2, eCS & ArcaOS - Technical => Applications => Topic started by: Paul Smedley on January 01, 2018, 08:26:19 am

Title: Updated Postgresql/2 builds
Post by: Paul Smedley on January 01, 2018, 08:26:19 am
Hi All,

Inspired by Greg Pringle and Jan-Erik Larka, I updated Postgresql to 9.3.x:
http://smedley.id.au/tmp/postgresql-9.3.17-os2-20171231.zip

I also just built 9.4.x:
http://smedley.id.au/tmp/postgresql-9.4.15-os2-20180101.zip

Feedback appreciated!

Cheers,

Paul
Title: Re: Updated Postgresql/2 builds
Post by: Paul Smedley on January 01, 2018, 09:57:31 am
While I was at it, I built 9.6.6:
http://smedley.id.au/tmp/postgresql-9.6.6-os2-20180101.zip

Note that sometimes when running the database initialisation, I got an error like:
running bootstrap script ... FATAL:  could not get shared memory segment: Invalid argument

running initdb a 2nd time seemed to address this.

Cheers,

Paul
Title: Re: Updated Postgresql/2 builds
Post by: Paul Smedley on January 01, 2018, 10:02:57 am
VIRTUALADDRESSLIMIT=2048 seems to be the best setting here to not get the above error during initdb.

Too small (1536) and it randomly fails, too big (2560) and it fails 100% with a semget() error.
Title: Re: Updated Postgresql/2 builds
Post by: Jan-Erik Lärka on January 01, 2018, 07:27:32 pm
initdb in the 9.4 and 9.6 build doesn't behave like they do in 9.3:

selecting dynamic shared memory implementation ... sysv
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... postgres: could not look up effecti
ve user ID 0: No such file or directory
child process exited with exit code 1
initdb: removing data directory "D:/NLSTeam"
Title: Re: Updated Postgresql/2 builds
Post by: Paul Smedley on January 01, 2018, 09:29:02 pm
initdb in the 9.4 and 9.6 build doesn't behave like they do in 9.3:

performing post-bootstrap initialization ... postgres: could not look up effective user ID 0: No such file or directory
child process exited with exit code 1
initdb: removing data directory "D:/NLSTeam"

Needless to say, I don't see that here, but I'll try investigate soon!

Cheers

Paul.
Title: Re: Updated Postgresql/2 builds
Post by: Paul Smedley on January 03, 2018, 08:46:56 am
initdb in the 9.4 and 9.6 build doesn't behave like they do in 9.3:

performing post-bootstrap initialization ... postgres: could not look up effective user ID 0: No such file or directory
child process exited with exit code 1
initdb: removing data directory "D:/NLSTeam"

Needless to say, I don't see that here, but I'll try investigate soon!

Hopefully https://www.dropbox.com/s/8hkit4gq4b8kedt/postgresql-9.6.6-os2-20180103.zip?dl=0 should help

Cheers,

Paul