From: | Charles Tassell <ctassell(at)isn(dot)net> |
---|---|
To: | "Robert Wagner" <rwagner(at)siac(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: can't connect using the -host option |
Date: | 2000-04-14 18:02:15 |
Message-ID: | 4.2.0.58.20000414145935.009f71d0@mailer.isn.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
The host option tells your program to connect to the PG server via TCP/IP,
so you have to start your server with the -i switch, so it will accept
TCP/IP connections. If you are already using the -i switch, you should
check your pg_hba.conf file (it's in the PGDATA directory I believe) to
make sure that the machine you are connecting from has permissions to
access the database you are trying to connect to.
At 03:02 PM 4/13/00, Robert Wagner wrote:
>Dear All,
>
>Strange behaviour....
>
>I'm working in a TCL environment and use pg_connect to connect to pgsql
>databases. I want to move a suite of apps into production testing. I need
>to be able to run an app on any workstation, and connect to a database on
>any workstation on our tcp-ip network. For example, the development
>database might be on one host, but the production and QA databases on
>another. And I might want to test any database interactively...
>
>However, even if the database is ON my current workstation, I can ONLY
>connnect with the command, "pg_connect dbName". If I use the -host option,
>I get the error:
>
>Error: Connection to database failed
>User Authentication failed
>
>... strange indeed. Suggestions on making this work?
>
>Also, when I started up an identical database on a different workstation,
>even with a different port, it caused my original database on my home
>server to cease accepting connections.
>
>All suggestions are welcome. If I ask for help from Unix Admin, they'll
>tell us that we have to migrate to one of their "supported" databases, such
>as Sybase... something I 'd like to avoid!!
>
>Cheers
>Rob
From | Date | Subject | |
---|---|---|---|
Next Message | Charles Tassell | 2000-04-14 18:05:35 | Re: Unsupported frontend protocol? & config systems files? |
Previous Message | Haroldo Stenger | 2000-04-14 17:55:33 | Does error within transaction imply restarting it? |