[ADMIN] Encountering errors while using pg_ctl

Hi All, We're using postgresql v.8.0.4 on a RHEL ES 4. Its newly installed by my sys-admin and when trying to use pg_ctl I get this error: [EMAIL PROTECTED] pgsql]$ pg_ctl -D /usr/local/pgsql/data stop -l log The programs "postmaster" and "psql" are needed by pg_ctl but were not found in the dire

Re: [ADMIN] Encountering errors while using pg_ctl

Phillip, As you can see it, > Where did you install Postgres to? Did you install a binary package or > compile from source? Its from a binary source. The files are in various places but $PGDATA will be in /usr/local/pgsql. Someone else did the installation. >You may just need to sym link pos

Re: [ADMIN] Encountering errors while using pg_ctl

All, I realize what the problem is. Somehow multiple versions on pg_ctl exists... [EMAIL PROTECTED] pgsql]$ find / -name pg_ctl -print 2>/dev/null /usr/bin/pg_ctl /usr/local/pgsql/bin/pg_ctl /opt/postgresql-8.0.4/src/bin/pg_ctl /opt/postgresql-8.0.4/src/bin/pg_ctl/pg_ctl [EMAIL PROTECTED] pgsql]$

[ADMIN] warm standby database on 8.0.4

Hi All, I was wondering if anyone has had success implementing a warm spare database using WAL archiving on a v8.0.4 database. I know the documentation that states warm spare was in 8.2.4 manual but having read and re-read it, it "should" work as it is not using any v8.2-specific feature to achie

[ADMIN] Application that monitors performance/runaway transactions

Hi all, I was wondering if there are any applications out there that we can use to monitor the PostgreSQL DB for performance and runaway transactions/queries/users? Does pgAdmin III and/or phpPgAdmin III do these for us? Thank you, Best Regards Luqman B Mohd Ali CONFIDENTIALITY This e-mail m