Re: unable to createuser in postgres 8.2.5 opensolaris

From: Mayuresh Nirhali <Mayuresh(dot)Nirhali(at)Sun(dot)COM>
To: "rkmr(dot)em(at)gmail(dot)com" <rkmr(dot)em(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: unable to createuser in postgres 8.2.5 opensolaris
Date: 2007-11-19 06:55:55
Message-ID: 4741337B.1080605@Sun.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

rkmr(dot)em(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ow Mun Heng 2007-11-19 07:34:29 Re: Calculation for Max_FSM_pages : Any rules of thumb?
Previous Message Tom Lane 2007-11-19 04:12:24 Re: unable to createuser in postgres 8.2.5 opensolaris