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