Great eyes!
It was copied & pasted out of some running notes & screenshots of the
process I was keeping in an OO file. You're a lot more "helpful" than
it was :) Thanks so much for taking the time to look at this.
Now, on to the next hurdle - getting pg_ctl to run as an automated service...
>
On 31/05/2011 11:16 PM, jlhgis wrote:
initdb –A md5 –D E:\Spatial_DB_Files\PostgreSQL_Test\8.3\data -E
UTF8 –-locale=C -X F:\pgsql_test_logs –U pgsql_test_su –W
Aaaah... your typeface just gave me a clue. It's impossible for me to
tell if the issue above is just your mail client being "
>>The data directory in the initdb command is different
>>from the one you mention above - is that the case or
>>were you just abbreviating?
Yes, I had intended them to be different. My D drive is a small
internal hard drive where I install all my application software, but I
wanted to put the data
On 05/31/2011 11:16 PM, jlhgis wrote:
I stopped the first instance of PostgreSQL and made a copy of the
‘postgresql’ software installation. Copied
"D:\Database_Apps\PostgreSQL_Dev" to
"D:\Database_Apps\PostgreSQL_Test".
You don't need to do that. It's fine to use the same binaries and just
hav
On 31/05/2011 16:16, jlhgis wrote:
Create a new data directory for the 2nd instance of Postgres, located
at "E:\SPDB_Files\PostgreSQL_Test\8.3\data" and gave the
'postgres_test' account full control of everything under
\PostgreSQL_Test
[...]
initdb –A md5 –D E:\Spatial_DB_Files\PostgreSQL_Te
