Whats Postgres doing?
I'm trying to get to grips with a server that I've inherited. Its rather old and out of date, but its serving web sites for about 70 clients who i dont want to pi$$ off. Server is running Debian 5 and has aprox 80 outstanding updates!
To my knowledge, nothing is using postgres but i want to be sure before i remove it. These are the processes i see running:
postgres 4925 0.0 0.1 42092 1392 ? S Sep16 0:17 /usr/lib/postgresql/8.3/bin/postgres -D /var/lib/postgresql/8.3/main -c config_file=/etc/postgresql/8.3/main/postgresql.conf postgres 4928 0.0 0.0 42092 448 ? Ss Sep16 3:42 postgres: writer process postgres 4929 0.0 0.0 42092 384 ? Ss Sep16 2:13 postgres: wal writer process postgres 4930 0.0 0.0 42092 660 ? Ss Sep16 0:53 postgres: autovacuum launcher process postgres 4931 0.0 0.0 13412 476 ? Ss Sep16 0:30 postgres: stats collector process
I also looked up a couple of commands and tried them, with these results:
server1:~# psql psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"? server1:~# postgres -bash: postgres: command not found server1:~#
Does this all imply there is only a client of some sort running and no server? Or am i a mile off?