Forum OpenACS Q&A: Re: Pgadmin III

Collapse
4: Re: Pgadmin III (response to 3)
Posted by Boris Kruvshenko on
Hi Patrick, I have postgres 7.4.5, and it starts the postgres with pg_ctl as:

su - postgres -c "/usr/local/pgsql/bin/pg_ctl start -D '/usr/local/pgsql/data' -s -l /usr/local/pgsql/data/server.log"

but it doesn´t recognice the -i option... so ????

Collapse
5: Re: Pgadmin III (response to 4)
Posted by Steve Manning on
No offence Patrick but the -i option is the old way of doing it ;o) now you just change a setting.

Look for the postgresql.conf file in the pg data directory and inside there change the line tcpip_socket = true.

  - Steve

Collapse
6: Re: Pgadmin III (response to 5)
Posted by Boris Kruvshenko on
Thx Steve, it works changing the postgresql.conf.