Re: accidentally deleted data directory

Поиск
Список
Период
Сортировка
От Cliff Pratt
Тема Re: accidentally deleted data directory
Дата
Msg-id CADXosEJPC9Zzy=mZd2bZHDZzcCan=Vgv2BS8m_vGfti0KKhN0w@mail.gmail.com
обсуждение исходный текст
Ответ на accidentally deleted data directory  (Thara Vadakkeveedu <tharagv@yahoo.com>)
Список 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@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.
 
 
 
 



В списке pgsql-admin по дате отправления:

Предыдущее
От: Thara Vadakkeveedu
Дата:
Сообщение: accidentally deleted data directory
Следующее
От: Albe Laurenz
Дата:
Сообщение: Re: accidentally deleted data directory