Re: accidentally deleted data directory

Thara Vadakkeveedu wrote:
> 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

Ok.

> Ran the following command as postgres user
> -bash-4.1$ /usr/pgsql-9.2/bin/postgres -D /var/lib/pgsql/9.2/data
>
> 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?

Yes.

Look how logging is configured in /var/lib/pgsql/9.2/data/postgresql.conf
(parameters log_destination, logging_collector, log_directory, log_filename).

Find the log file and see what is in there.

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

I don't know if that would solve the problem.

> Where can I find the uninstaller ?

How did you install PostgreSQL?

Yours,
Laurenz Albe