unable to createuser in postgres 8.2.5 opensolaris
I initialized a database directory and it started fine. But when I tried to
create user I got this error.
Can you tell what is wrong?
thanks
createuser --superuser --createdb --createrole -P postgres
Enter password for new role:
Enter it again:
createuser: could not connect to database postgres: server closed the
connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
the logfile is here:
LOG: could not bind IPv6 socket: Cannot assign requested address
HINT: Is another postmaster already running on port 5432? If not, wait a
few seconds and retry.
LOG: database system was shut down at 2007-11-18 19:50:38 PST
LOG: checkpoint record is at 0/42CC84
LOG: redo record is at 0/42CC84; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 0/593; next OID: 10820
LOG: next MultiXactId: 1; next MultiXactOffset: 0
LOG: database system is ready
LOG: setsockopt(TCP_NODELAY) failed: Option not supported by protocol
"rkmr.em@gmail.com" <rkmr.em@gmail.com> writes:
LOG: setsockopt(TCP_NODELAY) failed: Option not supported by protocol
I think you would need to have a word with Sun about that. If a
platform exposes the option then it ought to support it. For that
matter, no remotely-modern Unix platform should fail to support that
particular option.
regards, tom lane
PS: I doubt you told us the whole truth about what you were doing,
because that code path wouldn't be entered for a Unix-socket connection.
Nonetheless, setsockopt(TCP_NODELAY) has no business failing.
rkmr.em@gmail.com wrote:
I initialized a database directory and it started fine. But when I
tried to create user I got this error.
Can you tell what is wrong?
thanks
I did a quick check on my Solaris box and it seems to be working fine
for me.
Can you provide more information on what exactly you are trying to do ?
Did you compile 8.2.5 yourself or picked up binaries from somewhere ?
Which OpenSolaris build are you using ??
cheers
Mayuresh
Show quoted text
createuser --superuser --createdb --createrole -P postgres
Enter password for new role:
Enter it again:
createuser: could not connect to database postgres: server closed the
connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.the logfile is here:
LOG: could not bind IPv6 socket: Cannot assign requested address
HINT: Is another postmaster already running on port 5432? If not,
wait a few seconds and retry.
LOG: database system was shut down at 2007-11-18 19:50:38 PST
LOG: checkpoint record is at 0/42CC84
LOG: redo record is at 0/42CC84; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 0/593; next OID: 10820
LOG: next MultiXactId: 1; next MultiXactOffset: 0
LOG: database system is ready
LOG: setsockopt(TCP_NODELAY) failed: Option not supported by protocol