Skip site navigation (1) Skip section navigation (2)

Re: troubles with initdb

From: jlhgis <julia(dot)harrell(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: troubles with initdb
Date: 2011-06-01 01:17:13
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
>>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 database files on the E drive and the logs on the F
drive, both of which are on the SAN and have plenty of disk space

>> Also, looking at the way the command is documented,
>>I wonder if -D needs to be the last option? - Only a guess.

I tried rearranging the order of the command line arguments several
different ways. Doesn't  seem to matter. Whichever is the second one
gets flagged as the error. I got rid of the -A argument, and it just
shifted the error down to the next parameter.

>> You don't need to do that. It's fine to use the same
>> binaries and just have multiple data directories.
>> It's also unnecessary to create a second user account
>> for the second instance, though you can if you'd prefer
>> to isolate them.

I was hoping to completely isolate them from each other, including the
binaries. Some day we'll be able to upgrade the database to 9, but
we'll want to do that only on the dev instance at first - keeping the
test instance at 8.3 until we are sure we've got everything working OK
in 9. The IT folks are very stingy with dev & test servers, so I am
forced to run both instances on the same virtual server.

> When you run initdb, are you invoking it via runas.exe as
> postgres_test ? Or logging in as the postgres_test user?

I am doing this logged in as the 'postgres_test' account. I tried to
run it logged in as myself using "runas", but the command prompt
window disappears as soon as I enter the password for the
'postgres_test' account. I'm running this via a terminal server
window, in console mode. The server is in a datacenter across town.

This is driving me nuts.  Does anyone know if there are any other
methods of creating a 2nd instance of Postgres (on Windows) besides
running initdb?

In response to

pgsql-general by date

Next:From: Craig RingerDate: 2011-06-01 01:29:39
Subject: Re: Consistency of distributed transactions
Previous:From: Bosco RamaDate: 2011-06-01 00:35:42
Subject: Re: Postgres 8.3.5 - ECPG and the use of descriptors and cursors in multi-threaded programs

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group