Re: accidentally deleted data directory

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(at)yahoo(dot)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.
>
>
>
>
>
>
>