Re: re-install postgresql

Dear ashok,


Looks like you installed pgsql from the RPMS.

I feel the /etc/rc.d/init.d/postgresql script should be more verbose to
tell about the exact problem.

In any case the sure shot method of initialising and starting the postmaster
is to follow the instruction that comes in the INSTALL file of source
code.

You may do the following.

# su - postgres
# touch /var/log/pgsql
# chown postgres:  /var/log/pgsql
$ initdb /path/to/folder/to/store/data
$ pg_ctl -l /var/log/pgsql -D /path/to/folder/to/store/data start

check in /var/log/pgsql for errors.

Hope it will help.


Regds
mallah.

Ashok Chauhan wrote:

>help me
>
>i re - install the postgresql but it not start, gives following errors:
>1)    initiliazing database             [FAILED]
>2)    postgresql service            [FAILED]
>
>it gives a message in /var/log/message:- "session closed for user
>postgres"
>
>pls help me.
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 9: the planner will ignore your desire to choose an index scan if your
>      joining column's datatypes do not match
>
>
>