I tried starting postgres using the main configuration file. I get "not a directory" message...
-bash-4.1$ /usr/pgsql-9.2/bin/postgres -D /var/lib/pgsql/9.2/data/postgresql.conf
postgres cannot access the server configuration file "/var/lib/pgsql/9.2/data/postgresql.conf/postgresql.conf": Not a directory
-bash-4.1$ ls -al
...
...
drwx------. 3 postgres postgres 4096 Sep 22 12:20 pg_xlog
-rw-------. 1 postgres postgres 19601 Sep 22 11:35 postgresql.conf
-rw------- 1 postgres postgres 59 Sep 23 20:35 postmaster.opts
-bash-4.1$ /usr/pgsql-9.2/bin/postgres -D /var/lib/pgsql/9.2/data/postgresql.conf
postgres cannot access the server configuration file "/var/lib/pgsql/9.2/data/postgresql.conf/postgresql.conf": Not a directory
-bash-4.1$ chmod 755 postgresql.conf
-bash-4.1$ /usr/pgsql-9.2/bin/postgres -D /var/lib/pgsql/9.2/data/postgresql.conf
postgres cannot access the server configuration file "/var/lib/pgsql/9.2/data/postgresql.conf/postgresql.conf": Not a directory
-bash-4.1$
-bash-4.1$ pwd
/var/lib/pgsql/9.2/data
Thanks,
Thara.
From: Thara Vadakkeveedu <tharagv@yahoo.com>
To: Luca Ferrari <fluca1978@infinito.it>
Cc: "pgsql-novice@postgresql.org" <pgsql-novice@postgresql.org>
Sent: Monday, September 23, 2013 8:45 PM
Subject: Re: [NOVICE] Uninstall postgresql 9.2 on red hat linux
There are no processes belonging to postgres on the system.
-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
root 6781 6756 0 20:35 pts/1 00:00:00 su - postgres
postgres 6782 6781 0 20:35 pts/1 00:00:00 -bash
postgres 6846 6782 1 20:45 pts/1 00:00:00 ps -edf
postgres 6847 6782 0 20:45 pts/1 00:00:00 grep postgres
-bash-4.1$
Thanks,
TG
From: Luca Ferrari <fluca1978@infinito.it>
To: Thara Vadakkeveedu <tharagv@yahoo.com>
Cc: "pgsql-novice@postgresql.org" <pgsql-novice@postgresql.org>
Sent: Monday, September 23, 2013 2:41 AM
Subject: Re: [NOVICE] Uninstall postgresql 9.2 on red hat linux
On Mon, Sep 23, 2013 at 1:57 AM, Thara Vadakkeveedu <
tharagv@yahoo.com> wrote:
> I accidentally deleted data directory this morning
> (/var/lib/postgresql/9.2/data)
>
What a start of a day!
> I tried su - postgres
> and then from the bash shell I tried to run these commands (tried one at a
> time)
> but I got the message that address was in use. There are no processes
> running on 5432.
I suspect if it gives you such an error there must something bound to
the address. Have you tried to execute nmap against the IPv4 address
your server is listening on (or supposed to be listening on)?
Luca