Re: Connecting to the database server
От | LWATCDR |
---|---|
Тема | Re: Connecting to the database server |
Дата | |
Msg-id | 8c38cea40801111058h6e59cc09ycec8282bcf25cb90@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Connecting to the database server (johnf <jfabiani@yolo.com>) |
Ответы |
Re: Connecting to the database server
|
Список | pgsql-novice |
Thanks I did move on to pg_hba.conf but no joy yet. I turned off ipchains since this box is inside our firewall and I am just testing for now. I added these lines to pg_hba.conf and restarted postgres host all all 192.168.100.0/24 ident sameuser host phone all 192.168.100.0/24 trust I now get a message saying that the server terminated this connection unexpectedly. Any ideas? On Jan 11, 2008 11:30 AM, johnf <jfabiani@yolo.com> wrote: > > On Friday 11 January 2008 08:22:46 am LWATCDR wrote: > > I think I got the data moved over from my old server. Now I am trying > > to connect to the server with pgadminIII > > I went into the postgers.conf and made these the changes I thought I > > needed for me to log on and I did a restart but it is still telling me > > that it can not connect. > > Also I am getting a problem when I try to install the pg-DBD from yum. > > I probably just need to go perl to install that I hope. > > > > # - Connection Settings - > > > > listen_addresses = '*' # what IP address(es) to listen on; > > # comma-separated list of > > addresses; # defaults to 'localhost', '*' = all # (change requires restart) > > port = 5432 # (change requires restart) > > max_connections = 100 # (change requires restart) # Note: > > increasing max_connections costs ~400 bytes of shared memory per # > > connection slot, plus lock space (see max_locks_per_transaction). You # > > might also need to raise shared_buffers to support more connections. > > #superuser_reserved_connections = 3 # (change requires restart) > > #unix_socket_directory = '' # (change requires restart) > > #unix_socket_group = '' # (change requires restart) > > unix_socket_permissions = 0777 # octal > > # (change requires restart) > > #bonjour_name = '' # defaults to the computer name > > # (change requires restart) > > > > # - Security & Authentication - > > > > #authentication_timeout = 1min # 1s-600s > > #ssl = off # (change requires restart) > > #password_encryption = on > > #db_user_namespace = off > > > > # Kerberos > > #krb_server_keyfile = '' # (change requires restart) > > #krb_srvname = 'postgres' # (change requires restart) > > #krb_server_hostname = '' # empty string matches any keytab > > entry # (change requires restart) #krb_caseins_users = off # > > (change requires restart) > > > > # - TCP Keepalives - > > # see 'man 7 tcp' for details > > > > #tcp_keepalives_idle = 0 # TCP_KEEPIDLE, in seconds; > > # 0 selects the system default > > #tcp_keepalives_interval = 0 # TCP_KEEPINTVL, in seconds; > > # 0 selects the system default > > #tcp_keepalives_count = 0 # TCP_KEEPCNT; > > # 0 selects the system default > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 9: In versions below 8.0, the planner will ignore your desire to > > choose an index scan if your joining column's datatypes do not > > match > > I'm no expert but I think your postgres.conf is just fine. You should be > looking in pg_hba.conf > > -- > John Fabiani > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend >
В списке pgsql-novice по дате отправления: