[GENERAL] How to implement autostart of postgres?

2011-07-28 Thread Gavrina, Irina
Thank you all for your answers. I'm using the Red Hat 5 OS. So I have no the 'upstart' utility at my disposal. Unfortunately. Yes, you are right, this is a question of database robustness. You know, If any of postgres processes died the postmaster process will again start up it. The main w

[GENERAL] How to implement autostart of postgres?

2011-07-20 Thread Gavrina, Irina
Hello All, I've faced with the following problem: I'm trying to implement the auto start of postgres. My way is to use inittab: pg:2345:respawn:/bin/su - postgres -c "/usr/local/pgsql/bin/postmaster -D/usr/local/pgsql/data >> /usr/local/pgsql/server.log 2>&1" /dev/null But this approach does

[GENERAL] Hide db name and user name in process list arguments

2011-02-16 Thread Gavrina, Irina
Hi, On Unix systems Postgres process list can be accessible through 'ps' utility: ps auxww | grep ^postgres $ ps auxww | grep ^postgres postgres 960 0.0 1.1 6104 1480 pts/1SN 13:17 0:00 postmaster -i postgres 963 0.0 1.1 7084 1472 pts/1SN 13:17 0:00 postgres: stats