troubles with initdb

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

Responses

Browse pgsql-general by date

  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