OS/2, eCS & ArcaOS - Technical > Applications

Updated Postgresql/2 builds

(1/4) > >>

Paul Smedley:
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

Paul Smedley:
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

Paul Smedley:
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.

Jan-Erik Lärka:
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"

Paul Smedley:

--- Quote from: 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:

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"

--- End quote ---

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

Cheers

Paul.

Navigation

[0] Message Index

[#] Next page

Go to full version