Thread: PostgreSQL 8.4 won't start
Hello, I have come accross a strange thing. I had to reinstall Ubuntu and after I installed PostgreSQL (using apt-get install postgresql-8.4) when I tried to configure the password I got "Cannot connect to server. Is server running locally and accepting connections on Unix port 5432"? I never had such problem with PG before (I had 8.4.4 installed before the reinstallation of the system) I admit I haven't checked the logs or anything as it was very late at night and also I thought that it's too strange to be a typical situation like postmaster.pid issue (missing file or bogus data in postmaster.pid). Have anyone had such problems with PostgreSQL 8.4? -- Łukasz Brodziak
Łukasz, I do not have an ubuntu environment so my answer is general rather than specific, but the error message you are asking aboutis the general message postgres gives you when you can not connect to it, I have seen it on windows and linux with allof the versions of postgres I have worked with, the reasons may vary, from pg_hba not altered (most often the case forme) to postgres running on a different port. You may look around for a more specific error message. Sincerely, Kasia -----Original Message----- From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Lukasz Brodziak Sent: Monday, September 27, 2010 10:03 PM To: pgsql-novice@postgresql.org Subject: [NOVICE] PostgreSQL 8.4 won't start Hello, I have come accross a strange thing. I had to reinstall Ubuntu and after I installed PostgreSQL (using apt-get install postgresql-8.4) when I tried to configure the password I got "Cannot connect to server. Is server running locally and accepting connections on Unix port 5432"? I never had such problem with PG before (I had 8.4.4 installed before the reinstallation of the system) I admit I haven't checked the logs or anything as it was very late at night and also I thought that it's too strange to be a typical situation like postmaster.pid issue (missing file or bogus data in postmaster.pid). Have anyone had such problems with PostgreSQL 8.4? -- Łukasz Brodziak -- Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-novice
On 28 September 2010 18:03, Lukasz Brodziak <lukasz.brodziak@gmail.com> wrote: > I have come accross a strange thing. I had to reinstall Ubuntu and > after I installed PostgreSQL (using apt-get install postgresql-8.4) > when I tried to configure the password I got "Cannot connect to > server. Is server running locally and accepting connections on Unix > port 5432"? In addition to Kasia's response: check the postgresql.conf to see which interfaces your instance is configured to use. Cheers, Andrej
Ok the lol is on me. Didn't thought of running pg_createcluster :) got the cluster working but thanks for all the answers. 2010/9/28 Andrej <andrej.groups@gmail.com>: > On 28 September 2010 18:03, Lukasz Brodziak <lukasz.brodziak@gmail.com> wrote: >> I have come accross a strange thing. I had to reinstall Ubuntu and >> after I installed PostgreSQL (using apt-get install postgresql-8.4) >> when I tried to configure the password I got "Cannot connect to >> server. Is server running locally and accepting connections on Unix >> port 5432"? > > In addition to Kasia's response: check the postgresql.conf to see > which interfaces your instance is configured to use. > > > Cheers, > Andrej > -- Łukasz Brodziak II MU Bioinformatyka