Thread: BUG #2048: initdb hang up

BUG #2048: initdb hang up

From
"Acure"
Date:
The following bug has been logged online:

Bug reference:      2048
Logged by:          Acure
Email address:      cure@g.pl
PostgreSQL version: 8.1.0
Operating system:   freebsd
Description:        initdb hang up
Details:

I want to upgrade pgsql server from 8.0 to 8.1, but i have troubles with
initdb

I have instaled pgsql 8.1 from updated ports.

As pgsql user i execute initdb :

"initdb -U pgsql -W -D datapl"

........

and it stop on :

"creating template1 database in tescik/base/1 ..."

i have tried to debug with another params - but it's always stop.

I have tried to change system seting to :

/boot/loader.conf

kern.ipc.semmni=256
kern.ipc.semmns=256

 /etc/sysctl.conf

kern.ipc.somaxconn=4096
kern.ipc.shmmax=146800640
kern.maxfiles=65536
kern.ipc.shmall=65536


 Please Help me !! :)

  ACure

Re: BUG #2048: initdb hang up

From
"Qingqing Zhou"
Date:
""Acure"" <cure@g.pl> wrote
>
>
> As pgsql user i execute initdb :
>
> "initdb -U pgsql -W -D datapl"
>
> ........
>
> and it stop on :
>
> "creating template1 database in tescik/base/1 ..."
>

Why you set "datapl" as the data directory but you get a "tescik"? Also, to
see where it stops, you can add a "-d" flag to initdb command.

Regards,
Qingqing