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