Re: QT3 Designer Pgadmin III and PgAccess Cannot connect to PostgreSQL 7.4 database

Hi,

Are you certain that PostgreSQL has been started with the -i option.
Something like:

pg_ctl start -D /path/to/data -l /path/to/logfile -o "-i"

On Mar 9, 2005, at 5:56 AM, NetSuporte wrote:

> Thanks john,
>
> It seems one "trust" had a typo.
>
> now I cannot connect to the server:
>
> ERROR : Error connecting to the server: could not connect to server:
> Is the server running on host "127.0.0.1" and accepting TCP/IP
> connections on port 5432?
>
>
> I have the following configuration:
>
> /etc/services:
>
> snip ...
>
> postgresql 5432/tcp postgres # PostgreSQL Database
> postgresql 5432/udp postgres
>
> postgresql.conf
>
> ...Snip
> # - Connection Settings -
>
> tcpip_socket = true
> #max_connections = 100
> # note: increasing max_connections costs about 500 bytes of
> shared
> # memory per connection slot, in addition to costs from
> shared_buffers
> # and max_locks_per_transaction.
> #superuser_reserved_connections = 2
> port = 5432
>
> Snip ...
>
> pg_hba.conf
>
> snip ...
>
> # TYPE DATABASE USER IP-ADDRESS IP-MASK
> METHOD
> # Database administrative login by UNIX sockets
> local all all
> trust
> #
> # All other connections by UNIX sockets
> # local all all
> trust
> #
> # All IPv4 connections from localhost
> host all all 127.0.0.1 255.255.255.255
> trust
> #
>
>
> What am I missing ?
>
> I cannot even run psql from the command line anymore?
>
>

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL