Обсуждение: 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.
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
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 > > > 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