Help with remote connection to remote Postgresql 8.3 Server...

Поиск
Список
Период
Сортировка
От hobbes
Тема Help with remote connection to remote Postgresql 8.3 Server...
Дата
Msg-id c6ca4b7b-e695-4285-9e6f-ea617e33f74b@a9g2000prl.googlegroups.com
обсуждение исходный текст
Ответы Re: Help with remote connection to remote Postgresql 8.3 Server...
Re: Help with remote connection to remote Postgresql 8.3 Server...
Список pgsql-general
Hi Guys,

I have been trying to get my local (windows) machine's PgAdmin II to
connect directly to a remote Linux (Debian) Server where Postgresql
8.3 is installed.

I have set in my postgresql.conf (remote):

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)

and set in my pg_hba.conf (remote):

# TYPE      DATABASE    USER        CIDR-ADDRESS          METHOD
# "local" is for Unix domain socket connections only
local       all             postgres                trust
local       all             all                                   md5

# IPv4 local connections:
host        all         all        0.0.0.0/0     md5
hostssl    all        all        0.0.0.0/0     md5

# IPv6 local connections:
host        all             all             ::1/128               md5

But I am still unable to connect to the server using the "postgres"
user.
Could some one enlighten me what I could be doing wrongly?

Thanks...

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Psql crashes with Segmentation fault on copy from
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Help with remote connection to remote Postgresql 8.3 Server...