From: | jlhgis <julia(dot)harrell(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | troubles with initdb |
Date: | 2011-05-31 15:16:35 |
Message-ID: | BANLkTikvtD_tpOGaxF_6vyocraYJJ9v2+A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2011-05-31 15:56:29 | Re: Function Column Expansion Causes Inserts To Fail |
Previous Message | Mathew Samuel | 2011-05-31 14:46:30 | Re: UTC4115FATAL: the database system is in recovery mode |