Thara Vadakkeveedu wrote:
ps –edf shows no postgres processes:
-bash-4.1$ ps -edf | grep postgres
root 6412 6249 0 18:22 pts/000:00:00 su - postgres
postgres 6413 6412 0 18:22 pts/000:00:00 -bash
postgres 6465 6413 1 18:27 pts/000:00:00 ps -edf
postgres 6466 6413
...@yahoo.com; pgsql-admin@postgresql.org
pgsql-admin@postgresql.org
Sent: Tuesday, September 24, 2013 6:41 AM
Subject: Re: [ADMIN] 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
: Thara Vadakkeveedu thar...@yahoo.com
To: Albe Laurenz laurenz.a...@wien.gv.at; pgsql-admin@postgresql.org
pgsql-admin@postgresql.org
Sent: Tuesday, September 24, 2013 9:47 AM
Subject: Re: [ADMIN] accidentally deleted data directory
Here are the settings in the postgresql.conf file:
I remember
: Tuesday, September 24, 2013 10:11 AM
Subject: Re: [ADMIN] accidentally deleted data directory
Thara Vadakkeveedu wrote:
Do I need to run pg_resetxlog to fix the corrupted pg_control file issue?
No, since you don't mind starting afresh,
just delete the data directory and run initdb.
Yours,
Laurenz
Thara Vadakkeveedu wrote:
I am new to postgresql. I have postgresql 9.2 installed on Red hat linux 6.4
I accidentally deleted data directory this morning
(/var/lib/postgresql/9.2/data)
I tried to start posgresql 9.2 service
service postgresql9.2 start
I got a amessage to initialize the
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