re-install postgresql
re-install postgresql
От:
Ashok Chauhan <ashok@kalculate.com>
Дата:
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.
Re: re-install postgresql
От:
Rajesh Kumar Mallah <mallah@trade-india.com>
Дата:
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 > > >