Thread: Uninstall postgresql 9.2 on red hat linux

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