Re: [pgsql-general] cant find postgres executable after initdb

Correction, it does not work. At least not the way i think it should.
The database does not start when i register the service with pg_ctl.
I can only start the cluster with the postgres2 user. I get the prompt back,
but i can not close the window. The dos command "exit" causes all
interaction with the dos window to disappear. Postgres will keep on running
undisturbed, but when i kill the window, it is killed too.
But i can stop the postgres server with the admin user.

I simply want to start a new cluster on windows.

after a lot of frustration, the solution is too stupid for words: restart
windows.
and then they actually make us pay for it :(

WBL

On Thu, Nov 6, 2008 at 1:10 PM, Willy-Bas Loos <willybas(at)gmail(dot)com> wrote:

> ok, when i start a new cmd window from runas, and run the pg_ctl command
> from there, the process will start.
> btw you also have to change the ownership and permissions on the
> postgresql.conf, pg_hba.conf and pg_ident.conf files.
>
> C:\Program Files\PostgreSQL\8.3\bin>runas /user:postgres2 "cmd /k"
> Will open a cmd window that stays open.
> It starts in the wron folder, so i change it to the Postgres bin. From
> there i can run the pg_ctl command and it works.
> It also works when i use pg_ctl register as an admin user, specipying the
> -U and -P options.
> BTW this is all on Windows NT 4.0
>
> It works now, but i think the error message could be improved somewhat.
>
> cheers,
>
> WBL
>
>
>
> On Wed, Nov 5, 2008 at 2:36 PM, Willy-Bas Loos <willybas(at)gmail(dot)com> wrote:
>
>> Hi,
>>
>> I have a pgsql 8.3.3 cluster running on windows.
>> I want to install another cluster, so i use initdb.
>> Because the postgres user must own the files, i use runas to run initdb as
>> postgres2 (the correct user here).
>> I've created a separate folder for the data files of this cluster. The
>> folder is owned by the admin user, but posgres2 has full control of it (ok,
>> maybe i should squeeze that down a little strictly speaking)
>> As far as i can see, that is the preferred way to create a cluster in ms
>> windows. Is that correct?
>>
>> The resulting cluster does not start with pg_ctl. The postgres executable
>> is in the bin folder, just like pg_ctl.
>> The other cluster is running.
>>
>> ##====in the cmd window:=====
>> C:\Program Files\PostgreSQL\8.3\bin>runas /user:mydomain\postgres2 "initdb
>> -D \"C:\Program Files\PostgreSQL\8.3\data_5433\" --no-locale"
>> Enter the password for mydomain\postgres2:
>> Attempting to start initdb -D "C:\Program Files\PostgreSQL\8.3\data_5433"
>> --no-locale as user "mydomain\postgres2" ...
>> ## remark from me: starts a new window in which it does initdb. window
>> closes after execution :(
>>
>> C:\Program Files\PostgreSQL\8.3\bin>pg_ctl start -D "C:\Program
>> Files\PostgreSQL\8.3\data_5433"
>> server starting
>> FATAL: postgres: could not locate matching postgres executable
>>
>> C:\Program Files\PostgreSQL\8.3\bin>pg_ctl start -D "C:\Program
>> Files\PostgreSQL\8.3\data_5433" -p "C:\Program
>> Files\PostgreSQL\8.3\bin\postgres.exe"
>> server starting
>> C:\Program Files\PostgreSQL\8.3\bin>FATAL: postgres: could not locate
>> matching postgres executable
>>
>> C:\Program Files\PostgreSQL\8.3\bin>pg_ctl start -D "C:\Program
>> Files\PostgreSQL\8.3\data_5433" -o "-p \"C:\Program
>> Files\PostgreSQL\8.3\bin\""
>> server starting
>> FATAL: ongeldige waarde voor parameter "port": "C:\Program
>> Files\PostgreSQL\8.3\bin"
>>
>> C:\Program Files\PostgreSQL\8.3\bin>pg_ctl status -D "C:\Program
>> Files\PostgreSQL\8.3\data" ## <-- the other cluster
>> pg_ctl: server is running (PID: 2056)
>> ##=====================
>>
>> Cheers,
>> WBL
>> --
>> "Patriotism is the conviction that your country is superior to all others
>> because you were born in it." -- George Bernard Shaw
>>
>
>
>
> --
> "Patriotism is the conviction that your country is superior to all others
> because you were born in it." -- George Bernard Shaw
>

--
"Patriotism is the conviction that your country is superior to all others
because you were born in it." -- George Bernard Shaw