Thread: + where is the location?

+ where is the location?

From
stm23
Date:
also where is it located?


Re: + where is the location?

From
joseph speigle
Date:
hi,

> also where is it located?

[webuser@www /tmp]$ su - postgres
-bash-2.05b$ echo $PGDATA
/var/lib/pgsql/data
-bash-2.05b$ env | grep PG
PGDATA=/var/lib/pgsql/data
-bash-2.05b$ psql --version
psql (PostgreSQL) 7.3.1
contains support for command-line editing
-bash-2.05b$ pg_ctl --version
pg_ctl (PostgreSQL) 7.3.1
-bash-2.05b$ ps -aux | grep postmaster
postgres 27277  0.0  0.1 10120 1612 ?        S    Mar04   0:03 /usr/local/pgsql/
-bash-2.05b$ ps 27277
  PID TTY      STAT   TIME COMMAND
27277 ?        S      0:03 /usr/local/pgsql/bin/postmaster
-bash-2.05b$



joe
--
speigle
www.sirfsup.com

Re: + where is the location?

From
joseph speigle
Date:
> also where is it located?
and don't pass up the obvious "which pg_ctl" or "which psql".
and if you have tab commandline completion, type pg_[tab][tab] and see what comes up.  If nothing, try a locate pg_ctl
or"lcocate psql".  In desperation, maybe a find / -name psql may turn up something.  but it takes a while to run that
onedoes. 
--
joe speigle
www.sirfsup.com