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 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. Having multiple instances running under the 'postgres' account is fine.
I often run test instances under my own local user account rather than making a user account at all, just because it's easier.
When you run initdb, are you invoking it via runas.exe as postgres_test ? Or logging in as the postgres_test user?
Your command line looks OK to me, so I'm not sure what's going on. With adjustments for paths it runs fine on my (Linux) system. I'll have a play on my Windows desktop in a bit.
-- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
