Re: Cannot start a cluster

2015-11-25 10:55 GMT-02:00 Léa Massiot <lmhelp1(at)orange(dot)fr>:

> Hello and thank you for your answer.
>
> > Can you check with Task Manager if the PostgreSQL server processes are
> > running?
>
> No: no PostgreSQL processes are running.
>
> About the log file:
>
> With the cluster that I can start (the one associated with the port 5450),
> if I use the command:
> windows_cmd.exe_ran_as_user_postgres> pg_ctl start -o "-p 5450" -D
> my_cluster_2 -l "D:\somewhere\pg_logs_2.txt"
> The file "pg_logs_2.txt" is created and written.
>
> With the cluster that I CANNOT start (the one associated with the port
> 5449), if I use the command:
> windows_cmd.exe_ran_as_user_postgres> pg_ctl start -o "-p 5449" -D
> my_cluster_1 -l "D:\somewhere\pg_logs_1.txt"
> The file "pg_logs_1.txt" is created but nothing is written in it.
>
> So I still have no clue about what's going wrong.
>
> Thank you for helping.
> Best regards.
> Léa
>
>
>
> --
> View this message in context:
> http://postgresql.nabble.com/Cannot-start-a-cluster-tp5875045p5875066.html
> Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>

Some questions:

Is there any chance that this port ("5449") is already in use by another
process? I believe you can check it using netstat (or any other tool of
preference of course)

Have you tried using another port number ? I know that "5450" is up and
running, but maybe the problem is related to starting two instances in
parallel, so you could test another port (e.g.: 5451 instead of 5449) while
5450 is working.

Hope it helps you finding the source of the problem.