If pgstartup.log is empty that points at an issue with the configuration file. From memory, when you do an initdb it recreates the configuration files in the /var/lib/pg... directory. I would look at the main control file and the pg_hba.conf and try to start the database passing it the name of the main conf file as a parameter (as well as the database directory).
Cheers, Cliff On Tue, Sep 24, 2013 at 10:36 AM, Thara Vadakkeveedu <thar...@yahoo.com>wrote: > > See if there are processes running for user "postgres" that look > like database processes and kill them. > > Then try again. > > What exactly is the error message? > > Yours, > Laurenz Albe > > > Hi > > > ps –edf shows no postgres processes: > -bash-4.1$ ps -edf | grep postgres > root 6412 6249 0 18:22 pts/0 00:00:00 su - postgres > postgres 6413 6412 0 18:22 pts/0 00:00:00 -bash > postgres 6465 6413 1 18:27 pts/0 00:00:00 ps -edf > postgres 6466 6413 0 18:27 pts/0 00:00:00 grep postgres > > > Ran the following command as postgres user > -bash-4.1$ /usr/pgsql-9.2/bin/postgres -D /var/lib/pgsql/9.2/data > -bash-4.1$ > > pgstartup.log is empty > > -bash-4.1$ pwd > /var/lib/pgsql/9.2 > -bash-4.1$ ls > backups data logfile pgstartup.log > -bash-4.1$ ls -al > total 20 > drwx------. 4 postgres postgres 4096 Sep 23 18:21 . > drwx------. 3 postgres postgres 4096 Sep 23 18:18 .. > drwx------. 2 postgres postgres 4096 Apr 1 19:41 backups > drwx------. 15 postgres postgres 4096 Sep 23 18:28 data > -rw-------. 1 postgres postgres 409 Sep 22 11:44 logfile > -rw------- 1 postgres postgres 0 Sep 23 18:20 pgstartup.log > -bash-4.1$ > > Is there something else I can try? > > I don’t have any data to restore. This is an installation which is only a > couple of weeks old. I can uninstall and reinstall if that is easier. > > > Where can I find the uninstaller ? > Thanks > Thara. > > > > > > >
