From: | Léa Massiot <lmhelp1(at)orange(dot)fr> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Cannot start a cluster |
Date: | 2015-11-25 09:42:55 |
Message-ID: | 1448444575978-5875045.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Albe Laurenz | 2015-11-25 10:55:49 | Re: Cannot start a cluster |
Previous Message | Gavin Flower | 2015-11-21 20:27:44 | Re: Advice about a parent-child relation design |