On Tue, Mar 4, 2008 at 4:11 PM, <[EMAIL PROTECTED]> wrote: > > When running the pg_ctl command i am facing this error > pg_ctl: no database directory specified and environment variable PGDATA > unset > I use other options also but no solution was found. > could someone help me on this > Thats not enough information to resolve anything. Please be a bit more descriptive.
Anyway, its pretty clear that you do not have PGDATA set in the environment. So you need to run the command as follows: pg_ctl -D /your/postgres/data/directory start RTFM will definitely help. -- [EMAIL PROTECTED] [EMAIL PROTECTED] gmail | hotmail | indiatimes | yahoo }.com EnterpriseDB http://www.enterprisedb.com 17° 29' 34.37"N, 78° 30' 59.76"E - Hyderabad 18° 32' 57.25"N, 73° 56' 25.42"E - Pune * 37° 47' 19.72"N, 122° 24' 1.69" W - San Francisco http://gurjeet.frihost.net Mail sent from my BlackLaptop device