- Архив списков рассылки pgsql-general

Поиск
Список
Период
Сортировка
От Daniel E. Fisher
Тема
Дата
Msg-id BEELKEGKMIBCEMJEAOMEGEBLCCAA.danfisher@bwkip.com
обсуждение исходный текст
Ответы Re:  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Re:  (Paul Thomas <paul@tmsl.demon.co.uk>)
Список pgsql-general
Entered in the pg_hba.conf file

host    all    the.machine's.ip.address 255.255.255.255
and still gives me the error that it doesn't have an entry for the servers
ip.

Warning: Unable to connect to PostgreSQL server: FATAL: No pg_hba.conf entry
for host "machine's.ip" user postgres, database nm in
/var/www/html/crohns/phpBB2/db/postgres7.php on line 79
phpBB : Critical Error

Could not connect to the database

I would also like to know how to restart postmaster to reinitialize changes
if someone could help me out on that.


in need of help,
Dan

<snip>
> This is in the pg_hba.conf file
>
> www.websiteIamusing.com   all   themachine'sIP   255.255.255.255
> trust
>
> I am sure I need to edit something yet.

"host" is a keyword (for tcp/ip connections as opposed to keyword
"local" for local domain socket connections), it is not a hostname.
Try:
host all the.machine.ip.address 255.255.255.255

Cheers,
Steve


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Alternative replication method.
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Inheritance & Indexes