Search Postgresql Archives

Re: pgadmin3 / postgresql newbie question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



That particular error message is typically associated with a missing 
pg_hba.conf entry that tells the postgreSQL server which remote machines to 
allow connections FROM....

# If you want to allow non-local connections, you need to add more
# "host" records.  Also, remember TCP/IP connections are only enabled
# if you enable "tcpip_socket" in postgresql.conf.

# TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK           METHOD

local   all         all                                             trust
# IPv4-style local connections:
host    all         all         127.0.0.1         255.255.255.255   trust
# IPv6-style local connections:
host    all         all         ::1 
ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff        trust
host all all 10.1.10.23 255.255.255.255 trust


Regards....

"Jonathan Schreiter" <jonathanschreiter@xxxxxxxxx> wrote in message 
news:20050302111535.65731.qmail@xxxxxxxxxxxxxxxxxxxxxxxxxx
> 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@xxxxxxxxxxxxxx)
> 



---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux