Re: pgadmin3 / postgresql newbie question

From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
To: Jonathan Schreiter <jonathanschreiter(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pgadmin3 / postgresql newbie question
Date: 2005-03-02 11:28:17
Message-ID: 1d1f8f37ea48c50803cca15987188bcc@mail.nih.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Did you start the postmaster using '-i' to allow tcp/ip connections?

Sean

On Mar 2, 2005, at 6:15 AM, Jonathan Schreiter wrote:

> hi all,
> running amd64 fedora core 3 w/ default postgresql
> 7.4.7-3. did asu - , su postgres and createdb mydb as
> explained in the postgresql tutorial. installed the
> latest pgadmin3 and am trying to connect to this
> database. as i wasn't sure what the FC3 default
> password was for postgres, i changed it to something i
> could remember.
>
> i can't seem to connect to the new database using
> pgadmin3. i have the correct IP address of the local
> computer, default port 5432, mydb as the initaldb,
> postgres as the username, and my new password as the
> password. i keep getting the error
>
> Error connecting to the server: could not connect to
> server: Connection refused
> Is the server running on host "192.168.1.24" and
> accepting
> TCP/IP connections on port 5432?
>
> i also verified the postgresql service is running, and
> that i've added the following to
> /etc/raddb/postgresql.conf:
> login = "postgres"
> password = "mynewpassword"
>
> and right underneath it:
> tcpip = true
>
> i've also disabled my local firewall and SELINUX just
> for kicks. and yes, i did a reboot.
>
> so...anyone know what else i can look at?
>
> many thanks!
> jonathan
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to
> majordomo(at)postgresql(dot)org)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marco Colombo 2005-03-02 11:51:43 Re: pgadmin3 / postgresql newbie question
Previous Message Jonathan Schreiter 2005-03-02 11:15:35 pgadmin3 / postgresql newbie question