PostgreSQL Bugs - BUG #2048: initdb hang up

Author

BUG #2048: initdb hang up

Acure

2005-11-18, 9:24 am

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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Qingqing Zhou

2005-11-21, 8:25 pm

""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

Sponsored Links