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 initiali
Hi ,
When you don't specify unit, it's in ms.
See the test bellow:
BR
Patrick KUI-LI
postgres=# SET statement_timeout TO 1000;
SET
Time: 0.214 ms
postgres=# show statement_timeout;
statement_timeout
---
1s
(1 row)
Example with unit:
postgres=# SET statement_timeout TO '1000s'
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
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
