Re: probs with 7.3 -> 7.4 on debian
| От | glenn |
|---|---|
| Тема | Re: probs with 7.3 -> 7.4 on debian |
| Дата | |
| Msg-id | 1074127689.11793.60.camel@odin.valhalla обсуждение исходный текст |
| Ответ на | Re: probs with 7.3 -> 7.4 on debian (Oliver Elphick <olly@lfix.co.uk>) |
| Список | pgsql-novice |
outstanding - thanks, this is a big relief :-)
FYI - automatic upgrade still failed, but at least I could use the
db.out I made after downgrade.
Now if only I could connect through TCP.
local connect such as:
glenn@odin$:psql mydb
works fine
tcp connect such as
glenn@odin$:psql -h odin mydb
psql: could not connect to server: Connection refused
Is the server running on host "odin" and accepting
TCP/IP connections on port 5432?
fails - tried IP addresses, and localhost etc.
ahh - check /etc/postgresql/postgresql.conf!
tcpip_socket = true
oh :-(
I read in list archives that this reveals much:
netstat -nlp|grep 5432
unix 2 [ ACC ] STREAM LISTENING 2235850
13581/postmaster /var/run/postgresql/.s.PGSQL.5432
But I think this is a good outcome? i.e. server _is_ served and
listening on port 5432?
pg_hba.conf is essentially the same as the way it was in 7.3 pre
upgrade, but with the IP6 changes now included.
Can anyone tell me what I'm missing?
Thanks
Glenn
В списке pgsql-novice по дате отправления: