Обсуждение: problem with installing postgresql

Поиск
Список
Период
Сортировка

problem with installing postgresql

От
Praveen Kumar N
Дата:
hai...
     i have some problem with installing postgresql.
Following is the output of installation:
--------------------------------------------------------------------------

[praveen@babbage pgsql]$ initdb -D /usr/local/pgsql/Data/
The files belonging to this database system will be owned by user
"praveen".
This user must also own the server process.

The database cluster will be initialized with locale en_US.UTF-8.
The default database encoding has accordingly been set to UTF8.

fixing permissions on existing directory /usr/local/pgsql/Data ... ok
creating directory /usr/local/pgsql/Data/global ... ok
creating directory /usr/local/pgsql/Data/pg_xlog ... ok
creating directory /usr/local/pgsql/Data/pg_xlog/archive_status ... ok
creating directory /usr/local/pgsql/Data/pg_clog ... ok
creating directory /usr/local/pgsql/Data/pg_subtrans ... ok
creating directory /usr/local/pgsql/Data/pg_twophase ... ok
creating directory /usr/local/pgsql/Data/pg_multixact/members ... ok
creating directory /usr/local/pgsql/Data/pg_multixact/offsets ... ok
creating directory /usr/local/pgsql/Data/base ... ok
creating directory /usr/local/pgsql/Data/base/1 ... ok
creating directory /usr/local/pgsql/Data/pg_tblspc ... ok
selecting default max_connections ... 100
selecting default shared_buffers/max_fsm_pages ... 3500/175000
creating configuration files ... ok
creating template1 database in /usr/local/pgsql/Data/base/1 ... child
process was terminated by signal 11
initdb: removing contents of data directory "/usr/local/pgsql/Data"
-----------------------------------------------------------------------------

I have installed it with user name praveen.Earlier i installed
succesfully.but  this time I am getting the above output and didnt get any
solution for this problem on net.so could you please tell me the solution
for it.

thanks in anticipation.

regards,
--
  N Praveen Kumar

     Imagination is more important than knowledge...
                                 --Albert Einstein

Re: problem with installing postgresql

От
Christopher Browne
Дата:
In an attempt to throw the authorities off his trail, praveen_n@students.iiit.net (Praveen Kumar N) transmitted:
> hai...
>      i have some problem with installing postgresql.
> Following is the output of installation:
> --------------------------------------------------------------------------
>
> [praveen@babbage pgsql]$ initdb -D /usr/local/pgsql/Data/
> The files belonging to this database system will be owned by user
> "praveen".
> This user must also own the server process.
>
> The database cluster will be initialized with locale en_US.UTF-8.
> The default database encoding has accordingly been set to UTF8.
>
> fixing permissions on existing directory /usr/local/pgsql/Data ... ok
> creating directory /usr/local/pgsql/Data/global ... ok
> creating directory /usr/local/pgsql/Data/pg_xlog ... ok
> creating directory /usr/local/pgsql/Data/pg_xlog/archive_status ... ok
> creating directory /usr/local/pgsql/Data/pg_clog ... ok
> creating directory /usr/local/pgsql/Data/pg_subtrans ... ok
> creating directory /usr/local/pgsql/Data/pg_twophase ... ok
> creating directory /usr/local/pgsql/Data/pg_multixact/members ... ok
> creating directory /usr/local/pgsql/Data/pg_multixact/offsets ... ok
> creating directory /usr/local/pgsql/Data/base ... ok
> creating directory /usr/local/pgsql/Data/base/1 ... ok
> creating directory /usr/local/pgsql/Data/pg_tblspc ... ok
> selecting default max_connections ... 100
> selecting default shared_buffers/max_fsm_pages ... 3500/175000
> creating configuration files ... ok
> creating template1 database in /usr/local/pgsql/Data/base/1 ... child
> process was terminated by signal 11
> initdb: removing contents of data directory "/usr/local/pgsql/Data"
> -----------------------------------------------------------------------------
>
> I have installed it with user name praveen.Earlier i installed
> succesfully.but  this time I am getting the above output and didnt get
> any solution for this problem on net.so could you please tell me the
> solution for it.
>
> thanks in anticipation.
>
> regards,

The last time I encountered that problem, it related to readline not
having been compiled properly for AIX.

You're not running on AIX, are you?
--
let name="cbbrowne" and tld="gmail.com" in name ^ "@" ^ tld;;
http://linuxdatabases.info/info/lisp.html
"If there are aliens, they use Lisp."
--Edward Lasker, mutatis mutandi

Re: problem with installing postgresql

От
Tom Lane
Дата:
Praveen Kumar N <praveen_n@students.iiit.net> writes:
>      i have some problem with installing postgresql.

What platform are you on exactly, and which version of postgres is this?
Did you compile it yourself --- if so, with what compiler and configure
options?  If not, where did you get the executables from?

> creating template1 database in /usr/local/pgsql/Data/base/1 ... child
> process was terminated by signal 11
> initdb: removing contents of data directory "/usr/local/pgsql/Data"

The most direct way to get some info about that would be to run initdb
with the --noclean option so that it doesn't throw away the failed data
directory, and then use gdb with the core file that the crashed postgres
process would have left:

    $ gdb /path/to/postgres /path/to/core
    gdb> bt
    ... report what it says here ...
    gdb> quit

If you don't find any core file within the failed data directory, try
running it with "ulimit -c unlimited".

            regards, tom lane