From: | Cliff Pratt <enkiduonthenet(at)gmail(dot)com> |
---|---|
To: | Thara Vadakkeveedu <tharagv(at)yahoo(dot)com> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: accidentally deleted data directory |
Date: | 2013-09-24 00:40:39 |
Message-ID: | CADXosEJPC9Zzy=mZd2bZHDZzcCan=Vgv2BS8m_vGfti0KKhN0w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
>
>
>
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Albe Laurenz | 2013-09-24 10:41:21 | Re: accidentally deleted data directory |
Previous Message | Thara Vadakkeveedu | 2013-09-23 22:36:22 | accidentally deleted data directory |