Printable View
Hi,
postgresql 9.1 service is not starting for me... I have installed Kali 64 on my External HD...after unplugging the external hd before shutting down kali...postgresql is giving me error - it is not able to start...I cant use armitage, metasploit is loading but database slow...
I have tried : apt-get update ; update postgresql ; enable postgresql at start up and metasploit ; service postgresql start ...stopping is OK... ;
Can I uninstall postgresql and install again...?
Please help me...
Could you share the log file(s)?
Code:cat /var/log/postgresql/*
cat /var/log/syslog | grep -i postgres
cat /var/log/messages | grep -i postgres
Gotmilk, thank you for your interest....what I did now is...I deleted the original postgresql file which came with kali and installed the new 9.3v Graphicall...this is what I get now...-
~# service postgresql-9.3 status
pg_ctl: server is running (PID: 2708)
/etc/bin/postgres "-D" "/etc/data"
-----------------------------------------------------------------------------------
service postgresql-9.3 start
Starting PostgreSQL 9.3:
pg_ctl: another server might be running; trying to start server anyway
waiting for server to start........
pg_ctl: this data directory appears to be running a pre-existing postmaster
stopped waiting
pg_ctl: could not start server
Examine the log output.
PostgreSQL 9.3 did not start in a timely fashion, please see /etc/data/pg_log/startup.log for details
------------------------------------------------------------------------------------------------------------------------------------
2013-12-03 08:17:32 GMT LOG: redirecting log output to logging collector process
2013-12-03 08:17:32 GMT HINT: Future log output will appear in directory "pg_log".
2013-12-03 08:21:27 GMT FATAL: lock file "postmaster.pid" already exists
2013-12-03 08:21:27 GMT HINT: Is another postmaster (PID 6865) running in data directory "/etc/data"?
2013-12-03 08:31:32 GMT FATAL: lock file "postmaster.pid" already exists
2013-12-03 08:31:32 GMT HINT: Is another postmaster (PID 6865) running in data directory "/etc/data"?
2013-12-03 16:45:55 GMT LOG: redirecting log output to logging collector process
2013-12-03 16:45:55 GMT HINT: Future log output will appear in directory "pg_log".
2013-12-03 17:55:11 GMT FATAL: lock file "postmaster.pid" already exists
2013-12-03 17:55:11 GMT HINT: Is another postmaster (PID 2708) running in data directory "/etc/data"?
------------------------------------ARMITAGE AND METASPLOIT----------------------------------------
:~# msfconsole
[-] Failed to connect to the database: FATAL: password authentication failed for user "msf3"
- No idea where the msf3 came from- it was only "msf" before
.
MAny thx in advance
From the sounds of this, that wasn't wise. How did you 'delete' it?Quote:
Originally Posted by christopher777
Just rm -rf the file(s)? Did you remove the package(s)? What command(s) did you use?
Moving that aside, looking at the output:
And from your first post:Quote:
2013-12-03 08:21:27 GMT FATAL: lock file "postmaster.pid" already exists
2013-12-03 08:21:27 GMT HINT: Is another postmaster (PID 6865) running in data directory "/etc/data"?
My guess would be there is a old PID file, that hasn't been removed. As a result, postgresql always things there already a copy of itself running.Quote:
after unplugging the external hd before shutting down
I'm not sure where '/etc/data' has come from.
Because I cant be sure with what you have done fully to postgresql (and how you installed it). I can't be 100% in my next suggestion.
Below is me starting up postgresql, checking its running (twice), locating the PID file and checking to see if it have a '/etc/data/' folder like in your output (which is mentioned in your output).
Code:root@kali-offsec ~$ service postgresql start
[ ok ] Starting PostgreSQL 9.1 database server: main.
root@kali~$ service postgresql status
Running clusters: 9.1/main
root@kali~$ ps aux | grep postgresql
root 10641 0.0 0.0 3484 768 pts/10 S+ 09:48 0:00 grep postgresql
postgres 31126 0.0 0.7 45144 7408 ? S 07:53 0:00 /usr/lib/postgresql/9.1/bin/postgres -D /var/lib/postgresql/9.1/main -c config_file=/etc/postgresql/9.1/main/postgresql.conf
root@kali~$ find / -name postmaster.pid
/var/lib/postgresql/9.1/main/postmaster.pid
root@kali~$ ls /etc/data/
ls: cannot access /etc/data/: No such file or directory
root@kali~$
My first suggestion would be to remove whatever you have done to postgresql, and restore the repo version (you may run into package dependencies issue later when you try and upgrade). After that, be 100% sure that postgresql isn't already running and then remove the PID file.
Gotmilk, ...No i just deleted the folders and files which I saw in etc and init.d... I can not find the old file.
MAny thanx for your help anyway...
HOw do i restore the original files...?
You can't restore them as you deleted them.Quote:
Originally Posted by christopher777
Best bet is going to be do a fresh install.
...finally fixed issue... reinstall metasploit and armitage
how to remove postgresql?