Re: unable to createuser in postgres 8.2.5 opensolaris - Mailing list pgsql-general

From Mayuresh Nirhali
Subject Re: unable to createuser in postgres 8.2.5 opensolaris
Date
Msg-id 4741337B.1080605@Sun.COM
Whole thread Raw
In response to unable to createuser in postgres 8.2.5 opensolaris  ("rkmr.em@gmail.com" <rkmr.em@gmail.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: unable to createuser in postgres 8.2.5 opensolaris
Next
From: Stefan Schwarzer
Date:
Subject: Re: Substitute column in SELECT with static value? (Crosstab problem?)