Re: pgaccess
От | Oliver Elphick |
---|---|
Тема | Re: pgaccess |
Дата | |
Msg-id | 1015265145.1405.35.camel@linda обсуждение исходный текст |
Ответ на | pgaccess ("Eduardo José Hernández Cisneros" <ejhernand3z@hotmail.com>) |
Список | pgsql-general |
On Wed, 2002-02-27 at 22:34, Eduardo Jos Hernndez Cisneros wrote: > Hi, I am a new user of PostgreSQL and a new user of RedHat Linux 7.2. I > installed PostgreSQL 7.2 (http://people.redhat.com/teg/pg/) I would like to > use "pgaccess" to manipulate my databases, but when I run: > > %pgaccess atpcdb > > I got this error: > > Error trying to connect to database 'atpcdb' on host localhost. > PostgreSQL error message: Connection to database failed > Could not connect to server: Connection refused > Is the server running on host localhost and accepting TCP/IP connections on > port 5432? > > I suppose that I need to add -i option to the database server (postmaster) Not unless you _want_to enable TCP/IP access. If you have nothing at all in the host field in pgaccess' connect dialog, it will use Unix sockets instead. If you have "localhost" it uses TCP/IP on the loopback interface. > but in the scrip file: /etc/init.d/postgresql I do not know where to add it. > Is it right? How can I resolve this? Add tcpip_socket = yes in postgresql.conf, or use "-o -i" as an option to pg_ctl (if that is what is used in the init.d script). -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C "Give, and it will be given to you. A good measure, pressed down, taken together and running over, will be poured into your lap. For with the same measure that you use, it will be measured to you." Luke 6:38
В списке pgsql-general по дате отправления: