| 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: | Whole Thread | Raw Message | 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)
| 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 |