I did not run the initdb.exe and thats why i could not start the server.Here is what i did:
1. Executed initdb.exe as follows:
runas /user:postgres "D:\pgsql\bin\initdb.exe -D:\pgsql\data"
2.Started the server by executing the following cmd:
runas /user:postgres "D:\pgsql\bin\pg_ctl.exe -w start -D D:\pgsql\data"
and it started fine.Thanks to Richard and Ray !
On Tue, Mar 31, 2009 at 6:13 PM, Raymond O'Donnell <rod@xxxxxx> wrote:
On 31/03/2009 12:14, CM J wrote:I wonder if that -P is causing trouble? According to the output of
> D:\pgsql\bin\pg_ctl.exe -U postgres -P <mypasswd> -w start -D D:\pgsql\data
--help, there's no -P option with a START operation; however, -p is used
to specify the path to the postgres binaries.
Just a stab in the dark.
Ray.
------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@xxxxxx
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------
