From: Thara Vadakkeveedu <tharagv@yahoo.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: accidentally deleted data directory
Date: Mon, 23 Sep 2013 15:36:22 -0700 (PDT)
Message-ID: <1379975782.27726.YahooMailNeo@web125005.mail.ne1.yahoo.com> (raw)
In-Reply-To: <48F1E182B1021B449414C85E713CE8250E61E0@WLT-MBX03.KRONOS.com>
References: <48F1E182B1021B449414C85E713CE8250E61E0@WLT-MBX03.KRONOS.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tharagv@yahoo.com
Subject: Re: accidentally deleted data directory
In-Reply-To: <1379975782.27726.YahooMailNeo@web125005.mail.ne1.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox