hi all I am trying to create a second instance of PostgreSQL (8.3) on a Windows 2003 server with initdb, but am running into an error message I can't seem to resolve. Here's what I've done so far: Created a new local account 'postgres_test' for the 2nd instance to run under. 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". Deleted the data directory. Gave the 'postgres_test' account full control of the D:\Database_Apps\PostgreSQL_Test\directory tree. 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 Trying to to run initdb (from D:\Database_Apps\PostgreSQL_Test\8.3\bin ) at the command line with these parameters: 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 The error message I get is: initdb: too many command-line arguments (first is "-D") I've tried the parameters encased in quotes too, but it makes no difference. Also tried adding the -d and -n switches to see if they'd give me any more detailed error messages, or other clues, but the result was the same. Based on the information in http://www.postgresql.org/docs/8.3/static/app-initdb.html, it looks to me like I have the correct command line parameters, but something is still not right. Can someone with a fresh pair of eyes on this suggest what the problem might be? Thanks, Julia -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
