Cannot start a cluster
От | Léa Massiot |
---|---|
Тема | Cannot start a cluster |
Дата | |
Msg-id | 1448444575978-5875045.post@n5.nabble.com обсуждение исходный текст |
Ответы |
Re: Cannot start a cluster
|
Список | pgsql-novice |
Hello, Thank you for reading my post. I am a novice PostgreSQL user. ---- OS: Windows 8.1 Pro ---- PostgreSQL: 9.4.1 ---- Commands are issued in command line in "cmd.exe" ran as user "postgres". Some time ago, I created a cluster "my_cluster_1" with a database inside "my_db_1". Today, when I try to start the cluster, here is what happens: ============================================================================== windows_cmd.exe_ran_as_user_postgres> pg_ctl start -o "-p 5449" -D my_cluster_1 server starting windows_cmd.exe_ran_as_user_postgres> psql -p 5449 psql: could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5449? could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5449? ============================================================================== Question 1: How can I investigate what the problem is? Is there a log file somewhere? Question 2: Given the messages above, can you see what's wrong and how to fix the problem? Note that I do not experience this problem with another cluster that I have: ============================================================================== windows_cmd.exe_ran_as_user_postgres> pg_ctl start -o "-p 5450" -D my_cluster_2 server starting LOG: database system was shut down at 2015-11-25 10:29:17 CET LOG: database system is ready to accept connections LOG: autovacuum launcher started windows_cmd.exe_ran_as_user_postgres> psql -p 5450 psql (9.4.1) WARNING: Console code page (437) differs from Windows code page (1252) 8-bit characters might not work correctly. See psql reference page "Notes for Windows users" for details. Type "help" for help. postgres=# \c my_db_2 WARNING: Console code page (437) differs from Windows code page (1252) 8-bit characters might not work correctly. See psql reference page "Notes for Windows users" for details. You are now connected to database "my_db_2" as user "postgres". my_db_2=# ============================================================================== Thank you for helping. Best regards. -- View this message in context: http://postgresql.nabble.com/Cannot-start-a-cluster-tp5875045.html Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
В списке pgsql-novice по дате отправления: