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 <tharagv@xxxxxxxxx> wrote:
See if there are processes running for user "postgres" that looklike database processes and kill them.Then try again.What exactly is the error message?Yours,Laurenz AlbeHips –edf shows no postgres processes:-bash-4.1$ ps -edf | grep postgresroot 6412 6249 0 18:22 pts/0 00:00:00 su - postgrespostgres 6413 6412 0 18:22 pts/0 00:00:00 -bashpostgres 6465 6413 1 18:27 pts/0 00:00:00 ps -edfpostgres 6466 6413 0 18:27 pts/0 00:00:00 grep postgresRan 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$ lsbackups data logfile pgstartup.log-bash-4.1$ ls -altotal 20drwx------. 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 backupsdrwx------. 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 ?ThanksThara.
